Skip to main content

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.

  • 806 Topics
  • 2,544 Replies
806 Topics
Ravula Sharath Chandra Reddy
Active
Ravula Sharath Chandra ReddyActive
asked in Developer and User Community
Incremental refresh in PowerBI

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

1
C
Seasoned Practitioner
1 year ago
S
Committed
Snehal JagtapCommitted
asked in Developer and User Community
Querying FDM using sdk or APIs

Is there a way to query FDM either using sdk or rest APIs? Is there any documentation or examples available?

1
J
Seasoned Practitioner
1 year ago
W
Seasoned
Wei WuSeasoned
asked in Developer and User Community
Charts: "Absolute" calculation does not work as expected

I’m creating a new chart “speed” by calculating the absolute values from “velocity” chart. This is one of the exersie from “Cognite Charts” training course. However,  the values generated from the “Absolute value” are not correct, for example, in the screenshot below, the vlaue of “Velocity” is -1.5074… but the value of “Speed” is 97.3128 .. instead of 1.5074... 

4
W
Seasoned
1 year ago
N
Committed
Niranjan Madhukar KarvekarCommitted
asked in Developer and User Community
FDM - Get Latest value

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 

9
Anders Hafreager
Practitioner
1 year ago
K
Seasoned Practitioner
Knut VidveiSeasoned Practitioner
posted in Developer and User Community
Redirect from charts.cogniteapp.com to fusion.cognite.com/charts (starting February 7th 2023)

As communicated in this post in December, Cognite Charts is now integrated as a part of fusion.cognite.com. We are planning to retire the stand-alone url charts.cogniteapp.com to have a uniform product experience and single login. Starting February 7th 2023 you will find a message if you access the stand-alone url with instructions on how to login to fusion.cognite.com. You fill find all your charts and data intact, and Charts working as you are used to. There will be a grace period for 2 weeks after February 7th giving room for users to still access their charts from the stand-alone url if you need support to login to fusion.cognite.com.  For those of you who are linking to Charts in your third party applications, Microsoft Teams, etc., this will still function as expected. We will be working on an automatic redirect for coming releases, however still recommend you update the hyperlinks to point to your-organization-name.fusion.cognite.com already now. If you have questions on this, d

1
K
Seasoned Practitioner
1 year ago
P
Committed
plheideCommitted
asked in Developer and User Community
Enumeration support in FDM?

Is there a plan to support enumeration (or any way to restrict value of string properties) in the future?Enumerations are described here: https://graphql.org/learn/schema/, but seems like its currently not supported: 

1
Anders Hafreager
Practitioner
1 year ago
N
Committed
Niranjan Madhukar KarvekarCommitted
asked in Developer and User Community
Transformation to RAW

Hi,I have data in raw table in this format:Table1:id p1 p2 p3 1 2.0 3.0 4.0 2 10.0 15.0 20.0  I wanted to transform this details into following format through transformation id property value 1 p1 2.0 1 p2 3.0 1 p3 4.0 2 p1 10.0 2 p2 15.0 2 p3 20.0   so I have written following transformation query:SELECT id, property, valueFROM `db1`.`Table1`UNPIVOT (value FOR property IN (p1, p2,p3)) UP This query works in SQL studio, but in COGNITE transformation UI , I see below error:Mismatched input 'FOR' expecting {')', ',', '-'}(line 3, pos 15) Can you please help to understand what is missing in this?  

2
N
Committed
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
N
Committed
Niranjan Madhukar KarvekarCommitted
asked in Developer and User Community
DB extractor - storing incremental state for Timeseries query

Hi, I am observing below error(in bold) in extractor log for timeseries query: 2023-01-24 03:31:03.345 UTC [INFO    ] QueryExecutor_0 - Starting extraction of avocet-timeseries2023-01-24 03:31:03.345 UTC [DEBUG   ] QueryExecutor_0 - Query: 'SELECT ITEM_ID + PROPERTY_TYPE+'Avocet' as "externalId", START_DATETIME as timestamp, PROPERTY_VALUE as value FROM ITEM_PROPERTY1 WHERE START_DATETIME is not null and PROPERTY_VALUE is not null and LAST_UPDT_DATE is not null ORDER BY LAST_UPDT_DATE ASC'2023-01-24 03:31:03.612 UTC [INFO    ] QueryExecutor_0 - No more rows for avocet-timeseries. 2 rows extracted in 0.267 seconds2023-01-24 03:31:03.873 UTC [DEBUG   ] ThreadPoolExecutor-9_0 - https://westeurope-1.cognitedata.com:443 "POST /api/v1/projects/slb-pdf/timeseries/data HTTP/1.1" 200 222023-01-24 03:31:03.875 UTC [DEBUG   ] ThreadPoolExecutor-9_0 - HTTP/1.1 POST https://westeurope-1.cognitedata.com/api/v1/projects/slb-pdf/timeseries/data 2002023-01-24 03:31:03.877 UTC [INFO    ] QueryExecutor_0

7
N
Committed
1 year ago
I
Seasoned
ibrahim.alsyedSeasoned
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. 

8
A
Seasoned Practitioner
1 year ago
A
Active
Aliaksei PalianskiActive
asked in Developer and User Community
using FDM

I'm sorry, I'm new to cognite and don't quite understand the basics. FDM is one specific model with data? And if I need several models (I mean models filled with data) with the same schema, then I need to create several FDMs and then transform the data into them?

3
Anders Hafreager
Practitioner
1 year ago
M
Committed
Mitul Nikunjkumar GandhiCommitted
asked in Developer and User Community
Do Cognite OData APIs also offer cursor implementation like cursor capabilities on Cognite REST endpoints?

Do Cognite OData APIs also offer have cursor implementation like cursor capabilities on REST endpoints?

