Snowflake Postgres

Setting up Snowflake Postgres

Select Snowflake Postgres from the integrations page.

Connect using either a form or a connection string.

Fill out the form with the following settings:

Setting	Required	Description
Name	✓	Name that will be displayed to users when selecting this integration in Superblocks
Host	✓	Hostname or IP address to connect to (e.g. `xxxx.us-west-2.aws.postgres.snowflake.app`)
Port	✓	Port to use when connecting (default: `5432`)
Database Name	✓	Name of database to connect to
Database Username	✓	Username to use to connect
Database Password	✓	Password for database username
Use a self-signed SSL certificate	✗	Provide Server CA, Client Key, and Client Cert

Provide a PostgreSQL connection string in the following format:

postgresql://username:password@host:port/database

Click Test Connection to check that Superblocks can connect to the data source.

If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for Hybrid or Cloud-Prem deployments).

After connecting successfully, click Create to save the integration.

Optionally, configure different data tags for separate development environments.

Snowflake Postgres connected!
You can now use Clark to build with Snowflake Postgres.

Check out our guide on common errors across database integrations. If you are encountering an error that you don’t see in the guide, or the provided steps are insufficient to resolve the error, please contact us at help@superblocks.com.