Hi everyone
I am currently new at working with dataform in bigquery
I would like to know how I can make my sqlx files write to a dataset outside the project defined by default.
This is because in my company the resulting table MUST exist in a specific project and dataset outside of the ones I am using for the staging process
Project1.Dataset1(only staging files)
Project2.Dataset2 (only final tables)