メニュー
Extract schemas directly from BigQuery datasets
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
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