Menü
Load files (Parquet/CSV/JSON) into a JDBC table
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Basierend auf der SOC-Berufsklassifikation
Manage GizmoSQL processes: start, stop, list, and stop-all DuckLake-backed SQL servers
Create or modify database connections in application.sl.yml
Manage Quack DuckDB query servers exposing DuckLake over a thin remote protocol — serve (foreground), start/stop/list/stop-all (background)
Automatically infer schemas and load data from the incoming directory
Data quality expectations syntax, built-in macros, and validation patterns
Apply Row Level Security (RLS) and Column Level Security (CLS) policies
| name | cnxload |
| description | Load files (Parquet/CSV/JSON) into a JDBC table |
Loads data from Parquet, CSV, or JSON files directly into a JDBC database table. This provides a simple way to push data into any JDBC-compatible database without going through the full Starlake load pipeline.
starlake cnxload [options]
--source_file <value>: Full path to the source file (required). Supports Parquet, CSV, JSON--output_table <value>: Target JDBC table in schema.table format (required)--options k1=v1,k2=v2: JDBC connection options:
driver: JDBC driver class (e.g. org.postgresql.Driver)user: Database userpassword: Database passwordurl: JDBC URL (e.g. jdbc:postgresql://localhost:5432/mydb)partitions: Number of partitions for parallel writebatchSize: Batch size for inserts--write_strategy <value>: Write strategy: APPEND, OVERWRITE--reportFormat <value>: Report output format: console, json, or htmlstarlake cnxload \
--source_file /data/orders.parquet \
--output_table public.orders \
--options driver=org.postgresql.Driver,url=jdbc:postgresql://localhost:5432/mydb,user=admin,password=secret \
--write_strategy APPEND
starlake cnxload \
--source_file /data/customers.csv \
--output_table public.customers \
--options driver=org.postgresql.Driver,url=jdbc:postgresql://localhost:5432/mydb,user=admin,password=secret \
--write_strategy OVERWRITE
starlake cnxload \
--source_file /data/orders.parquet \
--output_table sales.orders \
--options driver=com.mysql.cj.jdbc.Driver,url=jdbc:mysql://localhost:3306/mydb,user=root,password=secret,batchSize=5000 \
--write_strategy APPEND