Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
While going through CDF fundamental course and working with the hands-on exercise, I came across the transformation SQL which uses _cdf database and I have seen 2 different tables (assets and timeseries) used in 2 different transformations. Can someone please help a bit more on this _cdf database? What is it’s content, what all tables it contains, how is it created, to which all datasets this DB will be related to etc.
Solved
Database named "_cdf" in the training
Best answer by Ben Petree
Hey checkout this part of the documentation.
This shows all the different tables you have available in the _cdf database. If you do a select * you will find that every column corresponds to a property for that resource type. All data that has been transformed into CDF resource types (asset, timeseries, etc) is queryable this way. You will have the same access and permissions to this data as your user. If you don’t have access to assets in a dataset because you aren’t in that group, then you won’t have access to them through the query.
Hey checkout this part of the documentation.
This shows all the different tables you have available in the _cdf database. If you do a select * you will find that every column corresponds to a property for that resource type. All data that has been transformed into CDF resource types (asset, timeseries, etc) is queryable this way. You will have the same access and permissions to this data as your user. If you don’t have access to assets in a dataset because you aren’t in that group, then you won’t have access to them through the query.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.