COGNITE HUB

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.

  • 280 Topics
  • 826 Replies

280 Topics

S
Active
samirhajActive
asked in Developer and User Community

detNet RestAPI Cognite SDK example

Hello,I am quite new on usinf RestAPI. My company has the license to use CDF. I also inderstood that Cognite has developed dotNet RestApi SDK.I searched a bit but I could not find an example of how we can use this SDK for data retrieval especially for time-series data. How could I get a snippet of code showing an example how to use this?Thanks. 

10
Everton Colling
Practitoner
1 day ago
R
robert.rillNew
asked in Developer and User Community

Executing transformation from Cognite Function

Is it a good practice to execute transformations from a Cognite Function?Our team implemented a Cognite Function which executes transformations on tables from Cognite RAW. We chose this solution as we wanted to parametrize the SQL query of the transformation, essentially applying a different filter on raw tables every time.Also, it would easier for the end user, e.g. a plant operator, to provide a JSON input to the function then to edit the query every time in multiple locations. E.g., if the JSON is:{ "plant": "Plant.1", "equipment": "equipment.1"}the user can just change the ID for the plant and equipment. Furthermore, these values can be validated by the function before making the replacements in the query and executing the updated transformations.Let me know your thoughts!

0
R
1 day ago
S
Practitoner
Shashan UdawattePractitoner
asked in Developer and User Community

How to run Documentum Extractor with dfc.jar.

With the introduction of the Documentum Extractor version 2.0.0 onwards, it’s required to add the dfc.jar file into the lib folder. So to be able to run as a jar file user must add the dfc.jar file into the lib folder. The newly introduced Documentum Extractor is built against version 7.2.0180.0170 of DFC.Issue users might face when running the jar file with the below commandjava -jar path/to/documentum-extractor-<version>.jar path/to/config.yamlIf a user tried to run the Documentum Extractor with the dfc.jar file with the above command as mentioned in this guide, the user will receive an error message similar to the:Main  - Documentum Extractor failed:java.lang.NoClassDefFoundError: com/documentum/fc/common/DfExceptionThis is due to the fact that the Documentum Extractor jar is not identifying the main classpath.Workaround to run the Documentum Extractor with the dfc.jar file.As a workaround users could specify the classpath to include the extractor and run it as shown below. Wi

0
S
Practitoner
1 day ago
S
Committed
Sonali Vishal PatilCommitted
asked in Developer and User Community

Does DB_extractor yaml config support execution of store procedures?

Does DB_extractor yaml config support execution of store procedures? If yes how to do that?

1
E
Practitoner
1 day ago
K
Active
KAILASHKADAMActive
asked in Developer and User Community

Access to Learn Project while undergoing training

Hi All,I am going through the cognite fundamentals training, however while I try to implement hands on for Match Entities or create interactive engineering Diagrams, I get an error as insufficient rights, could you please let me know how we can implement the Match Entities and create interactive engineering Diagrams feature while going through the training, can we get access or is there anything that we can do from our end like a workaround to get hands -on for this feature?

3
K
Active
2 days ago
S
Committed
Sonali Vishal PatilCommitted
asked in Developer and User Community

How to unpivot any existing raw table?

How to unpivot any existing raw table?I want to transpose columns to rowshere I am aware about stack can be used, but i dont want to give hard coded columns names... how this can be done run time (Without passing any hardcoded value of column name in stack command?)How to get run time columns count & how this columns can be passed in stack? Table1:id p1 p2 p3 1 2.0 3.0 4.0 2 10.0 15.0 20.0 select id,   stack(3, 'p1', p1, 'p2', p2, 'p3', p3) as (property,value)from `db1`.`Table1`

3
S
Committed
2 days ago
N
Active
Niklas LauferActive
asked in Developer and User Community

Infield Checklist template add measurement input

As soon as I add a measurement in a checklist template and click on "Confirm" it is not saved. After opening the template again, my measurement input is no longer available. Am I doing something wrong here?All fields (name, unit, min/max value) are filled in. 

4
D
Practitoner
2 days ago
N
Active
N G NidhiActive
asked in Developer and User Community

Azure Pipeline

Hi TeamI am working on cognite  Functions and  we have 3 cognite instances now,Tiger-trainingDemo-devdemo-prodI have created the pipeline such a way that it is built and deployed with the single run and it is pointing to either of the instance based on the credentials provided in azure.pipeline.yaml file.functions-deploy-azure-pipelines/azure-pipelines.yaml at main · cognitedata/functions-deploy-azure-pipelines · GitHub I am using the same pipeline file which is mentioned in the above linkSo now my requirement is to build a separate build pipeline  that will build our cognite functions code, it builds and zips theCognite functions and create separate release pipeline for  and Deploy the zipped functions code to 3 different instances independently.Please help me on this as it is a show stopper for us, please set up a call anytime before 9 pm today and after 10.30 am tomorrow. Regards,Nidhi N G

