search

dbt-labs / dbt-external-tables

dbt macros to stage external sources
https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/
Apache License 2.0
305 stars 122 forks source link

Has the full refresh syntax changed? #71

Closed sgoley closed 3 years ago

sgoley commented 3 years ago

Attempting to run the following per github readme: dbt run-operation stage_external_sources --vars 'ext_full_refresh: true'

Expecting to generate a "full refresh" of my external table sources.

Instead, am receiving the following: dbt: error: unrecognized arguments: true'

Doing a few variations: dbt run-operation stage_external_sources --vars 'ext_full_refresh' Results in: Compilation Error The --vars argument must be a YAML dictionary, but was of type 'str'

database target: Google BigQuery / GCP Storage dbt version: 0.18.1 platform: Windows 10 64 bit Professional

jtcohen6 commented 3 years ago

@sgoley This should still work the way you'd expect. It's possible that, using Windows/PowerShell, your CLI quoting needs to be slightly different.

You can also try the expanded --vars syntax:

$ dbt run-operation stage_external_sources --vars '{"ext_full_refresh": true}'
sgoley commented 3 years ago

Yep - it looks like windows requires double quotes!

below is valid! dbt run-operation stage_external_sources --vars "{ext_full_refresh: true}"