I'm trying to get the last table processed with Google Analytics dataset data using this code:
SELECT * FROM TABLE_QUERY(77xx77xx,'table_id CONTAINS "ga_sessions"
AND last_modified_time= (Select MAX(last_modified_time)
FROM 77xx77xx.__TABLES__
where table_id contains "ga_sessions")'
)
This not working. The BigQuery interface returns me the following error:
Error: Encountered "" at line 4, column 17.
Can you help me?
Try to use ' instead of ":
look at this answer for more information about how to work with TableQuery