The problem I’m having
We are at the early stages of migration of our existing DWH transformations into dbt, and am trying to find out if we can create Partitioned tables ? We are using Azure Synapse (Dedicated SQL Pool), though having also looked at the sqlserver adapter, that doesn’t seem to either ?
The context of why I’m trying to do this
We have a number of very tall, skinny fact tables, and while we can use Clustered Columnstore indexes, the performance is improved by using Partitioning (by a date key).
What I’ve already tried
Having looked in assorted documentation, the only place I can see dbt and partitioning is for BigQuery, and we aren’t using that.