Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
Incremental load version should be LongType or TimestampType. | code: 400 | X-Request-ID: XXXXXX
Answer
I am trying to use is_new function & getting this error
Best answer by Gaetan Helness
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
+1Can 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
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!!
+1Great to hear. Thanks for the feedback
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.