Transcribe audio files with the ML.TRANSCRIBE function

This document describes how to use the ML.TRANSCRIBE function with a remote model to transcribe audio files from an object table.

Supported locations

You must create the remote model used in this procedure in one of the following locations:

  • asia-northeast1
  • asia-south1
  • asia-southeast1
  • australia-southeast1
  • eu
  • europe-west1
  • europe-west2
  • europe-west3
  • europe-west4
  • northamerica-northeast1
  • us
  • us-central1
  • us-east1
  • us-east4
  • us-west1

You must run the ML.TRANSCRIBE function in the same region as the remote model.

Required roles

To create a remote model and transcribe audio files, you need the following Identity and Access Management (IAM) roles at the project level:

  • Create a speech recognizer: Cloud Speech Editor (roles/speech.editor)
  • Create and use BigQuery datasets, tables, and models: BigQuery Data Editor (roles/bigquery.dataEditor)

  • Create, delegate, and use BigQuery connections: BigQuery Connections Admin (roles/bigquery.connectionsAdmin)

    If you don't have a default connection configured, you can create and set one as part of running the CREATE MODEL statement. To do so, you must have BigQuery Admin (roles/bigquery.admin) on your project. For more information, see Configure the default connection.