Search Shortcut cmd + k | ctrl + k
gcs

DuckDB GCS Extension

Maintainer(s): northpolesec

Installing and Loading

INSTALL gcs FROM community;
LOAD gcs;

Example

-- Add auth credentials using Application Default Creds
D CREATE SECRET secret (TYPE gcp, PROVIDER credential_chain);

-- Read a file from GCS
D SELECT * FROM read_text('gcss://rah-public-gcs-testing/quack.txt');
┌─────────────────────────────────────────┬─────────┬───────┬──────────────────────────┐
│                filename                 │ content │ size  │      last_modified       │
│                 varchar                 │ varchar │ int64 │ timestamp with time zone │
├─────────────────────────────────────────┼─────────┼───────┼──────────────────────────┤
│ gcss://rah-public-gcs-testing/quack.txt │ 🦆      │   4   │ 2025-09-23 16:20:03-04   │
└─────────────────────────────────────────┴─────────┴───────┴──────────────────────────┘