pypi dbt-postgres 1.6.0
dbt-core v1.6.0
on Python PyPI

latest releases: 1.9.0b1, 1.6.18, 1.7.18...
14 months ago

dbt-core 1.6.0 - July 31, 2023

Breaking Changes

  • Dropped support for Python 3.7 (#7082)
  • Switch from dbt-metrics to dbt-semantic-interfaces for MetricNode definitions (#7500, #7404)

Features

  • Add merge as valid incremental strategy for postgres (#1880)
  • Skip catalog generation (#6980)
  • Add support for materialized views (#6911)
  • Publication artifacts and cross-project ref (#7227)
  • Optimize template rendering for common parse scenarios (#7449)
  • Add graph structure summaries to target path output (#7357)
  • Allow duplicate manifest node (models, seeds, analyses, snapshots) names across packages (#7446)
  • Detect breaking changes to enforced constraints (#7065)
  • Check for project dependency cycles (#7468)
  • nodes in packages respect custom generate_alias_name, generate_schema_name, generate_database_name macro overrides defined in packages (#7444)
  • Added warnings for model and ref deprecations (#7433)
  • Update drop_relation macro to allow for configuration of drop statement separately from object name (#7625)
  • accept publications in dbt.invoke (#7372)
  • Enable state for deferral to be separate from state for selectors (#7300)
  • add access selection syntax (#7738)
  • add project_name to manifest metadata (#7752)
  • dbt retry (#7299)
  • This change adds new selector methods to the state selector. Namely, state:unmodified and state:old. (#7564)
  • Revamp debug, add --connection flag. Prepare for future refactors/interface changes. (#7104)
  • Validate public models are not materialized as ephemeral (#7226)
  • Added support for parsing and serializaing semantic models (#7499, #7503)
  • Enable setting packages in dependencies.yml (#7372, #7736)
  • Add AdapterRegistered event log message (#7038)
  • dbt clone (#7258)
  • Further integrate semantic models into the DAG and partial parsing module (#7800)
  • Handle external model nodes in state:modified (#7563)
  • Add invocation_command to flags (#6051)
  • Add thread_id context var (#7941)
  • Add partial parsing support for semantic models (#7897)
  • Add restrict-access to dbt_project.yml (#7713)
  • allow setting enabled and depends_on_nodes from ModelNodeArgs (#7506)
  • Support '_'-delimited fqn matching for versioned models and matching on Path.stem for path selection (#7639)
  • Store time_spline table configuration in semantic manifest (#7938)
  • Add validate_sql method to BaseAdapter with implementation for SQLAdapter (#7839)
  • Support validation of metrics and semantic models. (#7969)
  • Begin populating depends_on of metric nodes (#7854)
  • Enumerate supported materialized view features for dbt-postgres (#6911)

Fixes

  • Raise better error message when dispatching a package that is not installed (#5801)
  • add negative part_number arg for split part macro (#7915)
  • Persist timing info in run results for failed nodes (#5476)
  • fix typo in unpacking statically parsed ref (#7364)
  • safe version attribute access in _check_resource_uniqueness (#7375)
  • Fix dbt command missing target-path param ([# 7411](https://github.com/dbt-labs/dbt-core/issues/ 7411))
  • Fix CTE insertion position when the model uses WITH RECURSIVE (#7350)
  • Fix v0 ref resolution (#7408)
  • Add --target-path to dbt snapshot command. (#7418)
  • dbt build selection of tests' descendants (#7289)
  • fix groupable node partial parsing, raise DbtReferenceError at runtime for safety (#7437)
  • Fix partial parsing of latest_version changes for downstream references (#7369)
  • Use "add_node" to update depends_on.nodes (#7453)
  • Fix var precedence in configs: root vars override package vars (#6705)
  • Constraint rendering fixes: wrap check expression in parentheses, foreign key 'references', support expression in all constraint types (#7417, #7480, #7416)
  • Fix inverted --print/--no-print flag (#7517)
  • Back-compat for previous return type of 'collect_freshness' macro (#7489)
  • Fix warning messages for deprecated dbt_project.yml configs (#7424)
  • Respect column 'quote' config in model contracts (#7370)
  • print model version in dbt show if specified (#7407)
  • enable dbt show for seeds (#7273)
  • push down limit filtering to adapter (#7390)
  • Allow missing profiles.yml for dbt deps and dbt init (#7511)
  • run_results.json is now written after every node completes. (#7302)
  • Do not rewrite manifest.json during 'docs serve' command (#7553)
  • Pin protobuf to greater than 4.0.0 (#7565)
  • inject sql header in query for show (#7413)
  • Pin urllib3 to ~=1.0 (#7573)
  • Throw error for duplicated versioned and unversioned models (#7487)
  • Honor --skip-profile-setup parameter when inside an existing project (#7594)
  • Fix: Relative project paths weren't working with deps (#7491)
  • Exclude password fields from Jinja rendering. (#7629)
  • Add --target-path to more CLI subcommands (#7646)
  • Stringify flag paths for Jinja context (#7495)
  • write run_results.json for run operation (#7502)
  • Add % to adapter suite test cases for persist_docs (#7698)
  • Unified to UTC (#7664)
  • Improve warnings for constraints and materialization types (#7335)
  • Incorrect paths used for "target" and "state" directories (#7465)
  • fix StopIteration error when publication for project not found (#7711)
  • Using version 0 works when resolving single model (#7372)
  • Fix empty --warn-error-options error message (#7730)
  • send sql header on contract enforcement (#7714)
  • Fixed doc link in selector.py (#7533)
  • Fix null-safe equals comparison via equals (#7778)
  • Log PublicationArtifactAvailable even when partially parsing unchanged public models (#7782)
  • fix RuntimeError when removing project dependency from dependencies.yml (#7743)
  • Fix regression in run-operation to not require the name of the package to run (#7753)
  • Fix path selector when using project-dir (#7819)
  • Allow project dependencies to use miscellaneous keys (#7497)
  • Allow dbt show --inline preview of private models (#7837)
  • Updating this error message to point to the correct URL (#7789)
  • Update SemanticModel node to properly impelment the DSI 0.1.0dev3 SemanticModel protocol spec (#7833, #7827)
  • Allow semantic model measure exprs to be defined with ints and bools in yaml (#7865)
  • Update use_discrete_percentile and use_approximate_percentile to be non optional and default to False (#7866)
  • Fix accidental propagation of log messages to root logger. (#7872)
  • Fixed an issue which blocked debug logging to stdout with --log-level debug, unless --debug was also used. (#7872)
  • Skip jinja parsing of metric filters (#7864)
  • Fix a bad implicit string conversion regression in debug --config-dir code. (#7774)
  • Remove limitation on use of sqlparse 0.4.4 (#7515)
  • Fix UninstalledPackagesFoundError error message to use correct packages specified path (#7921)
  • Fix: safe remove of external nodes from nodes.depends_on (#7924)
  • Fix query comment tests (#7845)
  • Move project_root contextvar into events.contextvars (#7937)
  • add access to ModelNodeArgs for external node building (#7890)
  • Inline query emit proper error message (#7940)
  • Fix typo in ModelNodeArgs (#7991)
  • Allow on_schema_change = fail for contracted incremental models (#7975)
  • Nicer error message if model with enforced contract is missing 'columns' specification (#7943)
  • include 'v' in ModelNodeArgs.unique_id (#8039)
  • Fix fail-fast behavior (including retry) (#7785)
  • Remove create_metric as a SemanticModel.Measure property because it currently doesn't do anything (#8064)
  • Remove VOLUME declaration within Dockerfile (#4784)
  • Fix Dockerfile.test (#7352)
  • Detect breaking contract changes to versioned models (#8030)
  • Update DryRunMethod test classes ValidateSqlMethod naming (#7839)
  • Fix typo in NonAdditiveDimension implementation (#8088)
  • Copy target_schema from config into snapshot node (#6745)
  • Enable converting deprecation warnings to errors (#8130)
  • Ensure warn_error_options get serialized in invocation_args_dict (#7694)
  • Stop detecting materialization macros based on macro name (#6231)
  • Improve handling of CTE injection with ephemeral models (#8213)
  • Fix unbound local variable error in checked_agg_time_dimension_for_measure (#8230)
  • Ensure runtime errors are raised for graph runnable tasks (compile, show, run, etc) (#8166)

Docs

Under the Hood

  • Update docs link in ContractBreakingChangeError message (#7366)
  • Reduce memory footprint of cached statement results. (#7281)
  • Remove noisy parsing events: GenericTestFileParse, MacroFileParse, Note events for static model parsing (#6671)
  • Update --help text for cache-related parameters (#7381)
  • Small UX improvements to model versions: Support defining latest_version in unsuffixed file by default. Notify on unpinned ref when a prerelease version is available. (#7443)
  • Add ability to instantiate Flags class from dict (#7607)
  • Add other relation to reffable nodes (#7550)
  • Move node patch method to schema parser patch_node_properties and refactor schema parsing (#7430)
  • Remove legacy file logger code (#NA)
  • Break up integration tests as a short term fix for Windows CI runs (#7668)
  • Include null checks in utils test base (#7670)
  • Write pub artifact to log (#7372)
  • Fix flaky test for --fail-fast (#7744)
  • Create add_from_artifact to populate state_relation field of nodes (#7551)
  • Replace space with underscore in NodeType strings (#7841)
  • Upgrade to dbt-semantic-interfaces v0.1.0dev5 (#7853)
  • Refactoring: consolidating public_nodes and nodes (#7890)
  • Resolve SemanticModel ref is the same way as other refs (#7822)
  • Move from dbt-semantic-intefaces 0.1.0dev5 to 0.1.0dev7 (#7898)
  • Don't jinja render packages from dependencies.yml (#7905)
  • Update mashumaro to 3.8.1 (#7950)
  • Refactor: entry point for cross-project ref (#7954)
  • Populate metric input measures (#7884)
  • Add option to specify partial parse file (#7911)
  • Add semantic_models to resource counts (#8077)
  • A way to control maxBytes for a single dbt.log file (#8199)

Dependencies

  • Bump mypy from 0.981 to 1.0.1 (#7027)
  • Bump ubuntu from 23.04 to 23.10 (#7675)
  • (#7681)
  • Pin click>=8.1.1,<8.1.4 (#8050)
  • Bump dbt-semantic-interfaces to ~=0.1.0rc1 (#8082)
  • Update pin for click<9 (#8232)
  • Add upper bound to sqlparse pin of <0.5 (#8236)
  • Support dbt-semantic-interfaces 0.2.0 (#8250)

Contributors

Check out latest releases or
releases around dbt-postgres 1.6.0

Don't miss a new dbt-postgres release

NewReleases is sending notifications on new releases.

Get notifications