For Snowflake and BigQuery, it is now possible to override the database / gcloud-project-id for individual Tables, Operations and Declarations.
A project level defaultDatabase
option can now be set in dataform.json
(replacing gcloudProjectId
for BigQuery).
For individual tables, simply set the database
property in the config block for a given object, in the same way the schema can be set:
config {
type: "table",
database: "otherdb",
schema: "otherschema",
name: "table1"
}
Additionally, for referencing tables, a database parameter can also be set when calling the ref
function:
${ref({ database: "otherdb", schema: "otherschema", table: "table1"})
There's now a new a shorthand for this, allowing multiple arguments to the ref function:
${ref("otherdb", "otherschema", "table1")}