Data & Schema Discussions
The dataverse runs deep. Get help with connections, loading, schema development, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Save only last X Period History in Incremental Tables

Hi,I have an incremental table where I load data once a week. It’s been 6 months, and the data has already exceeded 30 GB (~500 million rows). Now, if I want to restrict the history to only the last 3 months, is there a way to do this? I don’t want t...

Row Number Error in MV Spark SQL

Hi,I’m trying to generate a Row Number using the query below, but it seems that Incorta is not returning the correct results. I checked the same query in another SQL editor, and the results were correct there. It seems either I'm missing something or...

nikhil_cr_0-1733132385014.png