BigQuery

BigQuery (big-query)

Ingest data from Google BigQuery.

Data Warehouse json

Minimal example

input:
  big-query:
    connection:
      project: ~

JSON

{
  "input": {
    "big-query": {
      "connection": {
        "project": null
      }
    }
  }
}

Contents

• Minimal example

• Fields

• Trigger

• Reliability

• Connection

• Operation

• Read Session

• Query Job

• Parameters

• Schema

• Authentication

• Schema

Fields

Field	Type	Required	Description
connection Connection	Connection	✅	Connection details (project, dataset, table).
trigger Trigger	Trigger		Run on the provided cadence; if omitted, this input runs exactly once.
retry Reliability	Retry		Retry configuration for transient failures.
mode Operation	Mode		Operation mode (read-session or query-job). Allowed values: read-session, query-job
read-session Read Session	Read Session		Configuration for Storage Read API sessions.
query-job Query Job	Query Job		Configuration for SQL query jobs.
parameters Parameters	Parameters[]		Query parameters or filter bindings.
schema Schema	Schema		Schema handling and coercion settings.
credentials Authentication	Credentials		Authentication credentials.

Trigger

Show fields

Field	Type	Required	Description
trigger	Trigger		Run on the provided cadence; if omitted, this input runs exactly once.

Reliability

Show fields

Field	Type	Required	Description
retry	Retry		Retry configuration for transient failures.

Connection

Show fields

Field	Type	Required	Description
connection	Connection	✅	Connection details (project, dataset, table).

Operation

Show fields

Field	Type	Required	Description
mode	Mode		Operation mode (read-session or query-job). Allowed values: read-session, query-job

Read Session

Show fields

Field	Type	Required	Description
read-session	Read Session		Configuration for Storage Read API sessions.

Query Job

Show fields

Field	Type	Required	Description
query-job	Query Job		Configuration for SQL query jobs.

Parameters

Show fields

Field	Type	Required	Description
parameters	Parameters[]		Query parameters or filter bindings.

Schema

Show fields

Field	Type	Required	Description
schema	Schema		Schema handling and coercion settings.

Authentication

Show fields

Field	Type	Required	Description
credentials	Credentials		Authentication credentials.

Schema

• Trigger - Cron - Window - Start Options
• Trigger - Interval - Window - Start Options
• Trigger Options
• Credentials Options
• Trigger - Message Fields
• Trigger - Cron - Window - Start - Start Time Fields
• Trigger - Cron - Window Fields
• Trigger - Cron Fields
• Trigger - Interval - Window - Start - Start Time Fields
• Trigger - Interval - Window Fields
• Trigger - Interval Fields
• Retry Fields
• Connection - Impersonation Fields
• Connection Fields
• Read Session Fields
• Query Job Fields
• Parameters Fields
• Schema - Overrides Fields
• Schema Fields
• Credentials - Service Account Fields
• Credentials - Service Account File Fields
• Credentials - Workload Identity Fields
• Trigger - Message - Filter Kind Options
• Trigger - Message - Filter Source Options
• Trigger - Message - Filter Type Options
• Mode Options
• Query Job - Priority Options

Trigger - Cron - Window - Start Options

Option	Name	Type	Description
start-time	Start Time	object
tracked	Tracked	string	Examples: /path/to/file, c:\users\joe\data\file.txt

Trigger - Interval - Window - Start Options

Option	Name	Type	Description
start-time	Start Time	object
tracked	Tracked	string	Examples: /path/to/file, c:\users\joe\data\file.txt

Trigger Options

Option	Name	Type	Description
message	Message	object
cron	Cron	object
interval	Interval	object

Credentials Options

Option	Name	Type	Description
service-account	Service Account	object
service-account-file	Service Account File	object
workload-identity	Workload Identity	object
application-default	Application Default	map

Trigger - Message Fields

