Maintained with ☕️ by
IcePanel logo

You can now use Gemini in BigQuery to fix and explain errors

Share

Services

## Feature Feature You can now use Gemini in BigQuery to[fix and explain errors](https://cloud.google.com/bigquery/docs/write-sql-gemini#fix%5Fand%5Fexplain%5Fsql%5Ferrors)in your SQL queries. This feature is in[Preview](https://cloud.google.com/products/#product-launch-stages). ## Feature Feature You can use the[JSON\_FLATTEN function](https://cloud.google.com/bigquery/docs/reference/standard-sql/json%5Ffunctions#json%5Fflatten)to extract all non-array values that are either directly in the input `JSON`value or children of one or more consecutively nested arrays in the input`JSON` value. This function is available in[Preview](https://cloud.google.com/products/#product-launch-stages).