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

nVector

posted on 20 Sep 19