dbt-external-tables 0.9.0

What's Changed

Snowflake

• Add metadata_file_last_modified for snowpiped tables by @Catisyf in #239
• snowflake delta format by @danielefrigo in #240
• Support aws_sns_topic property in Snowflake by @jtmcn in #243
• alias column for snowflake external table by @cakkinep in #257
• Snowflake: Add expression parameter to columns by @kyleburke-meq @jpear3 in #275

BigQuery

• Handle BigQuery non-string option 'max_staleness' by @marcbllv in #237
• quote project name by @thomas-vl in #242
• update external table columns by @thomas-vl in #252

under the hood

• Fix protobuf v5 issue in CI by @thomas-vl in #258
• move to GitHub Actions by @dataders in #265
• Rebase test by @dataders in #273
• run workflow in context of base repo by @dataders in #278
• actual test case for #257 by @dataders in #290

New Contributors

• @marcbllv made their first contribution in #237
• @Catisyf made their first contribution in #239
• @danielefrigo made their first contribution in #240
• @jtmcn made their first contribution in #243
• @cakkinep made their first contribution in #257
• @kyleburke-meq made their first contribution in #275
• @jpear3 made their first contribution in #275

Full Changelog: 0.8.7...0.9.0

dbt-external-tables 0.9.0-b1

What's Changed

Snowflake

• Add metadata_file_last_modified for snowpiped tables by @Catisyf in #239
• snowflake delta format by @danielefrigo in #240
• Support aws_sns_topic property in Snowflake by @jtmcn in #243
• alias column for snowflake external table by @cakkinep in #257

BigQuery

• Handle BigQuery non-string option 'max_staleness' by @marcbllv in #237
• quote project name by @thomas-vl in #242
• update external table columns by @thomas-vl in #252

under the hood

• Fix protobuf v5 issue in CI by @thomas-vl in #258
• move to GitHub Actions by @dataders in #265
• Rebase test by @dataders in #273
• run workflow in context of base repo by @dataders in #278
• actual test case for #257 by @dataders in #290

New Contributors

• @marcbllv made their first contribution in #237
• @Catisyf made their first contribution in #239
• @danielefrigo made their first contribution in #240
• @jtmcn made their first contribution in #243
• @cakkinep made their first contribution in #257

Full Changelog: 0.8.7...0.9.0b1

dbt-external-tables 0.8.7

What's Changed

• Support BQ CETAS's with connection clause by @cfyans in #233
• BigQuery check if schema already exists before trying to create it by @thomas-vl in #220

New Contributors

• @thomas-vl made their first contribution in #220
• @cfyans made their first contribution in #233

Full Changelog: 0.8.6...0.8.7

dbt-external-tables v0.8.6

What's Changed

• GitHub Action to add/remove triage labels as-needed by @dbeatty10 in #223
• GitHub Action to close issues as stale as-needed by @dbeatty10 in #224
• Disable CI for Databricks by @dbeatty10 in #229
• Instructions for the release process by @dbeatty10 in #227
• Adding a schema check before privilege dependent ddl in Snowflake by @ianrobinson-sage in #215

New Contributors

• @ianrobinson-sage made their first contribution in #215

Full Changelog: 0.8.5...0.8.6

dbt-external-tables v0.8.5

What's Changed

• Add support to infer schemas on Snowflake by @b-per in #211

New Contributors

• @b-per made their first contribution in #211

Full Changelog: 0.8.4...0.8.5

dbt-external-tables v0.8.4

What's Changed

• Add namespace to redshift_is_ext_tbl call in get_external_build_plan by @MikeSchriefer in #168
• Add source node database config to create schema ddl by @epapineau in #196

New Contributors

• @MikeSchriefer made their first contribution in #168
• @epapineau made their first contribution in #196

Full Changelog: 0.8.3...0.8.4

dbt-external-tables v0.8.3

What's Changed

• (Spark) Correcting handling partitions in Spark and adding sample source by @pgoslatara in #161
• Add aws context by @dave-connors-3 in #179
• Use CircleCI contexts for environment variables by @dbeatty10 in #180
• Create schema for external tables when it is not there. by @guillesd in #167

New Contributors

• @pgoslatara made their first contribution in #161
• @dave-connors-3 made their first contribution in #179
• @dbeatty10 made their first contribution in #180
• @guillesd made their first contribution in #167

Full Changelog: 0.8.2...0.8.3

dbt-external-tables v0.8.2

Fixes

• (BigQuery) Fix column_quoted set outside the columns loop (#166)

Full Changelog: 0.8.1...0.8.2

dbt-external-tables v0.8.1

Features

• (Snowflake) Add support for Delta lake external tables (#138)
• (snowflake) Add configurable error integration for snowpipe (#154)

Fixes

• (Snowflake) Fix column quoting (#135)
• (BigQuery) Fix column quoting (#148)
• (Spark) Fix recover_partitions macro (#163)

Contributors

• [@aPeterHeise] (#135, #138)
• [@scarrucciu] (#148)
• [@NiallRees] (#154)
• [@lassebenni] (#163)

dbt-external-tables v0.8.0

This release supports any version (minor and patch) of v1, which means far less need for compatibility releases in the future.

Features

• (Snowflake) Support for regex pattern in snowpipes (#111, #122)
• (Apache Spark) Real support for partitioned external tables. Note that external sources with partitions defined were implicitly skipped. Going forward, sources with partitions defined (excluding those with using: delta) will run alter table ... recover partitions. (#116)

Under the hood

• Use standard logging, thereby removing dependency on dbt_utils (#119)
• Remove synapse__-prefixed "passthrough" macros, now that dbt-synapse can use sqlserver__-prefixed macros instead (#110)

Contributors

• @JCZuurmond (#116)
• @stumelius (#111)
• @swanderz (#110)