Skip to main content
Question

Using the is_new() function in transformations with joins

  • March 19, 2024
  • 1 reply
  • 78 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