Skip to main content
Question

Using the is_new() function in transformations with joins

  • March 19, 2024
  • 1 reply
  • 44 views

Hi

I am looking into using the is_new functionality in my transformations, but was wondering whether it will work in transformations where is use joins. If so, how would I write the query?

In addition, I heard that you are working on releasing functionality to use is_new when reading from data models. When will this feature be ready?

Thank you!

Sebastian

1 reply

Hi Sebastian, 

 

Thank you for reaching out! What type of data are you looking to join, and what is your particular use case here? 

Is_new is available for reading from data models. You can see more details here: https://docs.cognite.com/de/cdf/integration/guides/transformation/write_sql_queries/#incremental-data-loading-when-using-data-modeling

 

All the best, 

Kat


Reply


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