1
D
Practitioner
1 year ago
J
Seasoned
Julieta Alvarez MartinezSeasoned
posted in Developer and User Community
Improve error message for debugging

When working with CDF or Azure, sometimes I got some errors that were hard to figure out. Experience no doubt will help me figure them out faster, nonetheless this is an important part in enabling usability.

3
T
Seasoned Practitioner
1 year ago
J
Seasoned
Julieta Alvarez MartinezSeasoned
posted in Developer and User Community
Seamless integration with Microsoft Azure

 I faced some isuees regarding connection with Azure when working with CDF. I believe there is an area of opportunity there! 

0
J
Seasoned
1 year ago
Adam Gunther
Active
Adam GuntherActive
asked in Developer and User Community
Cognite ML: Data Modeling Hands-on Lab

I am attempting to run the python file associated with the Data Modeling hands-on lab (https://colab.research.google.com/drive/11NdrGUzFhbwsOlKqXVfYRqu9s1DzAw4b?usp=sharing). I am receiving the same error every time the ‘plot’ function is called: “TypeError: Cannot interpret '<attribute 'dtype' of 'numpy.generic' objects>' as a data type”. After some debugging, the data seems to be in a dataframe data type. I suspect there is some version discrepancy between numpy and pandas, has anyone else seen this error? Thank you, Adam

2
V
Practitioner
1 year ago
S
Committed
simenriCommitted
asked in Developer and User Community
Charts: Possible bug in "constant value"

Hi, In my endeavor to make a percentwise threshold in Charts: I.e. how many percent of the last week was a time series above a certain value, I stumbled on what I think is a bug.I need to divide the time the timeseries is above a threshold by the total duration of the time window. I therefore tried the “constant value”-function, and set it to one. The default granularity is then at 7 days. I can change the granularity to 1 day as in the screenshot below:  However, when I change the granularity below this. Eg. 1 hour, I get the following warning: Ideally I want it to 1m or something like that, so that I have sufficient granularity to measure percentage above threshold over  the course of a day.Any suggestions as to how I can fix this, or an alternative way to reach my goal?Thank you

2
Eric Stein-Beldring
Seasoned Practitioner
1 year ago
A
Seasoned
Adarsh DhimanSeasoned
asked in Developer and User Community
CDF deployment model for clients with small userbase

We may have many clients with small userbase. What is the suggested deployment model for these clients from below options:As all the CDF projects are isolated, should we as a single Cognite tenant create different projects for different clients. We should provision separate Cognite tenant for each client keeping future creation of multiple CDF projects over time. 

1
J
Seasoned Practitioner
1 year ago
A
Seasoned
Adarsh DhimanSeasoned
asked in Developer and User Community
Resource sharing between CDF projects

As a Cognite tenant we can have multiple CDF projects. Some CDF projects may have large user base in comparison to others. Do we need to worry about Cognite WebAPI request handling capacity.

1
J
Seasoned Practitioner
1 year ago
A
Seasoned
Adarsh DhimanSeasoned
asked in Developer and User Community
CDF project usage cost

Can we get usage cost per CDF project.

1
J
Seasoned Practitioner
1 year ago
A
Seasoned
Adarsh DhimanSeasoned
asked in Developer and User Community
Cognite WebAPI vs Cognite Python SDK

Is there any difference between Cognite WebAPI vs Cognite Python SDK in terms of response time and data transfer limit.

1
J
Seasoned Practitioner
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
A
Seasoned
Adarsh DhimanSeasoned
asked in Developer and User Community
Cognite functions for long running workloads

In bootcamp documentation there were some guiding principles:https://docs-bootcamp.app.cogniteapp.com/content/chapter_0/#the-ice-cream-factory-dataOne of them was for Cognite functions:Cognite Functions for running and scheduling simple and short workloads in Python (< 10 min. execution time)Can we use Cognite functions for long running and scheduling workloads typically of duration 10-12 hours.  

1
J
Seasoned Practitioner
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
CDF deployment modes

Do we have option available to deploy CDF on private cloud.

1
Armin Gharakhanloo
Practitioner
1 year ago
A
Practitioner
Arild EidePractitioner
posted in Developer and User Community
Data points from MQTT to CDF using Apache NiFi

ContextThis write up describes a basic set up of writing data points to Cognite Data Fusion using Apache NiFi. The source data is power consumption readings from the HAN interface of a power meter in a residential fuse box:The starting point here is an existing MQTT broker that receives data from an existing MQTT client device. We will use Apache NiFi to consume the MQTT messages, extract the readings and write continuously to CDF.The end goal is a live updated time series within CDF with power readings every 2.5 seconds that can be used for analysis or automation within CDF or simply visualization: NiFi flow overviewThe picture above shows the complete NiFi flow. From left to right, consuming MQTT messages, transforming and writing to Cognite Data Fusion. Approximately 120 data points per five minutes, which corresponds to the power meter outputting one reading every 2.5 second. The NiFi flow makes use of the following Processors: Processor  Purpose ConsumeMQTT

1
Pierre Pernot
Seasoned Practitioner
1 year ago

Badge winners

  • Cognite Data Fusion Fundamentals
    Joy Baruahas earned the badge Cognite Data Fusion Fundamentals
  • Cognite Domain Expert Basics
    Joy Baruahas earned the badge Cognite Domain Expert Basics
  • Cognite Data Scientist Basics
    Joy Baruahas earned the badge Cognite Data Scientist Basics
  • Cognite InField Practitioner
    Joy Baruahas earned the badge Cognite InField Practitioner
  • Cognite Data Engineer Basics - Transform and Contextualize
    Marco Aurelio de C Paivahas earned the badge Cognite Data Engineer Basics - Transform and Contextualize
Show all badges
Terms & ConditionsCookie Settings