Breadcrumbs

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