Multiple GA properties in the same Explore/Dashboard

[gerardwhite]

ga_customise, line 44 ("Scenario 3")

Using this pattern to query multiple properties (schemas) doesn't seem to work. When running queries, Looker inserts the correct table names into the UNION part of the query, but also adds the date into the WHERE clause in the filter, which causes an error.

Unsure how to proceed

[bshreve]

We just ran into the same issue. The call to _TABLE_SYNTAX results in an error:

The Google BigQuery Standard SQL database encountered an error while running this query.
Failed to retrieve data - Unrecognized name: _TABLE_SUFFIX