COGNITE HUB

Check the documentation

Ask the Community

Take a look at Academy

Cognite Status Page

Contact Cognite Support

Products CDF Platform

BestDay

Website cognite.com

Discussion Groups
- - Knowledge Base
Product Updates
Product Ideas
Docs
Events
Academy

Got a question? Ask the community.

483 Topics
1,045 Replies
3,120 Members

Getting Started

All you need to know to get started with our community Cognite Hub.

Community

Ask and answer questions, and share your expertise and tips with the community.

Join Early Adopter Groups

Have your say on specific beta products in our available Early Adopter Groups.

Product Ideas

Share your product ideas and support other ideas by upvoting them.

Recently active
Help others

Sverre FjerdingstadCognite Academy Instructor

Academy Discussions

Connect with other learners!

This thread is for the learners of Cognite Academy to come together and connect with each other. If it’s your first time here, please take moment to introduce yourself! Tell us about your working role, what your learning goals are, and what you hope to get out of joining the community.

13 hours ago

Wei WuActive Member

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.

1 day ago

Niranjan Madhukar KarvekarActive Member

Flexible Data Modeling [Early Adopter]

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

1 day ago

Niranjan Madhukar KarvekarActive Member

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?

1 day ago

esgrimNew Member

ARCgis connector for Seismic CDFGathering Interest

Direct tool\data bridge to bring CDF data into ARCGIS without data conversion.This could be API plugging into ESRI ArcGIS or bridge via for example FME (future manipulation engine) export from CDF via FME to SDE SQL geodatabase.Mainly we would like to be able to display CDF generated survey products outlines and attributes in GIS to help with sales. We could use this data in ArcGIS desktop but also integrate with data on our web maps and applications.

1 day ago

Niranjan Madhukar KarvekarActive Member

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

1 day ago

Knut VidveiCommitted Member

Charts

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

2 days ago

Anita HæhreCustomer Community Director

Manufacturing Use Cases

How Cognite Data Fusion™ powers Servi’s condition-based monitoring solution

SUMMARYServi Group used Industrial DataOps software provided by Cognite, including Cognite Data Fusion, to build Servi Monitor, a software application that enables smart monitoring of machines. Servi Monitor is estimated to reduce downtime by 30-50%, maintenance costs by 10-40%, and energy use and emissions by 10-20%. CHALLENGEShift from calendar-based to condition-based maintenanceIn the manufacturing industry, machine data such as temperature changes, air pressure, and oil quality is often collected manually by technicians when they inspect the machines. These inspections are often calendar-based, an approach that can have its downsides:Machines can operate under suboptimal conditions until the next scheduled round of maintenance. Technicians spend time inspecting machines in good working order, since their work is based on a calendar, not the actual condition of machines. Machines can break down between scheduled inspections, as technicians lack a good way of monitoring their condit

812

2 days ago

eashwar11

Developer and User Community

Compute Mean-Time-to-Repair(MTTR) and Mean-Time-Between-Failures (MTBF) from Work-orders data

I have a set of work orders with the following schema along with sample data for two assets (10010234, 10010235){Equipment Work Order # Order Type Start Date Start Time End Date End Time Cost}10010234 110025063 Unplanned 7/6/2018 11:31:15 7/6/2018 23:00:00 35,600 10010234 110026082 Planned 8/25/2018 12:27:15 8/27/2018 23:44:00 37,180 10010234 110027101 Unplanned 12/8/2018 13:30:15 12/8/2018 17:00:00 26,580 10010234 110028120 Unplanned 1/27/2019 14:40:15 1/29/2019 1:45:00 38,900 10010235 110023050 Planned 3/1/2018 15:57:15 3/2/2018 3:02:00 25,000 10010235 110024617 Planned 6/14/2018 17:21:15 6/16/2018 4:30:00 30,000 10010235 110026184 Planned 9/27/2018 0:25:00 9/27/2018 6:09:00 24,600 10010235 110027751 Unplanned 1/10/2019 20:30:15 1/12/2019 7:59:00 35,600 Equipment is stored as assets and the work orders are stored a

2 days ago

Anders WillersrudNew Member

A team concept is missing in CDFGathering Interest

A team concept is missing in CDFWe are working with data in our organization aligned with the data mesh principles:- Data as a product- Domain-oriented ownership of data- Self-service data platform- Decentralized data governanceCurrently the setup for access management in CDF does not support this functionality. A team should be able to create, edit and delete datasets, and data associated with their datasets (e.g., assets, events, sequences). With the current solution an admin with group:write and dataset:write access needs to create a dataset and create new groups for service accounts/user accounts and add capabilities to read/write resource types within the dataset. We are thus not able to provide a solution which is self-serviced to teams within our organization where they freely control their data and access to it.

2 days ago

Wei WuActive Member

Developer and User Community

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

1 day ago

Niranjan Madhukar KarvekarActive Member

Flexible Data Modeling [Early Adopter]

plheideNew Member

Flexible Data Modeling [Early Adopter]

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:

2 days ago

Niranjan Madhukar KarvekarActive Member

Flexible Data Modeling [Early Adopter]

Flexible data modeling - transformation to JsonObject type

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?

1 month ago

User Leaderboard

The leaderboard is still empty

Get active and reach the top!

The weekly leaderboard is refreshed every Monday. Make an impact in the community and score high!

The leaderboard is still empty

Get active and reach the top!

The weekly leaderboard is refreshed every Monday. Make an impact in the community and score high!

Awarded Badges

Raluca Balahas earned the badge CDF Fundamentals
Savage.Mercyhas earned the badge Domain Expert
kk_innoarthas earned the badge Domain Expert
Alice Aihas earned the badge CDF Fundamentals
Pallab Ghoshhas earned the badge Data Scientist Basics

Show all badges

Subscribe to our community newsletter and get monthly updates.

To receive our newsletter Cognite Hub News, sign up from your profile card.

Receive Cognite Hub News

Need more help?

Cognite Documentation

View our product documentation.

Cognite Status Page

See the latest status updates on our services.

Contact Support

Cognite Support is available 24/7.

Terms & Conditions Cookie settings

RESOURCES Learn Documentation Support Status Page
GETTING STARTED Sign up to Cognite Hub Get started with Cognite Hub About us Contact us
FOLLOW US

Sign up

Already have an account? Login

Log in to the community

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.