20 Sep 19 · npack ·       Add to Favorites  

SELECT * from a table in Bigquery - Syntax

SELECT *, often referred to as select star, produces one output column for each column that is visible after executing the full query

SELECT * FROM `MyProjectId`.DatasetName.MyTable;

You can also select query to create a derived table,

SELECT * FROM (SELECT "Orange" AS fruit, "carrot" AS vegetable);
| fruit | vegetable |
| Orange| carrot |


posted on 20 Sep 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds