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