Columnar engine setup quickstart

Stay organized with collections Save and categorize content based on your preferences.

This page shows steps to quickly enable the columnar engine on an AlloyDB primary instance.

Enable the columnar engine

To enable the columnar engine:


  1. In the Google Cloud console, go to the Clusters page.

    Go to Clusters

  2. Click a cluster in the Resource Name column.
  3. In the Overview page, go to Instances in your cluster and then click Edit primary in the box for the primary instance.
  4. In the Edit primary instance panel, click Add flag.
  5. Select the google_columnar_engine.enabled flag from the New database flag list.
  6. Set the value to on.
  7. Click Done.
  8. Click Update instance.


To use the gcloud CLI, you can install and initialize the Google Cloud CLI, or you can use Cloud Shell.

gcloud alloydb instances update INSTANCE_ID \
    --database-flags google_columnar_engine.enabled=on \
    --region=REGION_ID \
    --cluster=CLUSTER_ID \
  • INSTANCE_ID: The ID of the instance.
  • REGION_ID: The region where the instance is present.
  • CLUSTER_ID: The ID of the cluster where the instance is present.
  • PROJECT_ID: The ID of the project where the cluster is present.

When you set this flag, the instance restarts.

For information about how to manage column store contents, see Manage column store content manually and Manage column store content using auto-columnarization.