Selecting Data from Google Cloud Storage Using ClickHouse

Create keys to access the bucket from ClickHouse

gcloud storage hmac create {service-account}

Use the keys to create a named collection in ClickHouse

CREATE NAMED COLLECTION bucket AS
    url = 'https://storage.googleapis.com/{bucket}/*.parquet',
    access_key_id = '{access-key-id}',
    secret_access_key = '{secret-access-key}'
;

Query the data from the bucket

SELECT *
FROM gcs(bucket)
LIMIT 10