As addressed in dbt-fabric issue 189, the fabric adapter's table materialization was changed to:
- load the data into a temp table and then
- to swap the temp table with the destination table.
This prevents the destination table from being offline, possibly for longer periods, while the data loads.
The dbt-synapse adapter (v1.8.1) still drops the target table and creates a new table during table materialization. This is creating errors, because the target table disappears for minutes, causing other queries and reports to fail.
Would it be possible to merge the above update from dbt-fabric into dbt-synapse?
As addressed in dbt-fabric issue 189, the fabric adapter's table materialization was changed to:
This prevents the destination table from being offline, possibly for longer periods, while the data loads.
The dbt-synapse adapter (v1.8.1) still drops the target table and creates a new table during table materialization. This is creating errors, because the target table disappears for minutes, causing other queries and reports to fail.
Would it be possible to merge the above update from dbt-fabric into dbt-synapse?