Solved

I created a set of timeseries via the API. The Python examples do not show how to include an externalId nor do they say one is really needed. Looks like they need one, otherwise they don’t work in Charts. That’s all fine. My problem now is to add the externalId to existing timeseries.I think the right way to do this is with a transform, but I can’t get it right. I can get it to preview correctly, but it fails when I run it.My transform is:Select name as name, concat(name,"123") as externalIdfrom `_cdf`.`timeseries` where dataSetId = 8883655420989208;The error is Request with id 2463250f-1635-9a05-aa9a-709366e80349 to https://westeurope-1.cognitedata.com/api/v1/projects/rok-buandcollaborators-53/timeseries/update failed with status 400: Time series not found. Missing externalIds: [Tank-401-01-TT123].Looks like it’s trying to query for the timeseries with that externaId when I’m trying to set the externalId. How do I get it to set the value?

How to fetch all the timeseries linked to an asset? I have a root asset that has 16 child assets. Each of those child has 18 timeseries objects. How do I write a code so that I can loop through this setup and read each of those timeseries objects and read the datapoint for a particular day and gather them. root = client.assets.list(name='liquid_asset')children=client.assets.list(parent_ids=[root[0].id])for i in children: print(i.time_series)Result is this: <bound method Asset.time_series of <cognite.client.data_classes.assets.Asset object at 0x3468500>>I could not iterate through the i.timeseries and read the datapoint from a very specific timeseries object named as 'PVOL'. Please help. 

Hi, I am doing the Open Industrial Data Hands-on course, I have added the collection using the url provided in the course and I get errors every time I make API request, i get an error message + the collection i added is different that what is shown in the video, It has a different name, contains some variables. I am new to postman and i don’t undertsnad what it mean, can anyone please explain this error ?   

Hello, I am trying to create a row instance in my data model that references multiple other types, via the REST API.I can do that fine with single relatioships, but when I get the ErrorCannot ingest into a connection property: supportingCast in view 'Film:Actor/xxxxxxxxxxx'.when I try an array of types like this:{ "externalId": "Oppenheimer", "space": "imdb", "lead": { "externalId": "CillianMurphy", "space": "imdb" }, "supportingCast": [ { "externalId": "EmilyBlunt", "space": "imdb" }, { "externalId": "RobertDowneyJr", "space": "imdb" } ]}The supportingCast property is the problem is this case.

Hi,We can resize the column width in the instance view in FDM, but if we scroll down to load more instances, the column width goes back the the default one. Could you help have a check if that is a bug in the UI?After resize to the externald column:After scroll down:Regards,Xiaofeng

Hi,Currently we have a limit on the POST models/instances where we only allow to post 1000 instances at a time.This operation is currently limited to 1000 nodes and/or edges at a time.Normally between the instances there are dependencies so it is not very easy to split the request to multiple calls. Do you think it is possible to lift that limit to a big number, f.ex. 10000? Regards,Xiaofeng

I uploaded a CSV into a raw table in cognite data fusion. Now I have seen the raw table and see 200 numeric columns and 2 text columns are present. When i come to SDK and retrieve the rows from the same table as dataframe, it is showing 199 columns as numeric and 3 text columns. there was one specific column '0NA' which was originally a numeric column now shows the datatype as 'object' instead of 'float64'. I checked and there are no null values and no other NaN characters and it's just decimal values all across. When I fetch all numeric columns directly from CSV, I see the column as float-64 but after importing that CSV into RAW table, it is doing something else. I tried to see the unique values in the column and found these two as string,I suppose. In CSV , they were stored as number but when uploading to RAW table, it does convert into something like this. Please help if RAW table cannot accommodate values with more than 10E142 values such as these?. How to handle this scenario.'241

Hi,we are looking for a 2D file/diagram viewer compatible with https://developer.cognite.com/api/#tag/Annotations to be used inside our own application, that is outside of the Cognite application suite.Question: What are the current plans regarding opening “Unified File Viewer” in a similar fashion as https://github.com/cognitedata/reveal?Bonus question: Is it / would it be possible to annotate other things than asset tags?

Hello,We are trying to fetch the edges of an view in a graphql.But graphql is returning only 50 edges at max. We see the cursor option in graphql, but it seems that it has been not implemented and is giving null even if there exists more data.So question is - When the cursor functionality for edges will be avaialble in graphql or some know issue as of now ? If this is a limitation how do we get edges data joined with the view data where the edge is present using the rest endpoints. Any best combination suggested as there will be multiple stages to resolve the cursor and the edges data, as we understand it.Request your quick ideas on this how it could be achieved.

Could you tell me how to watch time series change of cubemaps in Cognite Remote, please.Now, I can create an event data and a specific time cubemap, upload and fit them to CAD model.Next, should I upload one event data and cubemaps at multiple moments having same station ID in meta data?Or, could you tell me a better way if you know, please.Thanks in advance.

I was trying to check SDK creating an asset hierarchy along with children (16). I created it in a improper structure and wanted to delete all of them and redo it from scratch. When i try deleting it, i am getting an error.   client.assets.delete(i.id)CogniteNotFoundError: Not found: [{'id': 1035393670500031}]The API Failed to process some items.But when i see the list for the parent id, I am to list all of the ids completelyassets_subtree = client.assets.list(asset_subtree_ids=[3043982824375333])for i in assets_subtree:    if i.name != 'LPM_YT_MODEL':        print(i.id,i.name,i.description) 

Hi  Team, I’m taking the “Introduction to CDF transformations” course. I’m unable to find the “Managed Staged Data” in the Integrate or in overall Session. Can someone share me the navigation? 

