search

dbt-labs / dbt-external-tables

dbt macros to stage external sources
https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/
Apache License 2.0
297 stars 119 forks source link

Update per: dbt-synapse v0.19.0's adapter type string breaking change #79

Closed dataders closed 3 years ago

dataders commented 3 years ago

Description & motivation

A few things here:

  1. As of v0.19.0, dbt-synapse:
    1. requires type=synapse instead of type=sqlserver, so all the sqlserver__* macros needed to be dispatched to synapse__*
    2. no longer requires quoted yes strings for encrypt and trust_cert
  2. Also the stored credentials on the Azure SQL db to read from the Synapse pool needed to be updated, which was the reason for this error

    Please verify that the shards are accessible and that the credential information affiliated with external data source dbt_external_tables_integration_tests_azuresql.dbt_external_tables_testing is correct. (46824) (SQLExecDirectW)')

Checklist