dbt-core 0.14.1

dbt 0.14.1

on Python PyPI

dbt 0.14.1 - (September 3, 2019)

Overview

This release fixes a number of bugs and includes minor improvements to the dbt workflow. These changes include UI improvements for dbt's console output, updates to the dbt Docs website, and general performance improvements.

Note: this release includes an important bugfix for the check snapshot strategy on Snowflake and BigQuery. See this guide for more information about the issue and resolution.

Links:

• Discussion (Discourse)
• Migration guide

Breaking changes

• The undocumented macros attribute was removed from the graph context variable (#1615)

Features:

• Summarize warnings at the end of dbt runs (#1597, #1654)
• Speed up catalog generation on postgres by using avoiding use of the information_schema (#1540)
• Docs site updates (#1621)
  • Fix for incorrect node selection logic in DAG view (docs#38)
  • Update page title, meta tags, and favicon (docs#39)
  • Bump the version of dbt-styleguide, changing file tree colors from orange to black :)
• Add environment variables for macro debugging flags (#1628, #1629)
• Speed up node selection by making it linear, rather than quadratic, in complexity (#1611, #1615)
• Specify the application field in Snowflake connections (#1622, #1623)
• Add support for clustering on Snowflake (#634, #1591, #1689) (docs)
• Add support for job priority on BigQuery (#1456, #1673) (docs)
• Add node.config and node.tags to the generate_schema_name and generate_alias_name macro context (#1700, #1701)

Fixes:

• Fix for reused check_cols values in snapshots (#1614, #1709)
• Fix for rendering column descriptions in sources (#1619, #1633)
• Fix for is_incremental() returning True for models that are not materialized as incremental models (#1249, #1608)
• Fix for serialization of BigQuery results which contain nested or repeated records (#1626, #1638)
• Fix for loading seed files which contain non-ascii characters (#1632, #1644)
• Fix for creation of user cookies in incorrect directories when --profile-dir or $DBT_PROFILES_DIR is provided (#1645, #1656)
• Fix for error handling when transactions are being rolled back (#1647)
• Fix for incorrect references to dbt.exceptions in jinja code (#1569, #1609)
• Fix for duplicated schema creation due to case-sensitive comparison (#1651, #1663)
• Fix for "schema stub" created automatically by dbt (#913, #1663)
• Fix for incremental merge query on old versions of postgres (<=9.6) (#1665, #1666)
• Fix for serializing results of queries which return TIMESTAMP_TZ columns on Snowflake in the RPC server (#1670)
• Fix typo in InternalException (#1640, #1672)
• Fix typo in CLI help for snapshot migration subcommand (#1664)
• Fix for error handling logic when empty queries are submitted on Snowflake (#1693, #1694)
• Fix for non-atomic column expansion logic in Snowflake incremental models and snapshots (#1687, #1690)
• Fix for unprojected count(*) expression injected by custom data tests (#1688)
• Fix for dbt run and dbt docs generate commands when running against Panoply Redshift (#1479, #1686)

Contributors:

Thanks for your contributions to dbt!

• @levimalott (#1647)
• @aminamos (#1609)
• @elexisvenator (#1540)
• @edmundyan (#1663)
• @vitorbaptista (#1664)
• @sjwhitworth (#1672, #1673)
• @mikaelene (#1688, #1709)
• @bastienboutonnet (#1591, #1689)