Field	Type	Required	Description
limit	number (integer)		The number of times to run the input. Examples: 42, 1.2e-10
filter-kind	Filter Kind		Specifies whether the message originated from the “system” or by the “user”. Allowed values: system, user, runtime-artifact-fetch, runtime-artifact-fetch-error, runtime-artifact-clear, runtime-artifact-clear-ack, runtime-artifact-fetch-reply, runtime-artifact-update, …
filter-source	Filter Source[]		Specifies what process generated the message. Was it a “server”, “worker” or “job”? Allowed values: job, worker, server
filter-worker	string		Specifies what worker to select.
filter-job	string		Specifies the name of the job that the message came from.
filter-type	Filter Type[]		Specifies that particular types of message ought to match. Allowed values: worker-licensed, worker-unlicensed, variable, variable-deleted, begin-shutting-down-job, begin-shutting-down-server, begin-shutting-down-worker, broadcast-job-thread-state, …
filter-tag	string		Specifies that messages matched ought to carry a tag with a particular value. This only matches against user-generated messages.

Trigger - Cron - Window - Start - Start Time Fields

Field	Type	Required	Description
start-time	time-format (string)	✅	Allows the windowing to start at a specified time. Hint: %Y-%m-%d %H:%M:%S%.3f %z
highwatermark-file	path (string)	✅	Specify file where timestamp would be stored in order to resume, for when Job has been restarted. Examples: /path/to/file, c:\users\joe\data\file.txt

Trigger - Cron - Window Fields

Field	Type	Required	Description
size	duration (string)	✅	Window size.
offset	duration (string)		Window offset.
start	Start		Specify file where timestamp would be stored in order to resume, for when Job has been restarted.

Trigger - Cron Fields

Field	Type	Required	Description
cron	cron-expression (string)	✅	The Cron pattern.
immediate	boolean (bool)		Run as soon as invoked, instead of waiting for the specified cron interval.
random-offset	duration (string)		Sets a random offset to the schedule, then sticks to it.
window	Window		Optional window definition when the schedule should only read a bounded range.

Trigger - Interval - Window - Start - Start Time Fields

Field	Type	Required	Description
start-time	time-format (string)	✅	Allows the windowing to start at a specified time. Hint: %Y-%m-%d %H:%M:%S%.3f %z
highwatermark-file	path (string)	✅	Specify file where timestamp would be stored in order to resume, for when Job has been restarted. Examples: /path/to/file, c:\users\joe\data\file.txt

Trigger - Interval - Window Fields

Field	Type	Required	Description
size	duration (string)	✅	Window size.
offset	duration (string)		Window offset.
start	Start		Specify file where timestamp would be stored in order to resume, for when Job has been restarted.

Trigger - Interval Fields

Field	Type	Required	Description
duration	duration (string)	✅	Duration to wait between events.
random-offset	duration (string)		Sets a random offset to the schedule, then sticks to it.
window	Window		Optional window definition when the interval should only cover a bounded range.

Retry Fields

Field	Type	Required	Description
timeout	time-interval (string)	✅	timeout (e.g. 500ms, 2s etc. - default is 30). Examples: 500ms, 2h
retries	number (integer)		number of retries. Examples: 42, 1.2e-10

Connection - Impersonation Fields

Field	Type	Required	Description
service-account	string	✅
delegates	string[]

Connection Fields

Field	Type	Required	Description
project	string	✅
dataset	string
table	string
billing-project	string
location	string
impersonation	Impersonation		Impersonate a service account (requires IAM Credentials API).

Read Session Fields

Field	Type	Required	Description
max-stream-count	number (integer)		Examples: 42, 1.2e-10
selected-fields	string[]
row-restriction	string
snapshot-time	string

Query Job Fields

Field	Type	Required	Description
query	string	✅
use-legacy-sql	boolean (bool)
dry-run	boolean (bool)
destination-table	string
priority	Priority		Allowed values: interactive, batch

Parameters Fields

Field	Type	Required	Description
name	string	✅
value	string
r-type	string

Schema - Overrides Fields

Field	Type	Required	Description
field-path	string	✅
target-type	string

Schema Fields

Field	Type	Required	Description
auto-fetch	boolean (bool)
overrides	Overrides[]

Credentials - Service Account Fields

