Solved

Doing the ‘hands-on’ for Data Engineer Basics - “Learn to Use the Cognite Python SDK “ Course."I have done the following:Make a dataframe from reading from a csv file: One of the columns in the csv file is ‘region’. The 5 different values in the region column are  When the above code is run, the  following appears on the screen: Q1. Does this mean pandas has interpreted the region “None” as “nan”? If so that would explain why the following code throws “ValueError: Out of range float values are not JSON compliant. Make sure your data does not contain NaN(s) or +/- Inf!”  I would value your guidance as I have not worked with pandas() much at all.Thank you,Doug  

Hi everyone,  I would like to know if there are timeout restrictions for functions, as I've been executing a function that reads data from a RAWs table in batches, and since there are many records (1M), it takes up to 10 minutes and I get a timeout error. Is there a way to configure this restriction? Running the same function code on a local machine takes around 2 or 3 hours. Regards,Karina Saylema@Aditya Kotiyal  @HanishSharma  @Jason Dressel  @Jairo Salaya @Liliana Sierra   

Hi, I’m doing the Learn to Use the Cognite Python SDK module in the Data Scientist basics seems incorrect.For example, I’m in the notebook `2_List_Search_Retrieve.ipynb` and the data presented appears to be very random, and not industrial data. When I run a query like:`c.assets.list(metadata={'ELC_STATUS_ID': '1211'},limit=5)`  this comes back empty because there is no industrial data in any of the the datasets. In fact, almost all of the datsets in the c.data_sets.list() command are Deprecated and archived.It looks to me like potentially the datasets are tests that people have made. I would really like to be able to see some more realistic data in the dataset used for exploring the tool. Please let me know how I can do that, if anyone knows!

Hi, everyoneI'm trying to load sequences using Python SDK by inserting dataframes. In the dataframe, I have some columns with NaN and numeric values. Dataframe:  and when loading NaN values, they are uploaded as 'null'. I've tried replacing them with empty strings, but due to the column definitions, if I have numeric values, the column's data type must be Double or Long, and conflicts arise when encountering empty strings.This is the code to load a sequence: Results in CDF using Python SDK: However, when loading the sequence via DB-Extractor, empty strings are uploaded as such and not as 'null' Is there any way to load via SDK so that NaN values are uploaded as empty and not 'null'?  Regards,Karina Saylema@Aditya Kotiyal  @HanishSharma  @Jason Dressel  @Jairo Salaya @Liliana Sierra  

Hi, EveryoneHow can sum several time series? For example:Times series # 1Times series #2How can sum these time series if the filter just taking one id ts{id=001}Regards, Liliana Sierra@Aditya Kotiyal  @HanishSharma  @Jason Dressel  @Jairo Salaya 

Exploring Cognite CDF

