help you fix your problem The project_Id you pass as part of the request is considered the billing projectId meaning the project from which the cost of the query will be charged. To use 2 different tables from 2 different projects you need to add the project name to your query using this format projectId.datasetId.tableId
query_job = """SELECT * from projectId.datasetId.test limit 10"""
Hope this helps I am trying to query multiple product-scoped custom dimensions in Google BigQuery. The result is something like this: , I rewrote to an example using public data set:
SELECT fullVisitorId, visitId, hits.hitNumber, hits.time,
max(IF(hits.customDimensions.index = 1, hits.customDimensions.value, NULL)) within RECORD cd21,
max(IF(hits.customDimensions.index = 2, hits.customDimensions.value, NULL)) within RECORD cd22,
hits.customDimensions.index IN ( 1,2 )
and fullVisitorId = '712553853382222331'
I hope this helps you . You can add only one BigQuery View per Property in Google Analytics. You will not be able to send multiple Views within same Property. I suggest that you send a consolidated view with all the timezones and then inside of BigQuery, add logic to split that data into multiple datasets based on the filters you would add in GA
Using different revisions of multiple android library projects in multiple client projects (in Eclipse)