- Learning Computer Science and Programming

How to get the DDL of an existing table/view in BigQuery?

INFORMATION_SCHEMA in BigQuery The INFORMATION_SCHEMA views allows us to retrieve the metadata information about our BigQuery objects. It has list

Split function in BigQuery Split is a part of String function in BigQuery which helps to split the value based

UNNEST function in BigQuery UNNEST is an array function in BigQuery which is used to flatten out an array. It

CAST function in BigQuery Cast is a conversion function which is used to convert the given data type to different

Dataflow in GCP Dataflow in GCP offers simplified streaming and batch data processing service based on Apache Beam. It allows

Extract function in Hive Extract function is used to get the date or time part values from a Date/Timestamp/Interval/String that

Spark BigQuery Connector The Google Cloud team has created the set of connectors to access the data in GCP. To

Replace function in BigQuery The replace function is replace all occurrence of search string in the source string with the

Jupyter notebook in GCP The Jupyter notebook is an open-source web application that allows us to create and share documents.

Creating new Airflow connections Airflow connections are enable us to access external systems such as databases, cloud services and so