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
Continue readingCategory: GCP
Split function in BigQuery with examples
Split function in BigQuery Split is a part of String function in BigQuery which helps to split the value based
Continue readingHow to flatten an array using UNNEST function in BigQuery?
UNNEST function in BigQuery UNNEST is an array function in BigQuery which is used to flatten out an array. It
Continue readingHow to convert a String to Date in BigQuery?
CAST function in BigQuery Cast is a conversion function which is used to convert the given data type to different
Continue readingHow to submit a BigQuery job using Google Cloud Dataflow/Apache Beam?
Dataflow in GCP Dataflow in GCP offers simplified streaming and batch data processing service based on Apache Beam. It allows
Continue readingHow to read BigQuery table using PySpark?
Spark BigQuery Connector The Google Cloud team has created the set of connectors to access the data in GCP. To
Continue readingString REPLACE function in BigQuery with examples
Replace function in BigQuery The replace function is replace all occurrence of search string in the source string with the
Continue readingHow to run BigQuery SQL using Jupyter notebooks in GCP?
Jupyter notebook in GCP The Jupyter notebook is an open-source web application that allows us to create and share documents.
Continue readingHow to configure Google Cloud BigQuery connection in Apache Airflow?
Creating new Airflow connections Airflow connections are enable us to access external systems such as databases, cloud services and so
Continue readingHow to run a BigQuery SQL using Python?
BigQuery API Client libraries BigQuery API client libraries are used to run a BigQuery job programmatically. It calls the BigQuery
Continue reading