Developer and User Community

Join the discussions about delivering apps and data-driven decisions powered by Cognite Data Fusion. Click the + CREATE TOPIC button in the menu bar to start the conversation.

  • 671 Topics
  • 2,114 Replies

671 Topics

N
Committed
nabanitakarCommitted
asked in Developer and User Community

Can I use Asset Hierarchy in Grafana

My Question is : Is it possible to use  Asset Hierarchy in Grafana?I found many things related to timeseries  but not related  Asset Hierarchy to Grafana. Thanks. 

8
K
Practitioner
1 year ago
Divyanshi Mangal
Active
Divyanshi MangalActive
asked in Developer and User Community

Unable to sign up for grafana

I get this when I am trying to sign up from grafana with my Azure AD linked account dmangal@slb.com.Any idea how to solve this? 

4
J
1 year ago
X
Seasoned
Xiaofeng WangSeasoned
asked in Developer and User Community

Could not create transformation for edges/relationships

It seems I can create transformations for types but there is no option to select a relationship when creating a transformation to a data model. Below it shows the “Target type and relationship” dropdown only has types but not relationships. Is there anything I missing?  

6
X
Seasoned
1 year ago
W
Seasoned
Wei WuSeasoned
asked in Developer and User Community

SSL: CERTIFICATE_VERIFY_FAILED when trying to run notebook "1_Authentication" under "using-cognite-python-sdk"

I encountered the following SSLCertVerificationError when trying to run the example notebook "1_Authentication" under "using-cognite-python-sdk".  The authentication via interactive login was successful. However, it threw the SSL error when executing “client.login.status()”ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1129) I updated “certifi” as suggested in another discussion thread, but the error still exists. I’m using Python 3.9.12.ANy suggestion is appreciated.

5
M
Seasoned Practitioner
1 year ago
T
Active
tomaskurtenperezActive
asked in Developer and User Community

Error in Learn to Use the Cognite Python SDK

Getting an error on 2_List_Search_Retrieve.ipynb:c = cauth.create_cognite_client(method="client-secret")AttributeError Traceback (most recent call last) c:\Users\tomas.kurten.perez\Downloads\COGNITE\using-cognite-python-sdk\notebooks\2_List_Search_Retrieve.ipynb Cell 7 in <cell line: 1>() ----> 1 c = cauth.create_cognite_client(method="client-secret") AttributeError: module 'auth' has no attribute 'create_cognite_client'

8
Dilini Fernando
Seasoned Practitioner
1 year ago
S
Seasoned
Shreyas MehtaSeasoned
asked in Developer and User Community

Unable to publish a data model with a new version through CDF FDM UI

Below works and the data model is published.Data Model Version - 1type Employee @view(version: "1"){name: String}Next stepBelow doesn't work and I get an error "Can not change the nullability of the property\n We do not support modifying a field's 'required'ness at the moment."Data Model Version - 2type Employee @view(version: "2"){name: String!}

1
Anders Hafreager
Practitioner
1 year ago
O
Active
olejohanActive
asked in Developer and User Community

Problem with publishing FDM solution

