Search Shortcut cmd + k | ctrl + k
Search cmd+k ctrl+k
0.10 (stable)
GCS Import

Prerequisites

For Google Cloud Storage (GCS), the Interoperability API enables you to have access to it like an S3 connection using the httpfs extension. This can be installed with the INSTALL SQL command. This only needs to be run once.

Credentials and Configuration

You need to create HMAC keys and declare them:

CREATE SECRET (
    TYPE GCS,
    KEY_ID 'AKIAIOSFODNN7EXAMPLE',
    SECRET 'wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY'
);

Querying

After setting up the GCS credentials, you can query the GCS data using:

SELECT *
FROM read_parquet('gs://⟨gcs_bucket⟩/⟨file⟩');
About this page

Last modified: 2024-04-18