I am trying to trigger multiple workflow through function. I have a function(function name = "wk-func") that will trigger workflow instances(workflow name = ra-wkflw'), it has for loop , number of times workflow instances to be created, keeping in mind instances limit to be 50, still it is giving error for run on even 2 isntances, Function has following handle: def handle(client,handle):      for chunk in chunks(list,2):            workflow_input = {            "abc":data['value']        }        run = client.workflows.executions.trigger(            workflow_external_id='ra-wkflw', version=1,input=workflow_input        ) Its working if I run at my local IDE with passing the client details and trigger function handle. It triggers multiple workflows without any error.However, On running function using SDK,input_data = { ‘abc’:’hey’}client.functions.call(external_id ="wk-func", data = input_data)Function is completed, however, workflow instance is not being triggered and following error i

I have a calculation on a chart that was working well for quite a while, Then there was a network issue that stopped the data source from streaming data (this is the big triangular shape in the image below). Even though the data streaming got restored a short while after that, the issue I have is that the calculated value (the brown line) never got back to working. There was a short blip of time where it looked like it was working but that was just random values for a while. Does anyone know where I can see any logs associated with this calculation? I know you can’t edit the calculation - you have to delete it and create a new one - I guess I will likely do that but would also like to find out what the reason is for this calculation just stopping and not restarting properly?  

Hi. For some reason my events retreived via the CDF data source for Grafana come with time stamps in epoch format:In the examples given in the documentation, events are returned with a human-readable time format. Any idea what I am doing wrong here?

Doing the ‘hands-on’ for Data Engineer Basics - “Learn to Use the Cognite Python SDK “ Course."The instructions said “Make sure that the data set is write-protected”. So I had under Step 1:I then ran without error:That was YESTERDAY.TODAY, the 2nd block of commands threw an error: “CogniteAPIError: Resource not found. This may also be due to insufficient access rights. | code: 403 | X-Request-ID: f9083e61-8310-9462-9fb6-69f8da1299f3”So, after trying this and that, I changed the generated data_set to write protected = False in the 1st block of code above. --- >  The 2nd block of commands now works, just like YESTERDAY. Q1. Why did  ‘write protected = True’ work YESTERDAY, but not TODAY, giving Error 403?Q2. Why does ‘write protected = False’ work, but not ‘write protected = True’ , TODAY, that is?From where does this inconsistency come? Someone?Thank you!Douglas  

Hello! I am trying to follow along the Data Engineer Learn module. There are hands on exercises that needs me to install jupyter notebook - i used pip to do that. In the notebook 1_Authentication.ipynb, the package cognite is needed:from cognite.client.credentials import OAuthInteractivefrom cognite.client import CogniteClient, ClientConfigreturns the error---------------------------------------------------------------------------ModuleNotFoundError Traceback (most recent call last)Cell In[5], line 10 1 ## !pip3 install cognite 2 ## !pip3 show cognite-sdk 3 ## !pip3 show cognite-sdk (...) 8 #import cognite.client 9 #from cognite.client import CogniteClient---> 10 from cognite.client.credentials import OAuthInteractive 11 from cognite.client import CogniteClient, ClientConfigModuleNotFoundError: No module named 'cognite.client' I am able to install cognite using pip to version 0.04. However poetry add cognite in the ‘using-python-s

Hi All,In C# SDK Upload link description says it provide link to upload file in GKS. Does it work if CDF is hosted on Azure as well.  

We would like to have the ability to: Import directly from CDF to a geodatabase hosted in MS SQL Serverand/orHave the ability to view vector points, lines and polygons within ArcGIS Pro, ArcGIS Enterprise, and ArcGIS Online, with the ability to view and query the attribute tables, and modify symbology Have the ability to view such data in a web map either directly from a service or publish our own feature servicesA WFS may be suitable, but we would have to check with a sample service first.Can you help please?Thanks,Tim

I notice that i have three Tenant ID in my AAD count.I think i should use the Cognite Hub Tenant ID,It’s that right?when I try to create a new application,  Azure told me I have no access to create a application.Am I doing it right?  Which Org should I apply the permission to create an app under this tenant, RA or Cognite Hub? 

Hi Team,I am trying to do the Python SDK Transformations course and got stuck here when running the code, can you please help me what I am missing here? Thanks,Navyasri Indupalli

Hello all,Having some challenges with the hands-on section of the training material. I have some authorization issues based on the error message below. Any suggestions on how to fix it ? 

My colleague sent me a pic, it’s from a demo project named “essc-sandbox-44”, we need the project to show to the customer to win this opportunity, But we don’t know who is the owner in this project, how can  i contract the owner and join this project?the project maybe in this domain.https://ftdatamosaix.fusion.cognite.comthank you 

I want to purchase the Cognite credits for me and my team for completing the certification. Unfortunately, I am not able to click on the purchase button.Am I missing something, can you please guide me.   

Hi everyone, I'm loading sequences from a file that has 11 million rows, and I would like to load it in batches, where each batch is a dataframe. As I load by batch, the rows that the sequence already had are being deleted, leaving only the last batch. How can I load each batch without deleting the previous one? This is the code I use to read the file in batches and load rows into the sequence. It is assumed that the sequence is already created. Regards,Karina Saylema@Aditya Kotiyal  @HanishSharma  @Jason Dressel  @Jairo Salaya @Liliana Sierra    

In CDF Fundamentals class for Cognite Charts it states that one can merge the both y axis for Sunction, Discharge and Delta, but it doest state how its done. Any guidance on how to merge or make sure chart only shows one y axis?   

Hi All,I am trying to update data in RAW table. I am using below code but after executing it either column values are not modified or sometimes all the columns shrink under one columns as ({} columns) and column data is also not updated in that case. var row = confModel.RawRow as RawRow<Dictionary<string, JsonElement>>;if (row == null){    return;}var currentDate = DateTime.Now;var utcDate = currentDate.ToUniversalTime().ToString("u").Replace(" ", "T");row.Columns[UpdatedBy] = GetJsonElement(JsonValue.Create("SYSTEM"));row.Columns[SimulationStatus] = GetJsonElement(JsonValue.Create(status.ToString()));row.Columns[UpdatedDate] = GetJsonElement(JsonValue.Create(utcDate));var rawRowCreateColl = new List<RawRowCreate<RawRow<Dictionary<string, JsonElement>>>>();var rawRowCreate = new RawRowCreate<RawRow<Dictionary<string, JsonElement>>>();rawRowCreate.Key = confModel.RowKey;rawRowCreate.Columns = row;rawRowCreateColl.Add(rawRowCreate);tr

Hi Team, Could you please provide more attempts on the Working with Cognite InField - Assessment 

I want to complete Data Engineer Basics-Integrate but unfortunately for the access I need Purchase with 2 Credits.Can someone advise on this RegardsAmelia 

Hi, everyoneI'm trying to load a CSV file using db-extractor. This is the configuration I'm placing in the .yaml file : but I'm encountering the following error: It seems that the error might be that the query section doesn't recognize the sheet name. I checked that the sheet name matches by opening the file in Excel format, but the error persists. I also loaded the same file in .xlsx format and it loaded without any problem.  How should I specify in the query so that it takes the correct name in CSV format? Regards,Karina Saylema@Aditya Kotiyal  @HanishSharma  @Jason Dressel  @Jairo Salaya @Liliana Sierra   

I want to complete Data Engineer Basics - Integrate so, How to purchase 2 credits for Data Engineer Basics - Integrate?