CODEWITHSUNDEEP
google-bigquery
Eli
Eli

Reputation: 38949

BigQuery Table Wildcard Function Aliases?

According to documentation here, I should be able to reference a table wildcard function as an alias:

...
FROM
  [project_name:]datasetId.tableId |
  (subselect_clause) |
  table wildcard function
[[AS] alias]
...

But, when I try to do this, things fail:

bq query "SELECT * FROM TABLE_QUERY(my_data, \"TIMESTAMP(table_id) BETWEEN TIMESTAMP('2014-05-21') AND TIMESTAMP('2014-06-10')\") AS blah WHERE blah.foo = 5 LIMIT 30"
Waiting on bqjob_some_id ... (0s) Current status: DONE
BigQuery error in query operation: Error processing job 'some_id': Field 'blah.foo' not found in table 'mydata.20140521'; did you mean 'foo2'?

I want to do a join on the data returned from the wildcard function treating it as a single table, so aliasing it is very important to me. Ideas?

Upvotes: 2

Views: 1263

Answers (1)

Rohit
Rohit

Reputation: 3157

The page you linked to does mention "Do not use alias with a table wildcard function."

You might want to try

SELECT * 
FROM (SELECT * FROM TABLE_QUERY(--insert query here--)) AS blah 
WHERE blah.foo = 5 LIMIT 30"

Upvotes: 3

Related Questions