I have a daily feed data of the form coming as a file in sharepointDate AX1 AB1 AW1 AN1 AR1 AB1 BW1 BG1 BT1 01-01-2023 0.23 1.23 2.54 0.98 0.655 1.09 0.87 0.34 0.19 01-02-2023 0.34 0.56 0.44 0.89 0.576 0.81 1.29 1.11 0.67 …... ….. ….. …... …... …... …... …... …... …..  I need to pull this data and transform it into an applicable resource-type (Sequences in CDF). I don’t want to store as time series since I need this in tabular form to operate further and do matrix and dot product etc. Is there a way to write a transformation to push it as ‘sequences’ so that I can use it as a matrix to perform further calculations?Please share some example SQL transformation snippets to achieve this. 

Hello data modeling team, I tried the "first" and "after" filter on Query Explorer which enables us to retrieve the query result page by page, it works well.while we have an existing API which enables the consumer to specify an "offset" and a "limit" parameter. by the offset, the consumer could retrieve records at any specific page without the need to always go though from the beginning and then retrieve page by page, it's like the skip and limit syntax in mongodb, for example, db.myCollection.find().skip(200000).limit(50).we want to keep the API behavior so no modification needed for existing consumer, while we do not want to simulate the offset behavior by retrieving page by page within our own API since it will be very low efficient when there is a big dataset, so is it possible to provide the offset supporting in Cognite ? or any suggestions/methods we could try to implement this ? Thanks! 

Hi, I am looking for documentation regarding what kind of DM structure change is considered as safe change, breaking change or unsupported change in the data modelling but couldn’t find it.  And is it possible to provide best practices for DM versioning management? Kind advice.Thank you, Kind regards, Carrie 

I want to pass the configuration and queries from the extractor pipeline to extractor (Cognite DB Extractor) which is I am running from my local but not able to start the extractor.Currently referring this doc: Configure extractors remotely | Cognite Documentationbut there is no sample for configuration file.or is there is way for passing queries for data extraction through extraction pipeline?

Hi I have created a Cognite File Extractor from a local folder, and I want to create a log of all runs in a sub-folder. When changing the log level on the console and adding file as storage, nothing changes.  from config file: logger:  console:    level: DEBUG  file:    level: INFO    path: ".\\logs\\log.txt"  //also tried with full path    retention: 7 Are there some more steps to get the logger to change?I have run it both as local and admin. Hedda

I am running a transformation where in IN Clause I am giving values by selecting from mapping file in raw (which stores value as Item1, Item2)but not getting any desired results (giving 0 rows but not giving any error)e.gSELECT * from tableNamewhere columnName IN (SELECT propertyName from rawDB.mapping where columnName=Id)  

Hello Cognite Community,I'm currently in the process of deepening my understanding of the Cognite Python SDK, and I've encountered some hurdles that I believe this community could help me overcome. I'm working with a time-series dataset and aiming to use it to make machine learning-based predictions. To facilitate a more comprehensive response, I've provided a snapshot of the data I'm working with and detailed my queries below.Dataset Structure: The data comprises 5 columns: time, ws_E05, ws_E06, wp_true_E05, wp_true_E06. The 'ws_E05' represents the true wind speed at location E05, and 'wp_true_E06' signifies the true wind power at location E06.Query 1: I plan to utilize this dataset to forecast the subsequent 10 minutes using Linear Regression in the Python SDK on Cognite. Could you advise me if the present state of this time-series data is sufficient to get started, or are there certain modifications or preprocessing steps I should consider? I'm also interested in visualizing this da

Attn. @Jatin Sablok We found some issues with the Cognite pre-built OPC-UA extractor’s automatic re-connection to OPC server and to CDF as detailed in the test cases below.OPC-UA server reconnect test: OPC server is online and Cognite OPC-UA extractor is started. Then OPC server is restarted. Cognite extractor loses connection to OPC server, and is unable to re-connect automatically even after OPC server comes back online later. Extractor service has to be manually restarted to re-connect to OPC server.CDF reconnect test: Cognite OPC-UA extractor is started with network connection cable to CDF unplugged. Extractor log shows error messages. And extractor is unable to connect to CDF automatically even after network cable is plugged back in. Extractor service needs to be manually restarted to connect to CDF.Logs from both tests are attached. Could you please review them and let us know if these are known issues?

Hello everyone,I recently completed the Cognite two courses Cognite Data Fusion Fundamentals & Data Engineer Basics - Integrate and received my certificate. While I appreciate the recognition of my achievement, I noticed that my name is not mentioned on the second certificate, only an image with the text "Cognite Data Engineer Integration" and a badge. Is somebody else is also facing similar issues?Thank you. 

Hi Team,Have completed the Learning Path CDF: Integrate, but it wasn’t reflecting as completed even though it was showing 100% completed. It was blocking me to move forward for next Lesson Working with CDF: Contextualize.Please help with this… (attaching the snapshots of completion and error)-Pavan

Hello,I’m facing following error while creating an asset in Hands-On:CogniteAPIError: Resource not found. This may also be due to insufficient access rights. | code: 403 | X-Request-ID: d75b2c0d-f96b-9efc-8dbc-6aef50e25dff The API Failed to process some items.But able to read data and create a dataset.Please kindly advise.Regards,Asan

How to create IFSDB in events?

I have created a Flexible Data Model and now want to populate it from my source data. I have switched to the Mapping editor and am choosing my source data:The data I want to use is in a dataset linked to a pipeline and is not in the Staging area. How can I get the data from my dataset into my model?