How to create a view in BigQuery?
Views in BigQuery A view is a virtual table. It logically represents subsets of data from one or more tables.
Continue readingCategory: GCP
Substring function in BigQuery with examples
BigQuery Substring Substring function is used to extract the portion of the string from a given string. Since Substring is
Continue readingDelete and Truncate statement in BigQuery
Delete statement in BigQuery Delete statement allows us to delete rows from a table. To perform the delete operation in
Continue readingCreate a Hive External table on Google Cloud Storage(GCS)
Google Cloud Storage (GCS) Google Cloud Storage is a secure and scalable storage option offered by Google. It allows us
Continue readingRegexp_replace function in BigQuery with examples
Regexp_replace function in BigQuery The Regexp_replace function is search the given regular expression pattern in the input string. Then it
Continue readingHow to add partition to existing table in BigQuery?
Partitioned tables in BigQuery Partitioned table is a special table that is divided into segments called partitions. Those partitioned tables
Continue readingHow to use Qualify Row_number in BigQuery?
ROW_NUMBER() function in BigQuery Row_number is a Numbering function which is a subset of Analytic function in BigQuery. In the
Continue readingHow to execute a Select query on BigQuery using Java?
BigQuery BigQuery is a fully managed and serverless datawarehouse system. It is part of Google Cloud Platform. It can process
Continue reading