Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
Hi @Navyasri Indupalli, here you also have the link to the DB Extractor documentation,https://docs.cognite.com/cdf/integration/guides/extraction/db Diego
Hi @Peter Quinn,Your observation is accurate; you can input data into InfluxDB through OPC-UA, and utilizing their API for data extraction is advisable. At this stage, you should build your own custom extractor (there is a Python library that you can leverage to speed up your development).It's essential to be aware that the schema in InfluxDB 1.x differs significantly from that in version 2.x or later. Knowing the specific version is crucial information for developing your extractor. Feel free to submit a "Product Idea" and your contribution will be highly valued. Thanks,Diego
I see! Yes, please go ahead and conaolidate everything into one account. Thanks a lot Kumar!
Thanks @Rahul Kumar , How about “Cognite Data Fusion Fundamentals”?
Hi @Eniko Farkas, It happened the same to me. No badge was added to my profile. I should have gotten a couple already ;) Thanks!Diego
Hello, For the Data points step “Transform RAW to Data points” I received the error “Query returned no results. The query is syntactically correct, but returned 0 rows of data.” It seems the query does not filter for dataSetId and returns no matches. I changed the query to solve the issue on my end, here are the changes: SELECT concat('FirstnameBirthyear:',dp.sensor) AS externalId, cast(time_stamp/1000 as timestamp) AS timestamp, cast(value AS double) FROM IFSDB.values AS dp JOIN _cdf.timeseries AS ts ON CONCAT('FirstnameBirthyear:', dp.sensor) = ts.externalId AND ts.dataSetId = '1234567890' Hey @Aleksander Poverud, I figured out that the trick is adding AND ts.dataSetId = '1234567890' at the endhere is the full query: SELECT concat('FirstnameBirthyear:', dp.sensor) AS externalId, cast(time_stamp / 1000 as timestamp) AS timestamp, cast(value AS double)FROM IFSDB.values AS dp, --selecting from _cdf.timeseries means we select from the timeseries we ingested to CDF earlier.
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.