20 Sep 19 · npack · #Bigquery ·   Bookmark   ×

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 |
+-------+-----------+

npack

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

Copied