Skip to main content
Closed

Cognite Data Fusion: Enable stronger queries on the Asset data model.

Related products:Data Modeling
R
Seasoned

As a developer, I want to make verbose queries on Assets, so that I have to maintain less complex code on the client side of applications.

Retrieving Assets by Relationships and the Hierarchy is cumbersome and divests complexity to the client. A verbose query language for the datamodel (like SQL or SPARQL, GraphQL formats allow) would delegate complexity back to the server, and is preferable to the in-memory re-building of the model that now takes place.

We understand that most of this feature will be covered by Flexible Data Models, but we’re curious about the graph-traversal kapabilities it offers.

This feature has the highest priority for App development at Statnett.

9 replies

Anita Hæhre
Seasoned Practitioner
Forum|alt.badge.img+1
  • Anita Hæhre
  • Head of Academy and Community
  • 590 replies
  • May 3, 2022
Updated idea statusNew→Gathering Interest
Anita Hæhre
Shakya Ganguly
Practitioner

Short responses:

Querying into the data model supported with GraphQL - SQL would be an upcoming feature in 2022 through the Flexible Data Model initiative. Please note interaction with REST will be out-of-scope for this year. 

However, graph traversal capabilities - though part of product plan (2023 and beyond) would require further product discovery (especially to establish the developer or end-user workflow design).

 

RobersoSN wrote:

As a developer, I want to make verbose queries on Assets, so that I have to maintain less complex code on the client side of applications.

Retrieving Assets by Relationships and the Hierarchy is cumbersome and divests complexity to the client. A verbose query language for the datamodel (like SQL or SPARQL, GraphQL formats allow) would delegate complexity back to the server, and is preferable to the in-memory re-building of the model that now takes place.

We understand that most of this feature will be covered by Flexible Data Models, but we’re curious about the graph-traversal kapabilities it offers.

This feature has the highest priority for App development at Statnett.

 

Shakya Ganguly
Practitioner

EDIT: SQL is out of scope for 2022 as well. 

A
Seasoned
Forum|alt.badge.img

Thanks for your reply Shakya, I just want to emphasize the need for graph traversal. With contextualization being one of the main benefits and selling points of Cognite, it is very important that once we have made the effort of contextualizion our data then we can also benefit from this effort by traversing the datamodel to look for information that is related, but not necessarily in a parent-child relation. Not all things of interest can be directly coupled and will require traversal. 

Shakya Ganguly
1 person likes this
  • Shakya Ganguly
    Shakya Ganguly
T
Seasoned Practitioner
Forum|alt.badge.img

@RobersoSN / @Andreas Kimsås,

I'm guessing you have been able to play with Data Modeling for a while now. Does it satisfy the requirements you intended to convey in this Product Idea?

A
Seasoned
Forum|alt.badge.img

@Thomas Sjølshagen , I assume you refer to FDM as the tool we have tested. @Robert Solli tested FDM quite thoroughly about 1 year ago and provided feedback to Cognite at the time. Since then I know things have happened and we are quite eager to test FDM again this year. We anticipate that it will be a big step in the right direction, but will have to complete our work on the Neat initiative before we can (re)-start testing FDM    

T
Seasoned Practitioner
Forum|alt.badge.img

@Andreas Kimsås 

Yes, I was referring to (F)DM.

Thanks for the heads up on your timeline for re-engaging with testing our Data Modeling capabilities.

A
1 person likes this
  • A
    Andreas Kimsås
T
Seasoned Practitioner
Forum|alt.badge.img

Oh, and I forgot to mention:

FWIW, we have also rolled out some additional (advanced) metadata search/filtering capabilities for Assets, Events, Files and Documents.

I.e. https://api-docs.cognite.com/20230101-beta/tag/Assets/operation/listAssets

Glen Sykes
1 person likes this
  • Glen Sykes
    Glen Sykes
A
Seasoned
Forum|alt.badge.img

@Thomas Sjølshagen  - great news about the Filtering. Just showed it to my colleagues and we are eager to try it out! 

Reply


Terms & ConditionsCookie Settings

Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings