القائمة
Extract schemas directly from BigQuery datasets
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
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
استنادا إلى تصنيف SOC المهني
| 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