feat: added an optional application field to ExecuteSqlRequest to support application-level telemetry and audit logging

Google APIs · copybara-github · commit a3647b486682 · 2026-01-27T02:34:19.000-08:00
feat: added support for `CLUSTER` DNS scope and `RecordManager` to the `DnsNameMapping` API to support automated Private Service Connect (PSC) DNS management
feat: added support for MySQL 9.7 database version
docs: improved documentation and field behaviors for DNS mapping and connection types.

PiperOrigin-RevId: 861610287
diff --git a/google/cloud/sql/v1/cloud_sql_available_database_versions.proto b/google/cloud/sql/v1/cloud_sql_available_database_versions.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_backup_runs.proto b/google/cloud/sql/v1/cloud_sql_backup_runs.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_backups.proto b/google/cloud/sql/v1/cloud_sql_backups.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_connect.proto b/google/cloud/sql/v1/cloud_sql_connect.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_databases.proto b/google/cloud/sql/v1/cloud_sql_databases.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_events.proto b/google/cloud/sql/v1/cloud_sql_events.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_feature_eligibility.proto b/google/cloud/sql/v1/cloud_sql_feature_eligibility.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_flags.proto b/google/cloud/sql/v1/cloud_sql_flags.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_iam_policies.proto b/google/cloud/sql/v1/cloud_sql_iam_policies.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_instance_names.proto b/google/cloud/sql/v1/cloud_sql_instance_names.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_instances.proto b/google/cloud/sql/v1/cloud_sql_instances.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
@@ -2311,6 +2311,11 @@ message ExecuteSqlPayload {
   // to throw an error.
   PartialResultMode partial_result_mode = 13
       [(google.api.field_behavior) = OPTIONAL];
+
+  // Optional. Specifies the name of the application that is making the request.
+  // This field is used for telemetry. Only alphanumeric characters, dashes, and
+  // underscores are allowed. The maximum length is 32 characters.
+  string application = 16 [(google.api.field_behavior) = OPTIONAL];
 }
 
 // Execute SQL statements response.
diff --git a/google/cloud/sql/v1/cloud_sql_operations.proto b/google/cloud/sql/v1/cloud_sql_operations.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_regions.proto b/google/cloud/sql/v1/cloud_sql_regions.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_resources.proto b/google/cloud/sql/v1/cloud_sql_resources.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
@@ -2121,6 +2121,9 @@ enum SqlDatabaseVersion {
   // The database version is MySQL 8.4.
   MYSQL_8_4 = 398;
 
+  // The database version is MySQL 9.7.
+  MYSQL_9_7 = 654;
+
   // The database version is SQL Server 2017 Standard.
   SQLSERVER_2017_STANDARD = 11;
 
@@ -2288,6 +2291,7 @@ message AcquireSsrsLeaseContext {
 // DNS metadata.
 message DnsNameMapping {
   // The connection type of the DNS name.
+  // This enum is not frozen, and new values may be added in the future.
   enum ConnectionType {
     // Unknown connection type.
     CONNECTION_TYPE_UNSPECIFIED = 0;
@@ -2304,20 +2308,41 @@ message DnsNameMapping {
 
   // The scope that the DNS name applies to.
   enum DnsScope {
-    // Unknown DNS scope.
+    // DNS scope not set. This value should not be used.
     DNS_SCOPE_UNSPECIFIED = 0;
 
-    // Indicates a instance-level DNS name.
+    // Indicates an instance-level DNS name.
     INSTANCE = 1;
+
+    // Indicates a cluster-level DNS name.
+    CLUSTER = 2;
   }
 
-  // The DNS name.
-  string name = 1;
+  // The system responsible for managing the DNS record.
+  enum RecordManager {
+    // Record manager not set. This value should not be used.
+    RECORD_MANAGER_UNSPECIFIED = 0;
+
+    // The record may be managed by the customer. It is not automatically
+    // managed by Cloud SQL automation.
+    CUSTOMER = 1;
+
+    // The record is managed by Cloud SQL, which will create, update,
+    // and delete the DNS records for the zone automatically when
+    // the Cloud SQL database instance is created or updated.
+    CLOUD_SQL_AUTOMATION = 2;
+  }
+
+  // Output only. The DNS name.
+  string name = 1 [(google.api.field_behavior) = OUTPUT_ONLY];
 
   // Output only. The connection type of the DNS name.
   ConnectionType connection_type = 2
       [(google.api.field_behavior) = OUTPUT_ONLY];
 
   // Output only. The scope that the DNS name applies to.
   DnsScope dns_scope = 3 [(google.api.field_behavior) = OUTPUT_ONLY];
+
+  // Output only. The manager for this DNS record.
+  RecordManager record_manager = 4 [(google.api.field_behavior) = OUTPUT_ONLY];
 }
diff --git a/google/cloud/sql/v1/cloud_sql_ssl_certs.proto b/google/cloud/sql/v1/cloud_sql_ssl_certs.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_tiers.proto b/google/cloud/sql/v1/cloud_sql_tiers.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.
diff --git a/google/cloud/sql/v1/cloud_sql_users.proto b/google/cloud/sql/v1/cloud_sql_users.proto
@@ -1,4 +1,4 @@
-// Copyright 2025 Google LLC
+// Copyright 2026 Google LLC
 //
 // Licensed under the Apache License, Version 2.0 (the "License");
 // you may not use this file except in compliance with the License.

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-// Copyright 2025 Google LLC`
	`1`	`+// Copyright 2026 Google LLC`
`2`	`2`	`//`
`3`	`3`	`// Licensed under the Apache License, Version 2.0 (the "License");`
`4`	`4`	`// you may not use this file except in compliance with the License.`