CDF Transformations

Transform data using the built-in tool on CDF.

rate limit

Code not recognized.

About this course

In this course, you’ll learn how to transform data into the CDF data model using CDF Transformations. From understanding target schema to writing SQL queries, this course will help you to master the subject of CDF transformations.

Our subject matter experts, Håkon Trømborg and Sunil Krishnamoorthy, along with Cognite Academy have developed this course for data engineers looking to up their knowledge and skills in CDF transformations. Register to this course, for quality content on CDF transformations and an interesting hands-on exercise.

At the end of the course, you’ll be able to:

  • Understand why you should use CDF Transformations.
  • Find detailed information about the target schema.
  • Write SQL queries and use SparkSQL and Cognite’s custom functions to transform data.
  • Schedule and run data transformations.

This course is for data Engineers and anyone who wants to learn more about CDF Transformations. Before taking this course, we recommend having basic knowledge of SQL, the Cognite Data Model, and how to integrate data into CDF.


 

This course is developed by Cognite Academy, with subject matter experts:

Håkon Trømborg | Tech Lead, Data Integrations

Sunil Krishnamoorthy | Product Manager, Data Integrations

Content1 hr 30 min

  • Introduction to CDF transformations
  • Welcome
  • Prerequisites
  • Data transformation and CDF
  • Why transform data?
  • Check your knowledge
  • Why use CDF transformations?
  • Check your knowledge
  • Target schema
  • Demonstration on target schema
  • Check your knowledge
  • Writing SQL queries
  • Demonstration on writing SQL queries
  • Check your knowledge
  • Run and schedule the transformation
  • Demonstration on running and scheduling the transformation
  • Check your knowledge
  • Transform more data to CDF
  • Demonstration on transforming more data to CDF
  • Check your knowledge
  • Hands-on
  • Introduction
  • Tips & tricks
  • Introduction to the data
  • Sign in to Cognite Data Fusion
  • The task - Upload the CSV files to the CDF staging area (RAW)
  • The task - Transform assets, time series and data points
  • Test
  • End of course
  • Key takeaways
  • Join discussion on Hub!
  • Share your feedback

About this course

In this course, you’ll learn how to transform data into the CDF data model using CDF Transformations. From understanding target schema to writing SQL queries, this course will help you to master the subject of CDF transformations.

Our subject matter experts, Håkon Trømborg and Sunil Krishnamoorthy, along with Cognite Academy have developed this course for data engineers looking to up their knowledge and skills in CDF transformations. Register to this course, for quality content on CDF transformations and an interesting hands-on exercise.

At the end of the course, you’ll be able to:

  • Understand why you should use CDF Transformations.
  • Find detailed information about the target schema.
  • Write SQL queries and use SparkSQL and Cognite’s custom functions to transform data.
  • Schedule and run data transformations.

This course is for data Engineers and anyone who wants to learn more about CDF Transformations. Before taking this course, we recommend having basic knowledge of SQL, the Cognite Data Model, and how to integrate data into CDF.


 

This course is developed by Cognite Academy, with subject matter experts:

Håkon Trømborg | Tech Lead, Data Integrations

Sunil Krishnamoorthy | Product Manager, Data Integrations

Content1 hr 30 min

  • Introduction to CDF transformations
  • Welcome
  • Prerequisites
  • Data transformation and CDF
  • Why transform data?
  • Check your knowledge
  • Why use CDF transformations?
  • Check your knowledge
  • Target schema
  • Demonstration on target schema
  • Check your knowledge
  • Writing SQL queries
  • Demonstration on writing SQL queries
  • Check your knowledge
  • Run and schedule the transformation
  • Demonstration on running and scheduling the transformation
  • Check your knowledge
  • Transform more data to CDF
  • Demonstration on transforming more data to CDF
  • Check your knowledge
  • Hands-on
  • Introduction
  • Tips & tricks
  • Introduction to the data
  • Sign in to Cognite Data Fusion
  • The task - Upload the CSV files to the CDF staging area (RAW)
  • The task - Transform assets, time series and data points
  • Test
  • End of course
  • Key takeaways
  • Join discussion on Hub!
  • Share your feedback