Menu
Load data into Elasticsearch
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
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 | esload |
| description | Load data into Elasticsearch |
Loads data from files (Parquet, JSON) into Elasticsearch indices. Supports custom mappings, document IDs, and timestamp-based index naming.
starlake esload [options]
--domain <value>: Domain name (required)--schema <value>: Schema/table name (required)--format <value>: Input file format: parquet, json, or json-array (required)--dataset <value>: Path to the input dataset--timestamp <value>: Elasticsearch index timestamp suffix, e.g. {@timestamp|yyyy.MM.dd}--id <value>: Attribute name to use as the Elasticsearch document ID--mapping <value>: Path to a custom Elasticsearch mapping file--conf k1=v1,k2=v2: Elasticsearch-Spark configuration options--reportFormat <value>: Report output format: console, json, or htmlstarlake esload --domain starbake --schema orders --format parquet
starlake esload --domain starbake --schema orders --format json --id order_id
starlake esload --domain starbake --schema orders --format parquet --timestamp "{@timestamp|yyyy.MM.dd}"
starlake esload --domain starbake --schema orders --format json --mapping /path/to/mapping.json
starlake esload --domain starbake --schema orders --format parquet --dataset /data/orders/