Pipe syntax supports a linear query structure designed to make your queries easier to read, write, and maintain
Share
Services
## Feature
[Pipe syntax](https://cloud.google.com/bigquery/docs/pipe-syntax-guide) supports a linear query structure designed to make your queries easier to read, write, and maintain. This feature is [generally available](https://cloud.google.com/products#product-launch-stages) (GA).
## Feature
You can use a [CREATE MODEL statement](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-contribution-analysis) to create a [contribution analysis](https://cloud.google.com/bigquery/docs/contribution-analysis) model in BigQuery ML. The [top\_k\_insights\_by\_apriori\_support](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-contribution-analysis#top%5Fk%5Finsights%5Fby%5Fapriori%5Fsupport) and [pruning\_method model options](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-contribution-analysis#pruning%5Fmethod) are now supported. You can use a contribution analysis model with the [ML.GET\_INSIGHTS function](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-get-insights) to generate insights about changes to key metrics in your multi-dimensional data. The following metric types are supported:
* [Summable metric](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-contribution-analysis#use%5Fa%5Fsummable%5Fmetric)
* [Summable ratio metric](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-contribution-analysis#use%5Fa%5Fsummable%5Fratio%5Fmetric)
* [Summable by category metric](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-contribution-analysis#use%5Fa%5Fsummable%5Fby%5Fcategory%5Fmetric)
This feature is [generally available](https://cloud.google.com//products#product-launch-stages) (GA).
What else is happening at Google Cloud Platform?
Read update
Services
Share
General availability support for the following integration Google Agentspace Enterprise
about 6 hours ago
Services
Share
GKE cluster versions have been updated. New versions available for upgrades and new clusters
about 9 hours ago
Services
Share