Regexp_extract function in BigQuery Regexp_extract function returns a substring from the source string that matches the regular expression pattern. If

Cloud Composer Cloud Composer is a fully managed orchestration tool in GCP. It is used to author, schedule and monitor

Load JSON data from Cloud storage to BigQuery The JSON file can be loaded from Cloud Storage to a new

Create Table As Select (CTAS) in BigQuery The CTAS statement creates a new table by copying the schema and data

ALTER TABLE ADD COLUMN statement Alter statement allows us to modify the structure of the existing table. Using Alter Table

External table in BigQuery External Data Sources The data which is not stored in the BigQuery storage is called as

DATE_ADD function in BigQuery DATE_ADD is a part of DATE function in BigQuery. It add a specified time interval to

Export data to a file in BigQuery After loading the data into BigQuery table, we may need that data in

Views in BigQuery A view is a virtual table. It logically represents subsets of data from one or more tables.

BigQuery Substring Substring function is used to extract the portion of the string from a given string. Since Substring is