27 Sep 19 · npack ·       Add to Favorites  

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

npack

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

Copied