How to partition by month/quarter/year to get over the partition limit in Bigquery ?
DataFreak May 10 12:00 0 21
Bigquery allows you to create partitioned tables. And partitioned tables can have a maximum of 4000
-
-
Unnest Multiple level nested fields in BigQuerydan-irving May 06 12:00 0 11
Bigquery supports denormalized data with repeated structures. To access the table with nested struc
-
Working with STRUCT datatype in Google Bigquery
DataFreak May 01 12:00 0 13
Bigquery supports denormalized data at scale. Denormalize your data and take advantage of nested an -
How to perform exception handling in Google Bigquery SQL FunctionsRyan-Dallas Apr 29 12:00 0 4
When there is an error while computing a SQL Function, it it fails for any of the rows the entire S -
Solved: Biquery CLI error in query string Unrecognized name - when using single quotes in IN CLAUSEMike-Barn Apr 26 12:00 0 8
When running a query with an IN CLAUSE from the CLI, Bigquery throws the below error message:Exampl -
Solved: BigQuery error in load operation: Field delimiter must be a single charactervictor Apr 21 12:00 0 6
While trying to load a file into Bigquery with a delimiter 0x1f. Bigquery throws the below error me -
How to use DATE_TRUNC function in Bigquery ?
npack Apr 17 12:00 0 7
Date_Trunc function can be used to convert to a date to the nearest week or month or quarter or yea -
How to implement Pagination in BigQuery Resultsets
dan-irving Apr 16 12:00 0 8
Quite often we want to convert the Bigquery resultsets to multiple pages and return page by page. H -
How to get the List of all the partitions from BigQuery partitioned table
victor Apr 15 12:00 0 17
When you create table with require_partition_filter = true in Bigquery, you will have to mention t -
How to update partition expiration time for a partitioned table in Google Bigquery?
Mike-Barn Apr 08 12:00 0 18
Google Bigquery has the unique feature called "Partition expiration", If you setup this feature and -
Solved: Bigquery Error - Illegal Escape Sequence while using REGEXP
npack Apr 07 12:00 0 25
-
How to implement "LIKE ANY" in BigQuery ?
DataFreak Mar 29 12:00 0 22
LIKE ANY Clause is used to do pattern matching on multiple values. This Clause is not supported by -
How to convert string column to Timestamp in BigQuery ?
Mike-Barn Mar 28 12:00 0 17
-
Solved: BigQuery - Values referenced in UNNEST must be arrays. UNNEST contains expression of type STRUCT
dan-irving Mar 27 12:00 0 20
STRUCT is a custom object that can contain a collection of columns that have mixed datatype. Wherea -
Solved: BigQuery - Array cannot have a null element error in writing field ids
Mike-Barn Mar 21 12:00 0 26
When trying to aggregate a group into an ARRAY, if there are NULL values in the group, It throws th -
Solved: BigQuery Error - UPDATE or DELETE statement over table would affect rows in the streaming buffer, which is not supported
DataFreak Mar 17 12:00 0 12
When trying to Update or Delete rows from a table with streaming buffer attached, Bigquery throws t -
Solved: BigQuery Error : No matching signature for operator = for argument types: DATE, INT64
dan-irving Mar 15 12:00 0 24
Using comparison (=) on two fields that are of different incompatible data types. Eg. Trying to co -
Solved: Bigquery: LEFT OUTER JOIN cannot be used without a condition that is an equality of fields from both sides of the join
dan-irving Mar 13 12:00 0 6
While performing LEFT JOIN on two tables with an inequality condition, BigQuery throws an error. Fo -
How to assign a Unique Id for each Row (ROWNUM or ROWID) in Google Bigquery
Ryan-Dallas Mar 10 12:00 0 22
Often in your data tables you might want to add a unique role identifier. Similar to having your RO -
How to authenticate BigQuery account in Python ?
DataFreak Mar 08 12:00 0 6
OSError: Project was not passed and could not be determined from the environmentTo solve this error -
How to convert epoch (seconds since 1970) to date in Google BigQuery ?
npack Mar 07 12:00 0 11
The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have el -
Dataset was not found in location US error in BigQuery
DataFreak Mar 06 12:00 0 15
Bigquery has three part resource hierarchy, the Project Name, Dataset Name and Table table. If you