Skip to main content

Scheduled Queries

Automate recurring BigQuery queries via Data Transfer Service.

Create a Schedule​

  1. Write query in editor
  2. Click Schedule button in toolbar
  3. Configure schedule settings
  4. Click Create Schedule

Configuration​

Frequency​

TypeExample
HourlyEvery 2 hours
Daily6:00 AM Pacific
WeeklyMonday 9:00 AM
Monthly1st of month
CustomCron expression

Destination​

  • Dataset: Where results go
  • Table name: Static or dynamic (sales_{run_date})
  • Write mode: Append, Write if empty, Overwrite

Query Parameters​

-- Available at runtime
SELECT * FROM events
WHERE DATE(created_at) = @run_date
  AND created_at < @run_time

Managing Schedules​

Access via Scheduled Queries button in toolbar.

ActionHow
View historyClick history icon
Run nowClick play icon
Pause/ResumeToggle pause icon
DeleteClick trash icon

Notifications​

Email​

Toggle Email on failure to receive alerts when queries fail.

Pub/Sub​

Enter topic path for advanced integrations:

projects/my-project/topics/query-notifications

Use with Cloud Functions for Slack/Teams alerts.

Advanced Options​

  • Service account: Run as different identity
  • Start/End time: Schedule window
  • Labels: env=prod, team=analytics
  • Partitioning: Day/Hour/Month/Year
  • Clustering: Up to 4 columns

Notes​

  • Cost limits do NOT apply to scheduled queries
  • Test manually first to verify costs
  • Use @run_date and @run_time parameters for dynamic queries