Community Discussions

I have a transformation that is to write to a new dataset as seen here:SELECTconcat('CWS:',loc) as externalId,IF(parent_loc='' OR parent_loc IS NULL, '', concat('CWS:',parent_loc)) AS parentExternalId,CAST(lastUpdatedTime AS STRING) AS name,to_metadata(*) AS metadata,description AS description,7089382776719091 AS dataSetId FROM `CWS-Assets-DB`.`CWS-Assets-Tbl` The Preview seems to work fine.When RUN: I get following error:Request with id 96f4a082-9dde-9b41-8065-0b3cf0923197 to https://az-eastus-1.cognitedata.com/api/v1/projects/ra-istc-sandbox/assets/byids failed with status 403: Resource not found. This may also be due to insufficient access rights..The permissions on the dataset for my user group is raw:readraw:writeraw:listdatamodels:readdatamodels:writedatamodelinstances:readdatamodelinstances:writedatasets:readdatasets:writedatasets:ownertimeseries:readtimeseries:writefiles:readfiles:writeevents:readevents:writesequences:readsequences:write3d:read3d:create3d:update3d:deletetransfo

If  publishing a datamodel with TimeSeries attributes defined(like below)in the UI, it will fail with an error message:type Property {  modelName: String  value: TimeSeries} 

I am able to login with clientID and client Secret to our test project using cdf cli. Also the “cdf dm create” is working. However, when publishing a graphql using “cdf dm publish” there was always a validation error even using the demo GraphQL data model. Below is the error message:$ cdf dm publish --file=./test.graphql --external-id="testgraphql1" --space="testgraphql1" --version 1 --verbose2023-02-28T13:24:31.576Z cdf:middleware:auth Fetching auth token from CDF...2023-02-28T13:24:31.577Z cdf Getting token via Client Secret2023-02-28T13:24:31.578Z cdf:auth:client-secret Starting to aquire client credential token2023-02-28T13:24:32.032Z cdf:middleware:auth Finished fetching auth token from CDF2023-02-28T13:24:32.038Z cdf:data-models:publish dataModelVersionsHandler initialized2023-02-28T13:24:32.038Z cdf:data-models:publish Reading graphql file ./test.graphql2023-02-28T13:24:32.039Z cdf:data-models:publish Schema contents 'type Actor {\r\n' + '  name: String!\r\n' + '  age: Int\r\n'

In Charts, we have been using the “Shift Time Series” function (for creating a new Calculation time series) to assess data more effectively, but have now noticed a limitation where the calculation is limited to the data from the source time series already displayed.  If you look at the first image below (just a 10-min shift), you can see in the green calculation that there is a gap on the left where the calculation doesn’t exist due to the source data being “off the page”.  If we go to a more extreme scenario (2nd image below), now of the data shows since we are attempting a 2+ day shift in a time series.  Is there a solution where this limitation can be removed?  For our scenario specifically, we are looking closely at (and comparing) three separate incidents that lasted about 1 minute each, but were spread out over the course of a week, so we are super zoomed in to look at the behavior signatures.  Thanks for the input!Kind regards,Richard10-minute shift​​​​​ Multiple-day shift 

I have asset hierarchy table and time series table imported, but I want to link asset to timeseries or vice-versa. asset hierarchy table looks like:level 1, level 2.e1, entity 1;level 1, level 2.e1, entity 2;level 1, level 2.e2, entity 3;time series table looks like:t1, entity 1, x1, y1t2, entity 1, x2, y2when I click asset entity 1 in Explore view, it shows time series data count but the name and description of the time series are empty; when click time series, the count of linked Assets is 0. I do not know how to fix the issue.  

I might need to create 100,000s - 1,000,000 of individual timeseries. I would like to understand if the number of timeseries impacts the API performance. e.g. retrieving data points for 1 of the timeseries. Would the API response be similar if I had 100 or 1 million timeseries?Also is there a maximum number of timeseries that can be created per CDF project?

Learn Cognite 3d model, focus object, fit camera, search assets highlight object etc..

Hi.Would it be possible to change the name format of the CSV file downloaded from cognite charts? The colon in “New chart 2023-02-22 15:43:59 (timeseries).csv” makes it difficult to unzip the file on Windows.

While using cognite-sdk-dotnet, it needs API key whereas I have client-id and secret with me. How can I get the API key for the same? Or there is some alternative way to work with client-id and secret.

I am trying new FDM APIs. In POST endpoints I am facing issue “Missing body for POST request”Am I missing some parameters? I am using POST body as per documentation 

