Skip to main content

BigQuery operational considerations

  • Known issue DEV-44030: having two or more datasets or tables with the same name but different cases is not supported.

  • To read partitioned tables that have Require WHERE clause to query data` enabled, include the parameter InsertPartitionFilter=true in the connection URL

  • By default, fractional seconds will be returned with precision of only three digits (milliseconds). To return fractional seconds with precision of six digits (microseconds), include the parameters Other=KeepRawStringDataTypes=TIME;UseStorageAPI=false in the connection URL. Setting UseStorageAPI=false will change the format of the strings returned for ARRAY types from [value1, value2, value3, ...] to ["value1", "value2", "value3", ...].

  • By default, empty arrays and nulls are returned as null. To return both empty arrays and nulls as [], include the parameter Other=EmptyArraysAsNull=false in the connection URL. Returning nulls as null and empty arrays as [] is not supported.