drivers
Usage
.drivers
Description
The drivers command displays the available data drivers.
| Driver | Description | URL |
|---|---|---|
arrow | Arrow IPC provided by Polars | arrow://<file> |
avro | Avro provided by Polars | avro://<file> |
brotli | Brotli compressed file | brotli://<file> |
bzip2 | Bzip2 compressed file | bzip2://<file> |
cockroachdb | CockroachDB provided by SQLx | cockroachdb://<user>[:<password>]@<host>[:<port>]/<database> |
csv | Comma Separated Value (CSV) provided by Polars | csv://<file>[?has_header=<true\|false>]["e=<char>][&skip_rows=<n>] |
delimited | Delimited provided by Polars | delimited://<file>[?separator=<char>][&has_header=<true\|false>]["e=<char>][&skip_rows=<n>] |
duckdb | DuckDB provided by DuckDB | duckdb://[<file>] |
dynamodb | DynamoDB | dynamodb://[<access_key_id>:<secret_access_key>@]<host>[:<port>]>[?region=<region>][&session_token=<token>][&scheme=<http\|https>] |
excel | Excel | excel://<file>[?has_header=<true\|false>][&skip_rows=<n>] |
file | File | file://<file> |
fwf | Fixed Width Format | fwf://<file>?widths=<widths>[&headers=<headers>] |
gzip | Gzip compressed file | gzip://<file> |
http | HTTP | http://<path>[?_headers=<headers>] |
https | HTTPS | https://<path>[?_headers=<headers>] |
json | JSON provided by Polars | json://<file> |
jsonl | JSONL provided by Polars | jsonl://<file> |
libsql | LibSQL provided by Turso | libsql://<host>?[<memory=true>][&file=<database_file>][&auth_token=<token>] |
lz4 | LZ4 compressed file | lz4://<file> |
mariadb | MariaDB provided by SQLx | mariadb://<user>[:<password>]@<host>[:<port>]/<database> |
mysql | MySQL provided by SQLx | mysql://<user>[:<password>]@<host>[:<port>]/<database> |
ods | OpenDocument Spreadsheet | ods://<file>[?has_header=<true\|false>][&skip_rows=<n>] |
orc | Optimized Row Columnar (ORC) | orc://<file> |
parquet | Parquet provided by Polars | parquet://<file> |
postgres | PostgreSQL provided by rust-postgres | postgres://<user>[:<password>]@<host>[:<port>]/<database>?<embedded=true> |
postgresql | PostgreSQL provided by SQLx | postgresql://<user>[:<password>]@<host>[:<port>]/<database>?<embedded=true> |
redshift | Redshift provided by SQLx | redshift://<user>[:<password>]@<host>[:<port>]/<database> |
rusqlite | SQLite provided by Rusqlite | rusqlite://[<file>] |
s3 | Simple Storage Service (S3) | s3://[<access_key_id>:<secret_access_key>@]<host>[:<port>]/<bucket>/<object>[?region=<region>][&session_token=<token>][&force_path_style=(true\|false)][&scheme=<http\|https>] |
snowflake | Snowflake provided by Snowflake SQL API | snowflake://<user>[:<token>]@<account>.snowflakecomputing.com/[?private_key_file=pkey_file&public_key_file=pubkey_file] |
sqlite | SQLite provided by SQLx | sqlite://[<file>] |
sqlserver | SQL Server provided by Tiberius | sqlserver://<user>[:<password>]@<host>[:<port>]/<database> |
tsv | Tab Separated Value (TSV) provided by Polars | tsv://<file>[?has_header=<true\|false>]["e=<char>][&skip_rows=<n>] |
xml | Extensible Markup Language (XML) provided by Polars | xml://<file> |
xz | XZ compressed file | xz://<file> |
yaml | Extensible Markup Language (YAML) provided by Polars | yaml://<file> |
zstd | Zstd compressed file | zstd://<file> |
Examples
Show the available drivers:
.drivers
Demonstration
