search

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
810 stars 151 forks source link

Dataset Declaration Aliases #1765

Open Tushensu opened 3 weeks ago

Tushensu commented 3 weeks ago

In Dataform we currently declare a dataset using this :


config {
    type: "declaration",
    database: "database",
    schema: "schema",
    name : "long_table_name",
    description : "Description"
}

This however still means that in the sqlx files in order to reference this table you need to use the actual real name however it would be useful if we could add another property e.g. alias for which you can give the table a desired alias and then you can reuse that alias throughout the project to reference it (see below).

config {
    type: "declaration",
    database: "database",
    schema: "schema",
    name : "long_table_name",
    alias: "short_table_name",
    description : "Description"
}

I am not sure if there is a workaround for this in the mean time but I can't seem to find anything in the documentation.