Override defaultLocation in .sqlx config block
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?
@baptiste-nottingham1 @bs1cad for visibility
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 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?
@de-lan or @kolina are the right people to ask
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?