MotherDuck - Execute Query

Overview

Quickly execute a SQL query against MotherDuck databases. This blueprint is intended for DDL queries (i.e. CREATE, ALTER, DROP) as the results are not returned to Workflows

Variables

Name	Reference	Type	Required	Default	Options	Description
Access Token	MOTHERDUCK_TOKEN	Password	✅	-	-	The API token for programmatic access to MotherDuck
Query	MOTHERDUCK_QUERY	Alphanumeric	✅	-	-	The SQL query to execute against MotherDuck
Database	MOTHERDUCK_DATABASE	Alphanumeric	➖	-	-	The optional database to connect to

YAML

Below is the YAML template

YAML


source:
  template: MotherDuck - Execute Query
  inputs:
    MOTHERDUCK_TOKEN:
    MOTHERDUCK_QUERY:
    MOTHERDUCK_DATABASE:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 200
    - 221
    - 249