Forum Discussion
RobertSlattery
3 years agoResponsive Resident
How 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...
- 3 years ago
RangeStart and RangeEnd.
Depends on the partition size. When you refresh individual partitions it must not result in duplicate indexes across all partitions.
RobertSlattery
3 years agoResponsive Resident
Interesting!
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
3 years agoSuper User
RangeStart and RangeEnd.
Depends on the partition size. When you refresh individual partitions it must not result in duplicate indexes across all partitions.