Archive

Author: anuj

I am passionate about getting cloud solutions right the first time. I help customers transition to the public cloud with the appropriate security controls and guardrails. GCP, AWS and Azure Security Specialist. Initial Consultation

Arrays in BigQuery

Arrays in BigQuery Create an Array create table test_dataset_av.test_dataset_av as  WITH a as (  select (‘first’,’second’, ‘third’) as sequence_num ) select a.sequence_num from a Create a dataset CREATE SCHEMA my-sandbox.test_dataset_av   OPTIONS (     default_kms_key_name = ‘KMS_KEY_NAME’,     default_partition_expiration_days = PARTITION_EXPIRATION,     default_table_expiration_days = TABLE_EXPIRATION,     description = ‘test_billing_queries’,…

Read more