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   
└─────────────────────────────────────────┴─────────┴───────┴──────────────────────────┘