This feels like something I've overlooked, but I'm having trouble with two tables that have the same name. I have two Google Search Console accounts pushing data to BigQuery. They have different dataset names, but the tables in each are all named the same.
When I add both of these sources in Dataform (as I want to join them) they generate the same table name, searchdata_url_impression, and then I have conflict name issues when I use
Solved! Go to Solution.
You can qualify a dataset and a table with a comma in the ${ref()} call.
ex.
${ref("<dataset>", "<table_name>")}
${ref("<dataset_1>", "<searchdata_url_impression>")}