Skip to main content
Seasoned ⭐️⭐️⭐️
Sonali Vishal Patil
Seasoned ⭐️⭐️⭐️
April 4, 2023
Solved

I am trying to use is_new function & getting this error

Incremental load version should be LongType or TimestampType. | code: 400 | X-Request-ID: XXXXXX
 

Gaetan Helness
Gaetan HelnessAnswer
MVP ⭐️⭐️⭐️⭐️⭐️
April 4, 2023

Can you send your code snippet containing the is_new query?

For reference, it should be a timestamp, we usually use lastUpdatedTime

https://docs.cognite.com/cdf/integration/guides/transformation/write_sql_queries/#is_new

View in thread

3 replies

Gaetan Helness
MVP ⭐️⭐️⭐️⭐️⭐️
Gaetan HelnessAnswer
MVP ⭐️⭐️⭐️⭐️⭐️
April 4, 2023

Can you send your code snippet containing the is_new query?

For reference, it should be a timestamp, we usually use lastUpdatedTime

https://docs.cognite.com/cdf/integration/guides/transformation/write_sql_queries/#is_new

    Seasoned ⭐️⭐️⭐️
    Sonali Vishal PatilAuthor
    Seasoned ⭐️⭐️⭐️
    April 4, 2023

    Yes ….you are right!!

    It worked with lastUpdatedTime 
    I was using one of the column name here LAST_UPDT_DATE instead of  lastUpdatedTime 

    Thank you for the instant reply!!

      Gaetan Helness
      MVP ⭐️⭐️⭐️⭐️⭐️
      Gaetan Helness
      MVP ⭐️⭐️⭐️⭐️⭐️
      April 4, 2023

      Great to hear. Thanks for the feedback

      Terms & ConditionsAccessibility statement