Question

A data analytics team wants to run entity sentiment analysis on millions of product reviews stored in a BigQuery table. They prefer to stay entirely within SQL and avoid writing any Python or exporting data. They plan to use the Cloud Natural Language API via BigQuery ML. When creating the remote model with CREATE MODEL ... REMOTE WITH CONNECTION, what is the essential configuration step required so that BigQuery can successfully invoke the Cloud Natural Language API?

Accepted Answer

Grant the BigQuery connection's service account the appropriate IAM role (e.g., Cloud Natural Language API user/service usage) and enable the Cloud Natural Language API in the project

Answer

Export the reviews to Cloud Storage first, because BigQuery ML remote models can only read input from GCS buckets

Answer

Deploy the Natural Language model to a Vertex AI endpoint and reference that endpoint URL in the ENDPOINT option of the remote model

Answer

Create a service account key file and embed the JSON credentials directly in the SQL CREATE MODEL statement