How 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 readingExtract function in Hive with examples
Extract function in Hive Extract function is used to get the date or time part values from a Date/Timestamp/Interval/String that
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 readingRegexp_extract function in BigQuery with examples
Regexp_extract function in BigQuery Regexp_extract function returns a substring from the source string that matches the regular expression pattern. If
Continue reading