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...
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...
Hi all,In the Incorta dashboard, when a user is using any date column, the selection is dynamically evaluated, and all data for the corresponding month of the selected date is displayed. We aim to implement this functionality in the Business Schema t...
Hi,i have been working on physical schema and connected it to data destination ( Big Query), i had created a formula column, which i clould not able to see it in data destinationcould you please explain..?also, the tables are creating a W_created_dt...
