microsoft / dbt-synapse

dbt adapter for Azure Synapse Dedicated SQL Pools
https://dbt-msft.github.io/dbt-msft-docs/docs/dbt-synapse/overview
MIT License
70 stars 32 forks source link

Changing the distribution and index types in existing snapshots don't have any effect #132

Closed sdebruyn closed 1 year ago

sdebruyn commented 1 year ago

If you have a snapshot table with a certain distribution and/or index type and you change one of those later on through a config, nothing happens.

However, these cannot be changed after the table was created so we'd have to drop them and recreate the table. This is also something we'd probably not want to do since in the case of snapshots, we would have data loss.

dataders commented 1 year ago

should this trigger a full-refresh? what's the behavior on dbt-postgres