Big Query equivalent of USE statement

Question

Is there a way to do what the USE statement does in SQL? All the examples I have seen follow the format project:dataset.table, or sometimes just dataset.table .

I'm hoping to be able to USE dataset or USE project:dataset then just specify the table name in the SELECT.

Jeremy Condit · Accepted Answer · 2015-09-10 20:53:32Z

1

There's currently no way to do this in SQL. But at the API level, you can specify the defaultDataset config option to get the same effect.

https://cloud.google.com/bigquery/docs/reference/v2/jobs#configuration.query.defaultDataset

answered Sep 10, 2015 at 20:53

Jeremy Condit

7,0661 gold badge30 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Big Query equivalent of USE statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related