Declarations when tables have same name #1470
-
hi! i'm heavily using Dataform in my work at BigQuery in Google Cloud Platform. Dataform really changed the game in my job. I have a question that I didn't find the answer in official Docs: Suppose I have two tables with the same name from different schemas but the same database. Even if I name each declaration .sqlx file differently, how can I invoke these tables through ${ref()} statement if the tables share the same name? thank you very much for all the attention. best regards. |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
|
Beta Was this translation helpful? Give feedback.
-
For further reference. |
Beta Was this translation helpful? Give feedback.
ref("database", "schema", "name")
, or if the schema name is enough to disambiguate, then justref("schema", "name")
will work.