dataform icon indicating copy to clipboard operation
dataform copied to clipboard

Override defaultLocation in .sqlx config block

Open aelbozie opened this issue 1 year ago • 5 comments

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 avatar Aug 22 '24 09:08 aelbozie

@baptiste-nottingham1 @bs1cad for visibility

aelbozie avatar Aug 22 '24 09:08 aelbozie

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.

Ekrekr avatar Aug 28 '24 10:08 Ekrekr

@Ekrekr sorry for a simple question - by a backend change, is it still in the scope of the dataform-co/dataform repository, or is it something that's outside the control of this repository?

kaiwen789 avatar Nov 22 '25 22:11 kaiwen789

@de-lan or @kolina are the right people to ask

Ekrekr avatar Nov 23 '25 06:11 Ekrekr

In the GCP Dataform we supported auto-selection of the query location and defining a location in workflow_settings.yaml is no longer necessary. Will it be enough for the use case here?

kolina avatar Nov 24 '25 11:11 kolina