Google Cloud Integration

UniverSQL enables efficient querying of Snowflake Iceberg tables stored in Google Cloud Storage (GCS) using your local compute resources, significantly reducing Snowflake warehouse compute costs.

Setup GCP Credentials

1. First, install the Google Cloud SDK
2. Configure your GCP credentials

# Login with your Google Cloud account
gcloud auth application-default login

Using GCP Project with UniverSQL

By default, UniverSQL uses your default GCP account attached to gcloud. You can specify a different project using the --gcp-project option:

universql snowflake --account your_account --gcp-project custom_project

Features

• Direct access to GCS-stored Iceberg tables without Snowflake warehouse compute
• Smart caching of Parquet files for better performance
• Support for GCP IAM authentication
• Automatic handling of GCP credentials and project settings
• Predicate pushdown support for partitioned tables

Best Practices

1. Use appropriate IAM roles with minimal required permissions
2. Configure GCP credentials securely
3. Utilize partitioned tables for better performance
4. Monitor GCS egress costs