Google Cloud BigQuery

Google Cloud BigQuery is a fully managed enterprise data warehouse used to manage and analyze data using machine learning, geospatial analysis and business intelligence. Automating execution from within Google Cloud BigQuery creates an additional island of automation for IT Operations to manage. This allows you to easily integrate Google Cloud BigQuery data transfer configurations with your existing enterprise workload automation solution. Simply define your data transfer and schedule queries within Google Cloud BigQuery and allow your enterprise workload automation solution to manage the scheduling of these workflows. You are instantly inheriting the advanced capabilities of your enterprise solution to deliver your digital transformation quicker and more successfully. By extending your existing enterprise automation to Google Cloud BigQuery you maintain end-to-end visibility, regain centralized command and control, alerting, SLA management, reporting and auditing.
Return to list
Google Cloud BigQuery

Benefits and Use Cases

  • Schedule, manage and monitor BigQuery Data Transfer Service jobs to automate data ingestion from various sources, and BigQuery Scheduled Queries to automate SQL-based data
  • Simplify ETL pipelines by integrating scheduling and data transfer in a unified environment.
  • Enhance data pipeline reliability through built-in retry and monitoring mechanisms.

Example Use Case: Automated Marketing Data Integration

Automate the daily ingestion of Google Ads performance data into BigQuery, schedule queries to automatically transform campaign metrics, and initiate downstream workflows for timely, accurate business intelligence and campaign performance insights.

Automic Features

  • Run and Monitor Google Cloud BigQuery Data Transfers and Scheduled Queries to completion
  • View execution log for problem diagnosis
  • Alert on failure of Google Cloud BigQuery Data Transfer and Scheduled Query jobs
  • Incorporate Google Cloud BigQuery Data Transfer and Scheduled Query processing in existing enterprise automation workflows including dependency enforcement