Maintained with ☕️ by
IcePanel logo

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).