Solved: Dataform - handling duplicate table names - Page 2

matt_brood · 01-08-2024 07:40 AM

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

${ref("searchdata_url_impression")} in my SQLX models, with the error "Ambiguous Action name: searchdata_url_impression."

I've tried changing my source declarations to SQLX files and then adding the publish option to create an alias, but this didn't work and the SQL models didn't pick it up.

Any thoughts?

DataEngineer

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>")}

View solution in original post