v.23.5Improvement

Add Google Cloud Storage S3 Compatible Table Function gcs

Official CH changelog text
Add Google Cloud Storage S3 compatible table function gcs. Like the oss and cosn functions, it is just an alias over the s3 table function, and it does not bring any new features. #47815 (Kuba Kaflik).
Introduces a new table function gcs in ClickHouse that provides Google Cloud Storage S3 compatible access as an alias to the existing s3 table function.

Why it matters

This feature simplifies using Google Cloud Storage with ClickHouse by providing a direct and intuitive alias (gcs) for connecting to GCS buckets using the S3 compatible interface, similar to existing oss and cosn functions. It helps users avoid manual configuration and enhances usability without adding new functionality.

How to use it

Users can access Google Cloud Storage by calling the gcs table function in their queries the same way they use the s3 table function. For example:

SELECT * FROM gcs('bucket_name/path/to/file', 'format')

This function acts as an alias to s3, so all S3-compatible parameters apply as usual.

Related resources

PreviousNext