Overview
Using dbt artifacts with trino + glue catalog and getting the error below due to line break in the {% docs strategy %}
How to reproduce
- Install Trino
- Use Glue Catalog
- run dbt artifacts
line causing the error in docs.md:
comment on column "data_warehouse"."mwh_analytics_dbt_artifacts"."snapshots".strategy is 'Snapshot "strategies" define how dbt knows if a row has changed. There are two strategies built-in to dbt — timestamp
and check.'
Here is the line causing issues:
{% docs strategy %}
Snapshot "strategies" define how dbt knows if a row has changed. There are two strategies built-in to dbt — timestamp
and check.
{% enddocs %}
Removing line break fixes it.
Expected behaviour
Comment gets persisted.
Screenshots
14:58:47 Completed with 1 error, 0 partial successes, and 0 warnings:
14:58:47
14:58:47 Failure in model snapshots (models/sources/snapshots.sql)
14:58:47 Database Error in model snapshots (models/sources/snapshots.sql)
TrinoExternalError(type=EXTERNAL, name=ICEBERG_COMMIT_ERROR, message="Cannot commit table update", query_id=20260424_145836_03243_brz92)
compiled code at target/run/dbt_artifacts/models/sources/snapshots.sql
Environment
Results of running dbt --version:
Please paste the contents of your packages.yml file here:
packages:
- package: dbt-labs/dbt_utils
version: 1.3.3
- package: dbt-labs/codegen
version: 0.14.0
- package: godatadriven/dbt_date
version: 0.17.1
- package: dbt-labs/dbt_project_evaluator
version: 1.2.3
- package: brooklyn-data/dbt_artifacts
version: 2.10.0
- package: metaplane/dbt_expectations
version: 0.10.10
- package: elementary-data/elementary
version: 0.22.1
- package: starburstdata/trino_utils
version: 0.6.0
Overview
Using dbt artifacts with trino + glue catalog and getting the error below due to line break in the {% docs strategy %}
How to reproduce
line causing the error in docs.md:
comment on column "data_warehouse"."mwh_analytics_dbt_artifacts"."snapshots".strategy is 'Snapshot "strategies" define how dbt knows if a row has changed. There are two strategies built-in to dbt — timestamp
and check.'
Here is the line causing issues:
Removing line break fixes it.
Expected behaviour
Comment gets persisted.
Screenshots
Environment
Results of running
dbt --version:# Add the results herePlease paste the contents of your
packages.ymlfile here: