Google BigQueryv1.0.3

Data engineering teams migrate on-premises or legacy warehouse workloads to BigQuery by creating datasets and tables, loading data from Google Cloud Storage, and validating query results. They use list/query/patch actions to mirror schemas and metadata, and batch jobs to populate tables.

Analytics teams run scheduled BigQuery SQL queries and poll results to feed dashboards and KPI reports. They use query and get_query_results for read-only reporting, and create_table/insert_all for crafted summary tables that downstream tools consume.

Marketing ops teams consolidate campaign data from ad platforms into BigQuery datasets, then run query jobs to produce attribution and audience segments. They manage datasets, models, and routines through the connector rather than calling Google APIs directly.

Data science teams create, inspect, update, and delete BigQuery ML models and routines using list_models, get_model, patch_model, and delete_model. They track model metadata such as friendly names, descriptions, and labels to support governance and discovery.

Finance and compliance teams list datasets, jobs, and tables to audit access patterns and data lineage. They use read-only actions to retrieve job metadata, inspect table schemas, and extract aggregate query results for regulatory reporting without modifying production data.

A SaaS platform that connects to a customer's BigQuery project and provides scheduled queries, dashboarding, and alerting. The product abstracts BigQuery schema and job management so non-technical users can build reporting without writing SQL or managing credentials.

Consultancies use this skill to automate migration from legacy warehouses to BigQuery, including dataset/table creation, data loading from GCS, and metadata patching. They package repeatable migration playbooks and managed operations for enterprise clients.

Vertical SaaS vendors embed BigQuery-powered analytics directly into their applications using the connector for querying and result retrieval. End customers get real-time insights on their operational data without leaving the host application.