Skip to content

Instantly share code, notes, and snippets.

@antoniocachuan

antoniocachuan/create_table_bq.sql

Last active June 18, 2022 03:55
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save antoniocachuan/4b8693431ce04d9b1910f5a54071efc8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save antoniocachuan/4b8693431ce04d9b1910f5a54071efc8 to your computer and use it in GitHub Desktop.
Download ZIP
Create table BigQuery
Raw
create_table_bq.sql
CREATE TABLE contact_dataset.t_contact (
id STRING,
email STRING,
phone STRING,
year STRING
)
OPTIONS (
expiration_timestamp = TIMESTAMP '2024-01-01 00:00:00 UTC',
description = 'exmple table for column level access',
labels = [('env', 'development')]);
insert into contact_dataset.t_contact (id, email, phone, year) VALUES ('857455', '[email protected]', '968758774', '1995');
insert into contact_dataset.t_contact (id, email, phone, year) VALUES ('123444', '[email protected]', '561758774', '1990');
insert into contact_dataset.t_contact (id, email, phone, year) VALUES ('087455', '[email protected]', '784758774', '2000');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment