Forum Discussion
RobertSlattery
Responsive Resident
Responsive ResidentHow does incremental refresh work on staging tables
I need to add an index column to a table in a dataset but, incremental refresh breaks this. I created a staging table and configured it for incremental refresh to load three years of data then refre...
RangeStart and RangeEnd.
Depends on the partition size. When you refresh individual partitions it must not result in duplicate indexes across all partitions.
RobertSlatteryResponsive Resident
Responsive ResidentInteresting!
How can I get the partition name in a column? I couldn't find any other way so, I just added a hash column based on the RangFrom and RangeTo parameters.
lbendlin
Super User
Super UserRangeStart and RangeEnd.
Depends on the partition size. When you refresh individual partitions it must not result in duplicate indexes across all partitions.