Menü
Extract schemas directly from BigQuery datasets
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
| 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
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