Skip to main content

CLI to conveniently run DuckDB SQL scripts with support for templating

Project description

# Qck 🦆👩‍💻

Qck (pronounced “quack”) is a CLI script to conveniently run [DuckDB](https://duckdb.org/) SQL scripts with support for [Jina](https://jinja.palletsprojects.com/) templating.

## 🛠️ Installation

Use pip install qck to install. This will make available the qck script.

## 🚀 Usage

Run qck –help to view the built-in documentation.

Running qck with just a SQL file will execute the query and print the results to the terminal:

`bash qck myquery.sql `

You can also LIMIT the number of rows in the output by adding a flag:

`bash qck myquery.sql --limit 10 # will only print 10 rows `

To execute a query and write the result to a Parquet file, use –to-parquet:

`bash qck myquery.sql --to-parquet myresult.parquet `

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

qck-2024.2.1.tar.gz (3.4 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page