4
G
Seasoned Practitioner
3 days ago
K
Active
kevinpengActive
asked in Developer and User Community

cognitedata / cognite-sdk-js

https://github.com/cognitedata/cognite-sdk-js/tree/master/samples/react/msal-browser-react, I am trying to run npm install and $ REACT_APP_CDF_PROJECT=... REACT_APP_AZURE_TENANT_ID=... REACT_APP_AZURE_APP_ID=... npm startgot the following error:node:internal/modules/cjs/loader:1024  throw err;  ^Error: Cannot find module '/Users/kevin.peng/code/cognite/cognite-sdk-js/samples/react/msal-browser-react/start'    at Function.Module._resolveFilename (node:internal/modules/cjs/loader:1021:15)    at Function.Module._load (node:internal/modules/cjs/loader:866:27)    at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:81:12)    at node:internal/main/run_main_module:22:47 {  code: 'MODULE_NOT_FOUND',  requireStack: []}

5
B
Practitoner
3 days ago
S
Committed
Sonali Vishal PatilCommitted
asked in Developer and User Community

How to get list of the columns from raw table which is in number & text format?

(RAW Table : As above which has total 179 columns #41 contains numeric data 138 contains text data)I have ingested data in raw table….now I want to get only data of  41 columns which has number data type ?how this can be done in the transformation?similar query I want to run for remained 138 columns which has “Text” data type?

2
V
Practitoner
3 days ago
S
Seasoned
ShylashriSelvamaniSeasoned
asked in Developer and User Community

can you please repurpose or recreate Bootcamp cdf project instance to Demoprod instance CDF project.

Hi,The below Bootcamp CDF project is already existing one. Can you replace or recreate this bootcamp CDF project to Demo Prod CDF project under the same cluster EUROPE1(GOOGLE). Instead of Boot-Camp Project, replace or recreate the Demo Prod CDF project.Details for demo prod:CDF Project Name: accenture-demo-prodTenant ID: e0793d39-0939-496d-b129-198edd916febAdmin group Object ID:a1ecb42a-75c3-4b13-8fc8-361a449da0d4Group Name: cognite-accenture-tiger-demoprod-environment-admin Below is the mail for your reference. Thanks,Shylashri.S

9
D
Practitoner
3 days ago
S
Seasoned
ShylashriSelvamaniSeasoned
asked in Developer and User Community

While python SDK: Cognite API error : Resource not found. This may also be due to insufficient access rights. | code: 403 | X-Request-ID: 941c405e-bd77-9105-9485-4bfe9575c998

We are trying to connect CDF Project instance : accenture-demo-dev through python SDK. We are getting the below error :Cognite API error : Resource not found. This may also be due to insufficient access rights. | code: 403 | X-Request-ID: 941c405e-bd77-9105-9485-4bfe9575c998We have provided all capabilities access to this project. cdf project link : https://accenture.fusion.cognite.com/accenture-demo-dev?cluster=api.cognitedata.com    

13
S
Seasoned
3 days ago
S
Seasoned
ShylashriSelvamaniSeasoned
asked in Developer and User Community

Enable and configure air setup in accenture-demo-dev cdf project

Hi Team, Please enable and configure Air setup in the below CDF project. (Accenture-demo-dev) under cluster EUROPE1-GOOGLE. Please let me know for any details. 

4
S
Seasoned
3 days ago
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
Practitoner
3 days ago
I
MVP
ibrahim.alsyedMVP
asked in Developer and User Community

Question: How to Leverage Drawings that are Contextualized and LIVE and Hotspotted?

scenarios we are working on, To show PI&D diagram with annotations, which help to select the asset and create a threat for that asset. Or draw a rectangle over the PI&D diagram to select multiple assets. For the above two scenarios we are referring APIs in,https://docs.cognite.com/api/v1/#tag/Engineering-diagrams Quickstart — cognite-sdk 5.3.1 documentation (readthedocs-hosted.com) We are successful in getting the PI&D as image by following the below steps,1. List Fileshttps://api.cognitedata.com/api/v1/projects/{project}/files2. Convert a diagram to image formathttps://api.cognitedata.com/api/v1/projects/{project}/context/diagram/convert/3. Get the results for converting an engineering diagram to an imagehttps://api.cognitedata.com/api/v1/projects/{project}/context/diagram/convert/{jobId} Could you please guide with APIs / JavaScript SDK methods we need to work on for the above mentioned two scenarios. 

5
A
Active
4 days ago
L
Leandro SantosNew
asked in Developer and User Community

Numeric Data Points transformation not accept NULL values

I’m trying to Create a new Numeric DataPoint transformation and when I created a new transformation the UI shows a question on how it should handle NULL values (keep existing value or deleting).I’ve setup my query with a CAST function to convert values to double. I understand that this will return NULL values when CAST is not possible, so I would expect the transformation to follow the settings defined for the transformation, but instead the transformation fails with the following message:Column 'value' was expected to have type Double, but NULL was found Can you please clarify what is the expectation regarding the Numeric DataPoint Transformation. Can it have NULL values as input or not and what is the settings for NULL values about?Thanks

2
Anita Hæhre
Practitioner
4 days ago
EViswanathan
Committed
EViswanathanCommitted
asked in Developer and User Community

Build and Restructuring of Asset Hierarchy

Cognite can automatically Build and Restructuring the asset Hierarchy to standardize the asset model across multiple manufacturing sites by using industry global standards.? Cognite can define the templates for asset attributes based on the technical object type as per industry global standards.?    (Build - from capital projects to build asset hierarchy & Restructuring - Define the level of asset hierarchy as per requirement.)  

6
Anita Hæhre
Practitioner
4 days ago
S
Seasoned
ShylashriSelvamaniSeasoned
asked in Developer and User Community

cognite data fusion plugin connect to Grafana using Azure managed grafana -plugin issue

Hi, I have done the Grafana setup from azure managed grafana from azure portal. But don’t have permission to install cognite data fusion in grafana from azure. Please let me know how to install plugin and what permission needed.   

6
Murad Sæter
Practitoner
4 days 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
Active
4 days ago
Eric Stein-Beldring
Seasoned Practitioner
Eric Stein-Beldring
published in Developer and User Community

Charts: I have a feature request. What do I do?

Have a feature request or idea for a new and improved functionality?Then we want to hear all about it! We’re constantly working to improve the Charts product experience.You can choose to either create a dedicated post (topic) in the Charts group by clicking the Create topic button OR simply post a reply below in this thread. Remember to say whether your feature request is Nice to have, Important, or Critical to you and why. Screenshots, sketches, or explanatory videos are also encouraged. 

33627
K
Seasoned Practitioner
5 days ago
P
Committed
Paramale AratiCommitted
asked in Developer and User Community

How to build Asset hierarchy in Power BI

Hi Team,I am facing one challenge in creating Asset hierarchy in Power BI. Format of data is not as per the required format for hierarchy creation i.e. i do not get parent-child relation in different columns. However i see all nodes appear in single column. I do have ParentID but unaware how this will help me to form hierarchy. Any inputs will be appreciated. Thanks!Regards,Arati

3
A
Practitoner
5 days 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
Practitoner
5 days ago
S
shubha k vNew
asked in Developer and User Community

Creating Bounding box for 2D pdf file

Hi,This is regarding creating of bounding box on PDF fileAssume we can get bounding box details from another source.And that is for whole string 18"-1S6(10S)-471454, using that need create bounding box for 471454. To find the differences we manually created the two bounding box Below are the bounding box details also attached the  screenshot.#smaller bounding box"textRegion": { "xMax": 0.12297021616798368, "xMin": 0.10935503986439225, "yMax": 0.6030244780685147, "yMin": 0.5957594432410297 } Bigger bounding box we got from XML#bigger bounding box"textRegion": { "xMax": 0.1245098493906997, "xMin": 0.0782598493906997, "yMax": 0.6047371474808384, "yMin": 0.5915995895210239 } So we can observe if we can reduce only xmin and we create  bounding box for 471454 and keep all other values same.As we have to do this for lots of places in PDF, can we get any

2
D
Practitoner
8 days 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
D
Practitoner
8 days ago
P
Peder AursandNew
asked in Developer and User Community

Calling existing Cognite Functions requires the functionsAcl:WRITE capability

I noticed that calling a pre-existing Cognite Function requires the functionsAcl:WRITE capability. Essentially this means that I cannot make a function available to users/dashboards/applications without simultaneously giving them permission to delete functions. What is the reccommended pattern for ACL when making Cognite Functions that are to be called by others?https://docs.cognite.com/api/v1/#tag/Function-calls

1
I
Practitoner
10 days ago

Generate client secret for OID

Please generate a client secret once every 180 days.




Badge winners

  • Domain Expert Basics
    Hicham Abbashas earned the badge Domain Expert Basics
  • Cognite Data Fusion Fundamentals
    YJTsaihas earned the badge Cognite Data Fusion Fundamentals
  • Cognite Data Fusion Fundamentals
    jtfrandsenhas earned the badge Cognite Data Fusion Fundamentals
  • Cognite Data Fusion Fundamentals
    Ethan Laibhas earned the badge Cognite Data Fusion Fundamentals
  • Working with Cognite InField
    modscicdoshas earned the badge Working with Cognite InField
Show all badges
Terms & ConditionsCookie Settings