27 Sep 19 ·  nVector in Bigquery ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Create view syntax in Google Bigquery

To create a view in Bigquery, you can use the create view ddl statement:

CREATE OR REPLACE VIEW Dataset.ViewName AS
SELECT
EmployeeNo,
FirstName,
LastName,
DOB,
JoinedDate,
DepartmentNo
FROM Dataset.TableName;

view_name is the name of the view you're creating. The view name must be unique per dataset. The view name can:

  • Contain up to 1,024 characters
  • Contain letters (upper or lower case), numbers, and underscores

nVector

posted on 27 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