I have setup variables on table name so i can run through all my bigquery google analytics tables: `139139762.ga_sessions_20180705` `139139762.ga_sessions_20180704` `139139762.ga_sessions_20180703`
I am using advanced mode for BigQuery and have the SQL syntax in there. If I hard code the table name into the SQL query it works fine, but when I try and use it as a variable it keeps failing with the timeout message.
What is causing this? Is there a way to increase the timeout period past a minute?
10 Community Answers
Laura Malins —
Does your variable have a valid default value? This is often the cause of a validation failure.
I have also tested it. I had it run all night with 30 different values (to test if it could get through some of the tables. It got through about 5 of the 30 and the rest timed out. So it is clearly working just not working all the time for some reason.
So the same query I ran yesterday only had 5 out of 30 complete. Today nothing changed. It is on 12/12 currently and still running. So I don't think it is the variable itself or the tables being incorrect.
Let me try increasing the timeout connection to like 4-5 minutes and see if that stops the timeout issues