Associate Data Practitioner

BigQuery supports Google Sheets as a Google Drive external-table source through a Drive URI, allowing queries to use the current spreadsheet data. A join with the actual-cost table calculates the daily difference, and Connected Sheets can execute BigQuery queries on a defined schedule so the spreadsheet receives refreshed results without CSV-based snapshot exports.

AutoML Natural Language provides managed custom sentiment-model training and deployment from labeled text, avoiding the operational and machine-learning engineering overhead of building and hosting a TensorFlow or Spark MLlib model. Using the raw review text retains sentiment-bearing language, emojis, and slang for the custom text model. AutoML Text is now deprecated, with Google directing new custom text classification and sentiment workloads to Vertex AI Gemini prompting and tuning.

Cloud Storage Object Lifecycle Management applies rules based on conditions such as object age. Its SetStorageClass action can move older objects to lower-cost classes, and its Delete action can remove objects after the required retention period, aligning cost optimization with defined tiering and retention policies.

Dataflow Job Builder is a visual Google Cloud console interface for creating and running Dataflow pipelines without code. It supports Pub/Sub input, transformation steps, and BigQuery output, including streaming from Pub/Sub to BigQuery with transformations.

BigQuery table snapshots retain a point-in-time copy independently of the base table and can be restored to a writable table. They provide retention beyond BigQuery time travel’s maximum seven-day recovery window, while time travel can recover more recent changes made after the latest weekly snapshot when the deletion is within that window.