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.
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
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?
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
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:
Hi, I have created one FDM model having JsonObject field. In the transformation query I referred that field , example query:SELECT Series_Title as externalId, Series_Title as name, Overview as description, int(Gross) as gross, float(IMDB_Rating) as imdbRating, int(Runtime) as runTime, int(Released_Year) as releasedYear, '{"key1":"value1","key2":{"key3":12,"key4":"hello","key5":{"key6":10}}}' as dataFROM movies.moviesFDM model is:type Movie { name: String! description: String watchedIt: Boolean imdbRating: Float releasedYear: Int runTime: Int gross: Int actors: [Actor] data: JSONObject} The transformation is failing with this error:Unknown property type Json. May be I am missing something, Can you please help?
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.