skippr query
Run a read-only SQL query against the destination configured on the pipeline's data_sink. The destination is the same data_sinks plugin object used by skippr sync and skippr model. Only SELECT / WITH statements are accepted.
Usage
bash
skippr [--config <path>] query --pipeline <name> --sql '<SQL>' [--output json|jsonl]Flags
| Flag | Description |
|---|---|
--pipeline <name> | Pipeline whose data_sink should execute the query. |
--sql <SQL> | Read-only SQL. Only SELECT / WITH queries are accepted. |
--output json | JSON result (default). |
--output jsonl | JSON lines. |
Example
bash
skippr query --pipeline mssql-migration --sql 'SELECT COUNT(*) FROM RAW.CUSTOMERS'Athena, Snowflake, BigQuery, Postgres, and the other warehouse sinks all query from their data_sinks fields. Iceberg pipelines query through query_engine on the Iceberg sink (type: athena), not a separate Athena block.
See also
skippr sync— load bronze data firstskippr model— generate dbt against the same sink- skippr.yml