Skip to main content

quote_columns

Definition​

An optional seed configuration, used to determine whether column names in the seed file should be quoted when the table is created.

  • When True, dbt will quote the column names defined in the seed file when building a table for the seed, preserving casing.
  • When False, dbt will not quote the column names defined in the seed file.
  • When not set, it will vary by adapter whether or not column names are quoted.

Usage​

Globally quote all seed columns​

dbt_project.yml
seeds:
  +quote_columns: true

Only quote seeds in the seeds/mappings directory.​

For a project with:

  • name: jaffle_shop in the dbt_project.yml file
  • seed-paths: ["seeds"] in the dbt_project.yml file
dbt_project.yml
seeds:
  jaffle_shop:
    mappings:
      +quote_columns: true

Or:

seeds/properties.yml
version: 2

seeds:
  - name: mappings
    config:
      quote_columns: true
  • Explicitly set this value if using seed files.
  • Apply the configuration globally rather than to individual projects/seeds.
  • Set quote_columns: false unless your column names include a special character or casing needs to be preserved. In that case, consider renaming your seed columns (this will simplify code downstream)

Was this page helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

0
Edit this page