spiral sql
Run DataFusion SQL and SPQL functions
Install spiral-sql to run this command. spiral sql forwards arguments to spiral-sql; both commands run DataFusion SQL.
Run DataFusion SQL and SPQL functions locally. With no SQL input in a terminal, start an interactive session with history and multiline editing; end SQL with a semicolon, and use .quit or Ctrl-D to exit. Supply SQL as a positional argument, with --command, with --file, or through standard input. Use --project to read and write Spiral Tables; --branch selects the publication branch. Statements in a script run sequentially and stop on the first error. Successful writes publish independently; a later error does not roll them back.
Usage: spiral sql [OPTIONS] [QUERY]Arguments
| Argument | Required | Default | Description |
|---|---|---|---|
QUERY | no | SQL text to execute |
Options
| Option | Required | Default | Description |
|---|---|---|---|
-c, --command <COMMAND> | no | SQL text to execute | |
-f, --file <PATH> | no | Read SQL from a file; use - for standard input | |
-p, --project <PROJECT> | no | Project whose Tables are available by resource path | |
--branch <BRANCH> | no | Branch to read and publish to; defaults to main | |
--format <FORMAT> | no | table | Result format. JSON emits one array per statement; table output prints batches |
Found a problem? Edit this page or report an issue.