Canner/wren-engine

Can't query original datasource table in the default catalog or schema for BigQuery

goldmedal opened this issue · 1 comments

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).

we can only query data objects defined in mdl, table in datasource are not visible in accio