Downloads n/athis week

GitHub stars 0

Extension repository on GitHub

Extension descriptor (YAML)

Query Google Cloud logs, metrics, alerts, and service topology from DuckDB

Installing and Loading

INSTALL gcloud_observability FROM community;
LOAD gcloud_observability;

Example

LOAD gcloud_observability;

-- Uses Google Application Default Credentials.
SELECT time_unix_nano, severity_text, service_name, body
FROM read_gcloud_logs(
    project => 'my-project',
    filter => 'severity >= WARNING',
    start_time => '-1h'
);

About gcloud_observability

This extension reads and writes Google Cloud Observability telemetry using Application Default Credentials or DuckDB secrets. Cloud Logging rows use the same flat OTLP log schema as duckdb-otlp, making them directly composable with the Datadog, Splunk, and CloudWatch extensions.

Features:

• Cloud Logging reads with pagination, retries, and safe filter pushdown
• Batched writes through send_gcloud_logs
• Cloud Monitoring metric queries and alert tables
• App Topology service dependency queries
• A read-only attached catalog for logs, alerts, and service maps
• OAuth2 support for authorized-user, service-account, and pre-minted token credentials

For setup, IAM requirements, and the complete SQL reference, visit the extension repository.

Added Functions

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings

This extension does not add any settings.