Skip to content

Instantly share code, notes, and snippets.

@rgpower

rgpower/manually_run_scheduled_query.md

Created October 17, 2020 13:10
Show Gist options
  • Save rgpower/d8f9041b8b013d2b26860a71047f9a4a to your computer and use it in GitHub Desktop.
Save rgpower/d8f9041b8b013d2b26860a71047f9a4a to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery: locate and manually run a scheduled query for a specific run datetime
Raw
manually_run_scheduled_query.md

BigQuery: locate and manually run a scheduled query for a specific run datetime

$ bq --project_id my_project_id ls --transfer_config --transfer_location=us | grep query-name

  projects/my_project_id/locations/us/transferConfigs/config_id   query-name   scheduled_query   SUCCEEDED  

$ bq mk --transfer_run --run-time="2020-09-30T23:30:00Z" "projects/my_project_id/locations/us/transferConfigs/config_id"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment