BigQuery Migration Service audit logging

This document describes audit logging for BigQuery Migration Service, which methods generate audit logs, details about the audit logs each method produces, and which methods do not produce audit logs, if any. Google Cloud generates audit logs that record administrative and access activities within your Google Cloud resources. For more information, see Cloud Audit Logs overview.

Service name

BigQuery Migration Service audit logs use the service name bigquerymigration.googleapis.com.

Methods by permission type

Methods that check DATA_READ, DATA_WRITE, and ADMIN_READ permissions generate logs categorized as Data Access audit logs. Methods that check ADMIN_WRITE permissions generate logs categorized as Admin Activity audit logs.

Permission type Methods
DATA_READ google.cloud.bigquery.migration.v2.MigrationService.GetMigrationWorkflow
google.cloud.bigquery.migration.v2.MigrationService.ListMigrationSubtasks
google.cloud.bigquery.migration.v2.MigrationService.ListMigrationWorkflows
google.cloud.bigquery.migration.v2.SqlTranslationService.TranslateQuery
google.cloud.bigquery.migration.v2alpha.MigrationService.GetMigrationWorkflow
google.cloud.bigquery.migration.v2alpha.MigrationService.ListMigrationSubtasks
google.cloud.bigquery.migration.v2alpha.MigrationService.ListMigrationWorkflows
google.cloud.bigquery.migration.v2alpha.SqlTranslationService.ExtractGcsReportLogMessages
google.cloud.bigquery.migration.v2alpha.SqlTranslationService.ExtractGcsReportLogSummary
google.cloud.bigquery.migration.v2alpha.SqlTranslationService.GenerateSuggestion
google.cloud.bigquery.migration.v2alpha.SqlTranslationService.ListGcsPaths
google.cloud.bigquery.migration.v2alpha.SqlTranslationService.LoadTranslationFiles
google.cloud.bigquery.migration.v2alpha.SqlTranslationService.TranslateQuery
google.cloud.bigquery.migration.v2main.MigrationService.CreateInteractiveMigrationWorkflow
google.cloud.bigquery.migration.v2main.MigrationService.GetMigrationWorkflow
google.cloud.bigquery.migration.v2main.MigrationService.ListMigrationSubtasks
google.cloud.bigquery.migration.v2main.MigrationService.ListMigrationWorkflows
DATA_WRITE google.cloud.bigquery.migration.v2.MigrationService.CreateMigrationWorkflow
google.cloud.bigquery.migration.v2.MigrationService.DeleteMigrationWorkflow
google.cloud.bigquery.migration.v2.MigrationService.StartMigrationWorkflow
google.cloud.bigquery.migration.v2alpha.MigrationService.CreateMigrationWorkflow
google.cloud.bigquery.migration.v2alpha.MigrationService.DeleteMigrationWorkflow
google.cloud.bigquery.migration.v2alpha.MigrationService.StartMigrationWorkflow
google.cloud.bigquery.migration.v2alpha.SqlTranslationService.SaveRule
google.cloud.bigquery.migration.v2main.MigrationService.CreateMigrationWorkflow

Audit logs for each API interface

For information about how and which permissions are evaluated, for each method, see the Identity and Access Management documentation for BigQuery Migration Service.

google.cloud.bigquery.migration.v2.MigrationService

The following section contains details about audit logs associated with methods belonging to google.cloud.bigquery.migration.v2.MigrationService.

CreateMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2.MigrationService.CreateMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.create - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2.MigrationService.CreateMigrationWorkflow"

DeleteMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2.MigrationService.DeleteMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.delete - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2.MigrationService.DeleteMigrationWorkflow"

GetMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2.MigrationService.GetMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.get - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2.MigrationService.GetMigrationWorkflow"

ListMigrationSubtasks

  • Method: google.cloud.bigquery.migration.v2.MigrationService.ListMigrationSubtasks
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.subtasks.list - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2.MigrationService.ListMigrationSubtasks"

ListMigrationWorkflows

  • Method: google.cloud.bigquery.migration.v2.MigrationService.ListMigrationWorkflows
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.list - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2.MigrationService.ListMigrationWorkflows"

StartMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2.MigrationService.StartMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.update - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2.MigrationService.StartMigrationWorkflow"

