BigQuery workspace ids are generated from the table name. This means tables with the same name from different databases will get the same id. This means data from one table will be presented as data from the other table, which is completely wrong.
A similar problem exists for database connections though on a bigger scale. Tables with the same name from any database connection will share the same workspace id. This means every table with the same name from any database instance from any database system will share the same workspace.
Release Notes
Fixed a bug that would cause workspace ids to clash when wrangling items of the same name.
BigQuery workspace ids are generated from the table name. This means tables with the same name from different databases will get the same id. This means data from one table will be presented as data from the other table, which is completely wrong.
A similar problem exists for database connections though on a bigger scale. Tables with the same name from any database connection will share the same workspace id. This means every table with the same name from any database instance from any database system will share the same workspace.