wehub-resource-sync
e04ed9c211
CF: Deploy Dev Docs / deploy (push) Has been cancelled
Sync Labels / build (push) Has been cancelled
tests / unit tests (macos-latest) (push) Has been cancelled
tests / unit tests (windows-latest) (push) Has been cancelled
tests / unit tests (ubuntu-latest) (push) Has been cancelled
26 lines
1004 B
Markdown
26 lines
1004 B
Markdown
---
|
|
title: "Spanner (PostgreSQL dialect)"
|
|
type: docs
|
|
description: "Details of the Spanner (PostgreSQL dialect) prebuilt configuration."
|
|
---
|
|
|
|
## Spanner (PostgreSQL dialect)
|
|
|
|
* `--prebuilt` value: `spanner-postgres`
|
|
* **Environment Variables:**
|
|
* `SPANNER_PROJECT`: The GCP project ID.
|
|
* `SPANNER_INSTANCE`: The Spanner instance ID.
|
|
* `SPANNER_DATABASE`: The Spanner database ID.
|
|
* **Permissions:**
|
|
* **Cloud Spanner Database Reader** (`roles/spanner.databaseReader`) to
|
|
execute DQL queries and list tables.
|
|
* **Cloud Spanner Database User** (`roles/spanner.databaseUser`) to
|
|
execute DML queries.
|
|
* **Tools:**
|
|
* `execute_sql`: Executes a DML SQL query using the PostgreSQL interface
|
|
for Spanner.
|
|
* `execute_sql_dql`: Executes a DQL SQL query using the PostgreSQL
|
|
interface for Spanner.
|
|
* `list_tables`: Lists tables in the database.
|
|
* `search_catalog`: Searches for data assets in Knowledge Catalog (Dataplex).
|