google.cloud.bigquery.migration.v2.SqlTranslationService

The following section contains details about audit logs associated with methods belonging to google.cloud.bigquery.migration.v2.SqlTranslationService.

TranslateQuery

  • Method: google.cloud.bigquery.migration.v2.SqlTranslationService.TranslateQuery
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.translation.translate - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2.SqlTranslationService.TranslateQuery"

google.cloud.bigquery.migration.v2alpha.MigrationService

The following section contains details about audit logs associated with methods belonging to google.cloud.bigquery.migration.v2alpha.MigrationService.

CreateMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2alpha.MigrationService.CreateMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.create - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.MigrationService.CreateMigrationWorkflow"

DeleteMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2alpha.MigrationService.DeleteMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.delete - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.MigrationService.DeleteMigrationWorkflow"

GetMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2alpha.MigrationService.GetMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.get - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.MigrationService.GetMigrationWorkflow"

ListMigrationSubtasks

  • Method: google.cloud.bigquery.migration.v2alpha.MigrationService.ListMigrationSubtasks
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.subtasks.list - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.MigrationService.ListMigrationSubtasks"

ListMigrationWorkflows

  • Method: google.cloud.bigquery.migration.v2alpha.MigrationService.ListMigrationWorkflows
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.list - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.MigrationService.ListMigrationWorkflows"

StartMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2alpha.MigrationService.StartMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.update - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.MigrationService.StartMigrationWorkflow"

google.cloud.bigquery.migration.v2alpha.SqlTranslationService

The following section contains details about audit logs associated with methods belonging to google.cloud.bigquery.migration.v2alpha.SqlTranslationService.

ExtractGcsReportLogMessages

  • Method: google.cloud.bigquery.migration.v2alpha.SqlTranslationService.ExtractGcsReportLogMessages
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.get - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.SqlTranslationService.ExtractGcsReportLogMessages"

ExtractGcsReportLogSummary

  • Method: google.cloud.bigquery.migration.v2alpha.SqlTranslationService.ExtractGcsReportLogSummary
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.get - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.SqlTranslationService.ExtractGcsReportLogSummary"

GenerateSuggestion

  • Method: google.cloud.bigquery.migration.v2alpha.SqlTranslationService.GenerateSuggestion
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.translation.translate - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.SqlTranslationService.GenerateSuggestion"

ListGcsPaths

  • Method: google.cloud.bigquery.migration.v2alpha.SqlTranslationService.ListGcsPaths
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.get - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.SqlTranslationService.ListGcsPaths"

LoadTranslationFiles

  • Method: google.cloud.bigquery.migration.v2alpha.SqlTranslationService.LoadTranslationFiles
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.get - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.SqlTranslationService.LoadTranslationFiles"

SaveRule

  • Method: google.cloud.bigquery.migration.v2alpha.SqlTranslationService.SaveRule
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.create - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.SqlTranslationService.SaveRule"

TranslateQuery

  • Method: google.cloud.bigquery.migration.v2alpha.SqlTranslationService.TranslateQuery
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.translation.translate - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2alpha.SqlTranslationService.TranslateQuery"

google.cloud.bigquery.migration.v2main.MigrationService

The following section contains details about audit logs associated with methods belonging to google.cloud.bigquery.migration.v2main.MigrationService.

CreateInteractiveMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2main.MigrationService.CreateInteractiveMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.translation.translate - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2main.MigrationService.CreateInteractiveMigrationWorkflow"

CreateMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2main.MigrationService.CreateMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.create - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2main.MigrationService.CreateMigrationWorkflow"

GetMigrationWorkflow

  • Method: google.cloud.bigquery.migration.v2main.MigrationService.GetMigrationWorkflow
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.get - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2main.MigrationService.GetMigrationWorkflow"

ListMigrationSubtasks

  • Method: google.cloud.bigquery.migration.v2main.MigrationService.ListMigrationSubtasks
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.subtasks.list - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2main.MigrationService.ListMigrationSubtasks"

ListMigrationWorkflows

  • Method: google.cloud.bigquery.migration.v2main.MigrationService.ListMigrationWorkflows
  • Audit log type: Data access
  • Permissions:
    • bigquerymigration.workflows.list - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.bigquery.migration.v2main.MigrationService.ListMigrationWorkflows"