> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superblocks.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake Postgres

> Build apps with read and write access to a Snowflake Postgres database

export const IntegrationSuccess = ({integrationName}) => {
  return <p>
      <b>{integrationName} connected!</b><br />You can now use{" "}
      <a href="/building-with-clark">Clark to build</a> with {integrationName}.
    </p>;
};

export const Alert = ({type, title, children}) => {
  const variant = ["info", "success", "warning", "danger", "note"].includes(type) ? type : "note";
  return <div className={`alert alert--${variant}`}>
      <div className="alert-icon" />
      <div className="alert-content">
        {title && <div className="alert-title">{title}</div>}
        <div className="alert-body">{children}</div>
      </div>
    </div>;
};

## Setting up Snowflake Postgres

### 1. Add integration

Select **Snowflake Postgres** from the [integrations page](https://app.superblocks.com/integrations/snowflakepostgres).

### 2. Configure settings

Connect using either a form or a connection string.

<Tabs>
  <Tab title="Form">
    <br />Fill out the form with the following settings:

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

  <Tab title="Connection string">
    <br />Provide a PostgreSQL connection string in the following format:

    ```
    postgresql://username:password@host:port/database
    ```
  </Tab>
</Tabs>

### 3. Test and save

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

<Alert type="info">
  If using Superblocks Cloud, add these <a href="/enterprise/security/overview#ip-addresses">Superblocks IPs</a> to your allowlist (not necessary for Hybrid or Cloud-Prem deployments).
</Alert>

After connecting successfully, click **Create** to save the integration.

### 4. Set data tags

Optionally, configure different data tags for [separate development environments](/development-lifecycle/build/data-tags).

<Alert type="success">
  <IntegrationSuccess integrationName="Snowflake Postgres" />
</Alert>

## Troubleshooting

Check out our guide on [common errors across database integrations](/integrations/troubleshooting/troubleshooting-databases). 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](mailto:help@superblocks.com).