Run a SQL query with DuckDB on MotherDuck and get the result as a CSV file

Source

yaml

id: motherduck
namespace: company.team
tasks:
  - id: query
    type: io.kestra.plugin.jdbc.duckdb.Query
    sql: |
      SELECT by, COUNT(*) as nr_comments 
      FROM sample_data.hn.hacker_news
      GROUP BY by
      ORDER BY nr_comments DESC;
    fetchType: STORE
  - id: csv
    type: io.kestra.plugin.serdes.csv.IonToCsv
    from: "{{ outputs.query.uri }}"
pluginDefaults:
  - type: io.kestra.plugin.jdbc.duckdb.Query
    values:
      url: jdbc:duckdb:md:my_db?motherduck_token={{ secret('MOTHERDUCK_TOKEN') }}
      timeZoneId: Europe/Berlin

About this blueprint

SQL DuckDB

This flow demonstrates how you can query data stored on MotherDuck using DuckDB. The IonToCsv returns the output as a CSV file which you can download from the Execution page.

Query

Ion To Csv

More Related Blueprints

Python SQL Outputs API DuckDB

Extract data from a REST API, process it in Python with Polars in a Docker container, then run DuckDB query and preview results as a table in the Outp...

Trigger SQL Schedule Outputs Notifications DuckDB

Query a CSV file with DuckDB and send results via Slack every Monday

SQL Outputs DuckDB

Analyze salaries of data professionals using a SQL query in DuckDB, extract the results to a CSV file

New to Kestra?

Use blueprints to kickstart your first workflows.

Get started with Kestra