Field	Type	Required	Description
secret-id	string	✅

Credentials - Service Account File Fields

Field	Type	Required	Description
path	string	✅

Credentials - Workload Identity Fields

Field	Type	Required	Description
audience	string	✅
service-account-email	string

Trigger - Message - Filter Kind Options

Value	Description
system	System
user	User
runtime-artifact-fetch	Runtime Artifact Fetch
runtime-artifact-fetch-error	Runtime Artifact Fetch Error
runtime-artifact-clear	Runtime Artifact Clear
runtime-artifact-clear-ack	Runtime Artifact Clear Ack
runtime-artifact-fetch-reply	Runtime Artifact Fetch Reply
runtime-artifact-update	Runtime Artifact Update
runtime-artifact-update-ack	Runtime Artifact Update Ack

Trigger - Message - Filter Source Options

Value	Description
job	Job
worker	Worker
server	Server

Trigger - Message - Filter Type Options

Value	Description
worker-licensed	Worker Licensed
worker-unlicensed	Worker Unlicensed
variable	Variable
variable-deleted	Variable Deleted
begin-shutting-down-job	Begin Shutting Down Job
begin-shutting-down-server	Begin Shutting Down Server
begin-shutting-down-worker	Begin Shutting Down Worker
broadcast-job-thread-state	Broadcast Job Thread State
broadcast-server-thread-state	Broadcast Server Thread State
broadcast-worker-thread-state	Broadcast Worker Thread State
check-job-report-time	Check Job Report Time
check-worker-report-time	Check Worker Report Time
de-register-job-thread-dependency	De Register Job Thread Dependency
de-register-server-thread-dependency	De Register Server Thread Dependency
de-register-worker-thread-dependency	De Register Worker Thread Dependency
deployed-job-active	Deployed Job Active
deployed-job-removed	Deployed Job Removed
deployed-job-should-be-running	Deployed Job Should Be Running
deployment-phase	Deployment Phase
heart-beat	Heart Beat
initialise-internal-state	Initialise Internal State
initialise-job-states	Initialise Job States
job-batch-end	Job Batch End
job-backlog-update	Job Backlog Update
job-checkpoint-update	Job Checkpoint Update
job-deploy-ready	Job Deploy Ready
job-deployed	Job Deployed
job-document-end	Job Document End
job-document-start	Job Document Start
job-errors	Job Errors
job-execution-anomaly	Job Execution Anomaly
job-execution-status	Job Execution Status
job-emit-custom	Job Emit Custom
job-finished	Job Finished
job-idle	Job Idle
job-initiated	Job Initiated
job-is-processing	Job Is Processing
job-logs	Job Logs
job-metrics	Job Metrics
job-notifications	Job Notifications
job-removing	Job Removing
job-removed	Job Removed
job-remove-failed	Job Remove Failed
job-remove-ready	Job Remove Ready
job-replaced	Job Replaced
job-required	Job Required
job-run-ended	Job Run Ended
job-runtime-error	Job Runtime Error
job-runtime-settings	Job Runtime Settings
job-run-started	Job Run Started
job-running-docker	Job Running Docker
job-running-script	Job Running Script
job-running-subprocess	Job Running Subprocess
job-running-system-d	Job Running System D
job-settings	Job Settings
job-step-statistics	Job Step Statistics
job-started	Job Started
job-staged	Job Staged
job-state-transition	Job State Transition
job-shutting-down	Job Shutting Down
job-stopping	Job Stopping
job-stopped	Job Stopped
job-timed-out	Job Timed Out
job-suspicious-silence	Job Suspicious Silence
job-thread-state	Job Thread State
job-trace	Job Trace
job-trace-requires-samples	Job Trace Requires Samples
job-updated	Job Updated
job-worker-comms-error	Job Worker Comms Error
job-unstaged	Job Unstaged
license-state-changed	License State Changed
license-validation-failed	License Validation Failed
license-validation-ok	License Validation Ok
license-volume-violation	License Volume Violation
new-license	New License
override-job-coordinated-shutdown	Override Job Coordinated Shutdown
override-server-coordinated-shutdown	Override Server Coordinated Shutdown
override-worker-coordinated-shutdown	Override Worker Coordinated Shutdown
register-job-thread-dependency	Register Job Thread Dependency
register-server-thread-dependency	Register Server Thread Dependency
register-worker-thread-dependency	Register Worker Thread Dependency
run-job-failure	Run Job Failure
server-logs	Server Logs
server-metrics-batch	Server Metrics Batch
server-started	Server Started
server-starting	Server Starting
server-stopping	Server Stopping
server-thread-state	Server Thread State
server-worker-comms-error	Server Worker Comms Error
shutdown-jobs	Shutdown Jobs
shutdown-worker	Shutdown Worker
system-shutdown	System Shutdown
update-upstream-sync-for-job	Update Upstream Sync For Job
update-upstream-sync-for-worker	Update Upstream Sync For Worker
update-variable	Update Variable
user-alert	User Alert
user-generated	User Generated
user-notification	User Notification
worker-command-for-job	Worker Command For Job
worker-auth-lease-ack	Worker Auth Lease Ack
worker-connected	Worker Connected
worker-created	Worker Created
worker-debug-heart-beat	Worker Debug Heart Beat
worker-error	Worker Error
worker-first-seen	Worker First Seen
worker-heart-beat	Worker Heart Beat
worker-logs	Worker Logs
worker-metrics-batch	Worker Metrics Batch
worker-offline	Worker Offline
worker-requests-auth-lease	Worker Requests Auth Lease
worker-server-comms-error	Worker Server Comms Error
worker-settings	Worker Settings
worker-shutdown	Worker Shutdown
worker-shutting-down	Worker Shutting Down
worker-started	Worker Started
worker-state-uuid	Worker State Uuid
worker-stopping	Worker Stopping
worker-suspicious-silence	Worker Suspicious Silence
worker-system-information	Worker System Information
worker-thread-state	Worker Thread State
worker-updated	Worker Updated
worker-modified	Worker Modified
worker-removed	Worker Removed
context-changed	Context Changed
rerender-deployment	Rerender Deployment
job-killed	Job Killed
message-serviced	Message Serviced
failed-to-service-message	Failed To Service Message
worker-wants-initial-settings	Worker Wants Initial Settings
worker-wants-initial-settings-reply	Worker Wants Initial Settings Reply
worker-wants-deployed-jobs	Worker Wants Deployed Jobs
worker-wants-deployed-jobs-reply	Worker Wants Deployed Jobs Reply
worker-wants-job-configuration	Worker Wants Job Configuration
worker-wants-job-configuration-reply	Worker Wants Job Configuration Reply
job-wants-dslir-key	Job Wants Dslir Key
job-wants-dslir-key-reply	Job Wants Dslir Key Reply
worker-wants-dslir-key	Worker Wants Dslir Key
worker-wants-dslir-key-reply	Worker Wants Dslir Key Reply
job-wants-variables	Job Wants Variables
job-wants-variables-reply	Job Wants Variables Reply
job-wants-credentials	Job Wants Credentials
job-wants-credentials-reply	Job Wants Credentials Reply
job-wants-credentials-error	Job Wants Credentials Error
job-wants-secret-variables-reply	Job Wants Secret Variables Reply
job-credentials-invalidated	Job Credentials Invalidated
aggregator-health	Aggregator Health
worker-verification-token	Worker Verification Token
worker-requests-verification-token	Worker Requests Verification Token
runtime-artifact-update	Runtime Artifact Update
runtime-artifact-update-ack	Runtime Artifact Update Ack
runtime-artifact-clear	Runtime Artifact Clear
runtime-artifact-clear-ack	Runtime Artifact Clear Ack
runtime-artifact-fetch	Runtime Artifact Fetch
runtime-artifact-fetch-reply	Runtime Artifact Fetch Reply
runtime-artifact-fetch-error	Runtime Artifact Fetch Error

Mode Options

Value	Description
read-session	Read Session
query-job	Query Job

Query Job - Priority Options

Value	Description
interactive	Interactive
batch	Batch