1. Open the GCP Console and go to the Cloud SQL Instances page.
2. Select the instance for which you want to enable SQL Query Insights.
3. Click on the “Edit” button at the top of the page.
4. Scroll down to the “Flags” section and click on the “Add item” button.
5. In the “Name” field, enter “query-insights-enabled”.
6. In the “Value” field, enter “on”.
7. Click on the “Save” button at the bottom of the page to save the changes.

​

1. Open the Cloud Shell in the GCP Console.
2. Run the following command to enable SQL Query Insights for a Cloud SQL instance:
   Copy

   Ask AI

   gcloud sql instances patch [INSTANCE_NAME] --database-flags cloudsql.enable_query_log=on
   

   Replace [INSTANCE_NAME] with the name of your Cloud SQL instance.
3. Verify that SQL Query Insights is enabled by running the following command:
   Copy

   Ask AI

   gcloud sql instances describe [INSTANCE_NAME] | grep queryLog
   

   If SQL Query Insights is enabled, the output should include "queryLogConfig": {"enableQueryLog": true}.

1. Import the necessary libraries:

from google.cloud import bigquery
from google.cloud.bigquery import QueryJobConfig

2. Create a client object for the BigQuery API:

client = bigquery.Client()

3. Define the project ID and dataset ID where the query insights should be enabled:

project_id = 'your-project-id'
dataset_id = 'your-dataset-id'

4. Enable query insights for the dataset:

dataset_ref = client.dataset(dataset_id, project=project_id)
dataset = client.get_dataset(dataset_ref)
dataset.default_query_job_config.use_query_cache = False
dataset.default_query_job_config.use_legacy_sql = False
dataset.default_query_job_config.labels = {"queryinsights-enabled": "true"}
client.update_dataset(dataset, ["labels"])