dataform-co / dataform

Dataform is a framework for managing SQL based data operations in BigQuery
https://cloud.google.com/dataform/docs
Apache License 2.0
854 stars 166 forks source link

Override defaultLocation in .sqlx config block #1816

Open aelbozie opened 3 months ago

aelbozie commented 3 months ago

Is the ability to override location in a config block per .sqlx file possible, as suggested here:

config {
  type: "table",
  location: "europe-west2"
}

SELECT * FROM ...

If so, from what version is this possible?

aelbozie commented 3 months ago

@baptiste-nottingham1 @bs1cad for visibility

Ekrekr commented 3 months ago

There's no field for location in the config blocks currently - the default_location in the workflow settings file is the only option currently.

We would need to wire the option through our backend though, so this isn't a simple config change. Have added the feature request tag.