Solved

I am trying to use is_new function & getting this error


Userlevel 2
Badge

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

icon

Best answer by Gaetan Helness 4 April 2023, 07:53

View original

3 replies

Userlevel 3
Badge

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

Userlevel 2
Badge

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!!

Userlevel 3
Badge

Great to hear. Thanks for the feedback

Reply