Can't query original datasource table in the default catalog or schema for BigQuery
goldmedal opened this issue · 1 comments
goldmedal commented
Given a data source with ds.tpch.orders
table, if we set default catalog ds
and default schema tpch
, we can't query
select * from tpch.orders
It will be rewritten to
select * from orders
BigQuery should query table with full schema.table name.
com.google.cloud.bigquery.BigQueryException: Table "hubspot__companies" must be qualified with a dataset (e.g. dataset.table).
brandboat commented
we can only query data objects defined in mdl, table in datasource are not visible in accio