I have a dataset in Bigquery which has a connection to Google Analytics so that the GA-data is loaded into a Bigquery sharded table called events_YYYYMMDD. This happens automatically in the background.
I want to join the data from this table with data from other tables in a different location.
To do so I created a replica of the table which I can use for my join.
When working in Bigquery Studio it works when I start writing a query from the other table, but when starting from the GA-table I get a ‘dataset cannot be found in location…’ error. So it is depending on the location.
When I want to create a view on the GA-table it doesn´t work as it is a secondary replica. To get this working I would have to promote the replica to a primary replica.
But now my question: would promoting the replica to primary in any way affect the existing connection between Google Analytics and Bigquery?
Thank you for reading and probably answering. 🙂