search

llooker / google_ga360

Looker Blocks for Google Analytics 360
MIT License
39 stars 51 forks source link

Multiple GA properties in the same Explore/Dashboard #18

Open gerardwhite opened 6 years ago

gerardwhite commented 6 years ago

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 commented 5 years ago

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