Can't get Direct Query to work out of the box for BigQuery

[conconmcmc]

Hi Folks

We can't get DirectQuery to create detailed apps for BigQuery. My question is has anyone had any success using it with Bigquery?

I have created a small fake dataset and I am seeing numerous bugs including:

1. Not sure what this one is -  Query processing error: Selection sequence exceeds maximum State Expression depth
Error code: 24001

2. Generating detailed app gives blank load script (not sure why). Even when selections are made.

3. When you can generate the detailed app the Load script SQL is not compatible with BigQuery and its also garbage performance when compared to doing normal joins. For example this is not valid BigQuery syntax alias names as you can't have a dot in an alias in BQ.

`product_id` AS `products.product_id`,

4. On the summary app, you can't pause queries hitting the database when doing selections

This is quite frustrating if you have a large table and want to full scan queries on a table.

So my take aways from this:

1. Direct query with Bigquery will not work with relationships with dimension tables, you can only use for OBT, like in the examples in the videos

2. The feature is buggy and I would argue not production ready

Sorry if this comes off as a rant but its just I would expect things to work out of the box for a very simple fake dataset with 30 rows, but still things do not work.