Is there documentation for the import calculation json in Charts? 

Using transformations to create/update data can be cumbersome especially for complex FDM models. I understand there are plans to generate APIs from models, but are there any alternatives in the short term, such as implementing GraphQL mutations? Are the APIs used by transformations internal to CDF?

Hi All, I am getting error while importing CogniteClient from cognite.experimental.Please refer the below screenshot of the error.    

I’m experimenting with filter nodes https://pr-ark-codegen-1646.specs.preview.cogniteapp.com/v1.json.html#tag/Instances-(New)/operation/advancedListInstance using a payload like:{  "includeTyping": false,    "sources": [        {            "source": {                "type": "view",                "space": "jca-domain",                "externalId": "Facility",                "version": "0_3"            }        }    ],  "instanceType": "view"}It seems to return entities not of the type of the given source (Facility/0_3). For example it returns Equipment/0_3 entities. Is this the expected behavior and do I have to separately filter for view type? If so how do I do that? Thanks.

We planned to Download 3d files from CDF - fundamentals through API , However I can able to find correct API for this. Can anyone explain which api will for work this scenario and what is the concept of asset when  models addition. 

On behalf of Celanese Clear Lake Utilities super userDoes Charts currently support the option to create cumulative sum calculations? For example, when calculating total usage/consumption of fuel gas across the site, the user usually has to get the individual data points from the raw data sources and then do the calculation manually in an excel sheet. The user has to repeat these calculations every month.Could Charts potentially automate this calculation to provide real-time data to display a summary of data as it grows over time for consumption/usage? Also, would Charts be able to “reset” this calculation every month?  

I realizd that when leveraging Cognite REVEAL in application development, can we not have Point Cloud/360 Images annd 3D in one REVEAL? Why do i have to select which one? is that not embedded within the same where i can turn on or off the Point Cloud or 360 Images?

Hi, I am trying to use the Data Modeling API (https://pr-ark-codegen-1646.specs.preview.cogniteapp.com/v1.json.html#tag/Instances-(New)/operation/applyNodeAndEdges) to create instances of Views I have defined, including a reference property from one view to another. The reference property in the view looks like this:                "facility": {                    "type": {                        "space": "jca-domain",                        "externalId": "EquipmentFacility"                    },                    "source": {                        "type": "view",                        "space": "jca-domain",                        "externalId": "Facility",                        "version": "0_1"                    },                    "direction": "outwards"                }I’m not including the whole definition as it is kind of lengthy, but basically there is a Facility view and an Equipment view, and the above property is on the Equipment so I can link it to a Facility. I am able

Unable to view all the values in the source field drop down for a events page in CDF UI. In the image below , for the source field drop down,over the left side, i am not able to see all the values expected . It’s showing only few values. 

Hi… Knowing that there are locations (or remote locations) with limited internet access, what would be the recommended internet/network bandwidth for 5 concurrent users in order to deploy CDF with a reasonable performance?Any experience on this matter?Thanks Gustavo

Hi, can we load public data from cdf into mySQL

Question from an end user:What is the best way to calculate the percentage of good values for a time series over a year using Cognite Charts? I have a list of PSVs in various units that I need to see if we have data availability of at least 95% in 2022.  

Hi,Let’s I have below data model created in FDM and there are 2 types Device and Sensor. Device is referring to other type Sensor.  Device  - name:String  - sensors:[Sensor]  Sensor  - name:String   - timestamp: Timestamp   - value: Float I have populated the data through transformation in this model. I wanted to check on how to get the latest timestamp and value for particular device and sensor through FDM GraphQL query.Example:Device : d1Sensor:name: s1timestamp:   2023-01-01 01:00value: 10.0 name: s1timestamp:   2023-01-02 01:00value: 20.0 name: s1timestamp:   2023-01-03 01:00value: 30.0 I am expecting to latest timestamp as 2023-01-03 01:00 and value as 30.0 

Hey, while performing Incremental filter operation, I am not able to get the exact filters I have applied for in the RangeStart and RangeEnd. Can someone help me out.Thanks Sharath

I work cognite reveal 3d images  in angular v12.1.1.  I using NPM  npm i @cognite/reveal@3.3.0 ,  @cognite/sdk@7.14.0 and  @cognite/potree-core@1.5.2,  Cognite reveal AxisViewTool is not working. error: (Module '"@cognite/reveal"' has no exported member 'AxisViewTool'.)