BigQuery standard SQL - run query with table decorators ($ signs) -


i'm using bigquery standard sql.

i'm trying use "$" decorator on table in order refer specific partition:

select user_id  `raw.events$20161109` 

and i'm getting next error:

table "raw.events$20161109" cannot include decorator dismiss

i able run query (bq validation ok), , error pops right after click on "run query" button.

when use legacy sql

i have no problem of doing it:

select uid  [raw.events$20161109] 

is there way run query using decorators standard sql ? have way, lot of other procedures based on decorators format (using legacy sql)

at time table decorators in bigquery only available when using legacy sql. there open feature request can followed see progress on bringing functionality standard sql.


Comments

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

asp.net - Problems sending emails from forum -