Hi. I have a working solution in ITG. The solution is a model with Fields, Facility, Discipline_Area, Function_Area, ControlObject and Weightobject.These Object’s is grouped to ConstructionNode in relation to Facility and WeightObjects.I have started migrating to FDM.I started replicating the ITG solutions, but am having problems publishing the solution.Example with Fields and Facility:type Fields {  Key: String  IsDeleted: String  Facility: [Facility]  Field_Name: String!  Location: String  Status: String  Discovered_Year: Float  Original_Reserve: Float  Remaining_Reserve: Float  Production_Start: String  Operator: String  EpocTimeChanged: Int  PopulationSystem: String  PopulationSource: String} type Facility {  Key: String  IsDeleted: String  Fields: Fields  "Discipline_Area: [Discipline_Area]"  Name: String  Description: String  SystemFullName: String  Project: String  SubProject: String  CadID: String  SapID: Float  ComosUID: String  EpocTimeChanged: Int  PopulationSystem: String 

2
Anita Hæhre
Seasoned Practitioner
1 year ago
S
Seasoned
Sonali Vishal PatilSeasoned
asked in Developer and User Community

How to get list of all columns in the raw table?

SHOW COLUMNS IN `RawDBName`.`RAWTablename`;its throwing an errorTable or view not found: `RawDBName`.`RAWTablename`; line 1 pos 16; 'ShowColumns [col_name#28876297]

2
S
Seasoned
1 year ago
Juan Alvarado
Seasoned
Juan AlvaradoSeasoned
asked in Developer and User Community

interfaces vs. types

More of a design question: only interfaces are allowed after the implements keyword, so you have to know what types you plan to extend beforehand, but this is not always possible or reliable. Since interfaces also produce views, I am tempted to make everything an interface, but are there any downsides?

1
Anders Hafreager
Practitioner
1 year ago
S
Seasoned
Snehal-JagtapSeasoned
asked in Developer and User Community

FDM - Direct Relations in Transformations

Hi Team, I am trying to populate FDM data model using Transformation.I am using direct relationship in my model. Let say EntityRelationship View has two fields to and From which referes to Entity view. These fields are coming as Struct<String,String> as destination type intransformation.I was trying to add Space:externalId in this field. However it is giving Incompatible type error.Can you please help.Thanks,Snehal.

4
S
Seasoned
1 year ago
Chris Selph
Seasoned
Chris SelphSeasoned
asked in Developer and User Community

Transforms Creating Nulls for timestamp

Hi, I’m running a transform from Raw to insert/update Numeric values./* MAPPING_MODE_ENABLED: false *//* {"version":1,"sourceType":"raw","mappings":[{"from":"","to":"id"},{"from":"","to":"externalId"},{"from":"","to":"timestamp"},{"from":"","to":"value"}]} */SELECT dp.Tagname AS externalId,to_timestamp(DateTimeStamp, 'yyyy-M-d h:mm:ss') AS timestamp, cast(value AS double) FROM `ISTC_WW_InSQL`.`wwHistory` AS dp , --selecting from _cdf.timeseries means we select from the timeseries we ingested to CDF earlier. We do this to make sure all the time series we try to add data points to actually exist_cdf.timeseries AS ts WHERE dp.`Tagname` = ts.externalId--And to_timestamp(DateTimeStamp, 'yyyy-M-d h:mm:ss') Is Not Null  When previewing the code above, you can see some null values. Also, if you “run” the code it complains about nulls. (Not pictured.)   I think I’ve confirmed that the DateTimeStamp column in `ISTC_WW_InSQL`.`wwHistory` contains no null values.When, we UnComment the last line

2
Chris Selph
Seasoned
1 year ago
joseLB
Active
joseLBActive
asked in Developer and User Community

Notebook 1_Authentication: Cannot authenticate to Azure

Hi: I’m doing DATA ENGINEER BASICS - INTEGRATE course.Trying to execute Notebook 1, I cannot pass through the cell getting the authentication with Azure, namely:creds = authenticate_azure()Any help?P.S. I’m using Google Colab  

3
joseLB
Active
1 year ago
N
Seasoned
N G NidhiSeasoned
asked in Developer and User Community

azure devops setup

Hi Team, I am facing some issues while using the above pipeline.yaml  file setup to run the pipeline, Could you please help me doing the devops setup so that i can understand the process.I will set up a call , please let me know your available timings. Regards,Nidhi N G

1
Dilini Fernando
Seasoned Practitioner
1 year ago
J
Committed
jaydeepCommitted
posted in Developer and User Community

Cognite replicator fails to replicate asset data with inconsistent behaviour

The cognite replicator fails to replicate asset data and the behaviour is inconsistent. It worked yesterday and not working today. Note that all resource types like time series, events and datapoints are replicated consistently. I am getting below error while replicating the asset data.Please see attached screenshot for the successful run of the asset replication yesterdayTraceback (most recent call last):  File "/Users/j.subhash.parandekar/oid-replicator/oid_replicator/cognite_replicate.py", line 84, in <module>    assets.replicate(SOURCE_CLIENT, DEST_CLIENT, config=cognite_config,  File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/cognite/replicator/assets.py", line 324, in replicate    src_dst_ids_assets = create_hierarchy(                         ^^^^^^^^^^^^^^^^^  File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/cognite/replicator/assets.py", line 220, in create_hierarchy    updated_assets = replication

2
G
Seasoned Practitioner
1 year ago
X
Seasoned
Xiaofeng WangSeasoned
asked in Developer and User Community

Could not post nodes with Float properties if the value is 0 or negative

When adding a node instance with Float properties, it always gives an error “The value of property 'xxx' must be a 64 bit floating point number” if the value in the request body is 0 or negative number, but it works fine if the value is positive.Could you help take a look?

2
Anders Hafreager
Practitioner
1 year ago
N
Seasoned
N G NidhiSeasoned
asked in Developer and User Community

Azure pipeline failure

Hi Team, I am facing some issues while using the above pipeline.yaml  file setup which is suggeted by cdf team before, i am getting validation error, even after passing all mandatory fields.Could you please help me doing the devops setup so that i can understand the process.Please set up a call to work on this issue as it is impacting deliverables. Regards,Nidhi N G

1
C
Seasoned Practitioner
1 year ago
Anders Brakestad
Seasoned
Anders BrakestadSeasoned
asked in Developer and User Community

How to ensure identical DateTimeIndex in TS data from CDF and Pi (via Seeq API)

I am trying to make a comparison between time series data from CDF and from Pi (accessed with the Seeq Python API). Some questions arise:​​​​​How do I ensure that the DateTimeIndex-s that are returned are identical? Why does CDF return DateTimeIndex with dates before my start value?Examples:Pulling a raw time series from Pi via Seeq looks like this:start = datetime(2021, 1, 1)end = datetime(2021, 1, 2)spy.pull(items, start=start, end=end, grid=None, quiet=True)And the CDF analog looks like this:start = datetime(2021, 1, 1)end = datetime(2021, 1, 2)cognite.datapoints.retrieve_dataframe( external_id=external_id, start=start, end=end, granularity=None)The resulting DateTimeIndex-es are not identical:From Pi via Seeq:DatetimeIndex(['2021-01-01 00:00:00+01:00', '2021-01-01 00:00:05+01:00', '2021-01-01 00:00:10+01:00', '2021-01-01 00:00:15+01:00', '2021-01-01 00:00:20+01:00', '2021-01-01 00:00:25+01:00', '2021-01-01 00:00:30+01:00', '2021

7
Anders Brakestad
Seasoned
1 year ago
N
Seasoned
N G NidhiSeasoned
asked in Developer and User Community

Cognite(CDF) Function for azure DevOps setup

Hi Team, Please help with the current setup or process  of azure devops  to deploy Cognite (CDF) Function(API) to CDF project.

2
N
Seasoned
1 year ago
A
Seasoned
Adarsh DhimanSeasoned
asked in Developer and User Community

Client secret management in Python SDK

We are currently exploring workflow development on top of CDF python SDK. The client secret is used in the workflow code in order to connect with CDF project instance. This client secret is bound to expire after predefined interval. It will incur production downtime and manual intervention in order to update the secret.Can we have or do we have some concept similar to refresh tokens in CDF Python SDK.

4
A
Seasoned
1 year ago
A
Seasoned
Adarsh DhimanSeasoned
asked in Developer and User Community

Cognite function chaining

Can we have function chaining feature in Cognite functions where on sucess/failure status of a function we initiate another function.

4
A
Seasoned
1 year ago
K
Seasoned
Karthik KaliyaperumalSeasoned
asked in Developer and User Community

Learn Cognite API

Learn Cognite API in java script SDK.

5
K
Seasoned
1 year ago
J
Active
Jerry DabrowskiMowi
asked in Developer and User Community

Transformation SQL - check presence of a key in asset metadata

Hi all,what's the best way to write a condition in the transformation query, that checks for presence of certain key in asset metadata?Example asset metadata:"KEY": "VALUE"pseudocode:select * from _cdf.assets A where ‘KEY’ in A.metadata.keys I’ve been provided with following solutiion by Cognite support, with a note to ask here. Is there a better/other solution?select * from _cdf.assets where metadata['KEY'] is not null;

2
J
Active
1 year ago
N
Committed
Niranjan Madhukar KarvekarCommitted
asked in Developer and User Community

DB Extractor - Too many concurrent requests in pod

Hi, I see this error in extractor log, I hope even if this happens , it will be retried and there will not be the data loss. Please correct if I am wrong or if there are ways to change any configuration in extractor to avoid this.  2023-03-07 05:42:04.233 UTC [WARNING ] QueryExecutor_3 - Too many concurrent requests in pod | code: 503

1
M
Practitioner
1 year ago
Sofie Svartdal Berge
Seasoned Practitioner
Sofie Svartdal BergeSeasoned Practitioner
posted in Developer and User Community

Cognite Data Fusion for you as a Domain Expert

In this post we’ll share with you our thoughts on key areas to focus on to empower you as Domain Experts - frontline workers - to efficiently utilize data and analytics in day-to-day operations. Let us know in the comments what you think!  The direction for Cognite Data FusionCognite Data Fusion (CDF) is an Industrial Data platform, and part of our mission is to ensure that we provide a “batteries included” experience to quickly realize value across our target industries Manufacturing, Energy and Power and Renewables.We want CDF to be the go-to tool for not only Data Scientist and deeply technical roles, but also the Domain Experts that know first hand what the operational challenges are and what the optimization potential is. Over the last couple of months, and in our upcoming releases, you will see a focus on enabling you as a Domain Expert to solve industrial data problems through low-code user interfaces - without assistance from “a coder”.  What sort of industrial data problems ar

0
Sofie Svartdal Berge
Seasoned Practitioner
1 year ago
X
Seasoned
Xiaofeng WangSeasoned
asked in Developer and User Community

Can create an edge with any "type" through API call but could not see it in the UI

It seems I can create an edge with any type. In the code example below, the externalId of the “type” is set to “xxx” when calling POST Add edges, which should not exist. However, the edge was added successfully. Furthermore, I could not see any edges were created in the SimulationModel table, even the “externalId” was set to “SimulatonModelSimulator”.  { "instanceType": "edge", "space": "XiaofengTest", "externalId": "externalId:edge1", "type": { "space": "XiaofengTest", "externalId": "xxx" }, "startNode": { "space": "XiaofengTest", "externalId": "externalId:simulator1" }, "endNode": { "space": "XiaofengTest", "externalId": "externalId:simmodel1" } } 

4
X
Seasoned
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie Settings