Menu
Extract schemas directly from BigQuery datasets
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 | extract-bq-schema |
| description | Extract schemas directly from BigQuery datasets |
Extracts table schemas directly from BigQuery datasets into Starlake YAML configuration files. Unlike extract-schema which uses JDBC, this command uses the BigQuery API directly for better metadata extraction.
starlake extract-bq-schema [options]
--connection <value>: BigQuery connection reference from application.sl.yml--database <value>: GCP Project ID--tables <value>: Comma-separated list of dataset.table pairs to extract--external: Include external datasets defined in _config.sl.yml--write <value>: Write mode for output: OVERWRITE, APPEND--accessToken <value>: Access token for GCP authentication--persist <value>: Persist results to files (true/false)--reportFormat <value>: Report output format: console, json, or htmlRequires a BigQuery connection in application.sl.yml:
# metadata/application.sl.yml
version: 1
application:
connections:
bigquery:
type: "bigquery"
options:
location: "europe-west1"
authType: "APPLICATION_DEFAULT"
authScopes: "https://www.googleapis.com/auth/cloud-platform"
writeMethod: "direct"
starlake extract-bq-schema --database my-gcp-project
starlake extract-bq-schema --database my-gcp-project --tables sales.orders,sales.customers
starlake extract-bq-schema --database my-gcp-project --persist true
starlake extract-bq-schema --database my-gcp-project --external