Skip to main content

bit.io - Execute Query

Overview​

Execute any SQL query against a bit.io database, without returning any of the resulting data. This Blueprint should primarily be used for queries that perform functionality other than SELECT, like multi-step SQL jobs, or DML statements.

Variables​

NameReferenceTypeRequiredDefaultOptionsDescription
PasswordBITIO_PASSWORDPasswordβœ…--Password associated to your bit.io account. For more information, see the Authorization documentation.
DatabaseBITIO_DATABASEAlphanumericβœ…--Name of the database to connect to. This is the same as your current repository name, which has the structure user_name/repo_name.
QueryBITIO_QUERYAlphanumericβœ…--Any SQL query that runs a job against the database (CREATE, DROP, INSERT, etc.). Formatting is ignored.

YAML​

Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.

source:
blueprint: bit.io - Execute Query
inputs:
BITIO_PASSWORD: null ## REQUIRED
BITIO_DATABASE: null ## REQUIRED
BITIO_QUERY: null ## REQUIRED
type: BLUEPRINT
guardrails:
retry_count: 1
retry_wait: 0h0m0s
runtime_cutoff: 1h0m0s
exclude_exit_code_ranges:
- '0'