Skip to Content

Supported connectors

Connect Neon

Connect your Neon Postgres database with its connection string.

The Neon tile uses the PostgreSQL connector with SSL turned on. Your saved datasource is a PostgreSQL datasource.

Before you start

  • You are an Admin or a Developer, or your role has the datasource Connect permission.
  • You have a Postgres role with SELECT on the tables you want to read. A dedicated role is best.
  • If your project has an IP allow list, it allows Databrain’s outbound IP. See Allow Databrain’s IP.

Copy the connection string

  1. Open your project in the Neon console and select Connect.
  2. Choose the branch, database and role.
  3. Copy the PostgreSQL connection string. Pooled and direct strings both work.

Connect

  1. Go to Data Studio > Datasources and select Connect data source.

    Datasources page with the Connect data source button outlined
    Connect data source is at the top right of the Datasources page.
  2. Select Neon.

    Add datasource page with the Neon tile outlined
    The Neon tile on the Add datasource page.
  3. Paste the string into Connection string. Databrain fills the host, database, user and password. A string with sslmode=require also sets SSL mode.

  4. Enter a Datasource name, for example Neon production.

  5. Keep SSL mode at require.

  6. Select Connect datasource.

Connect Neon form with the connect button outlined and the Setup guide on the right
Fill in the form, then select the button at the bottom. The Setup guide on the right lists the grants and where each value comes from.

Databrain checks the connection and reads your schema. Next, create a datamart.

If something goes wrong

  • The first connection is slow. Neon compute sleeps when idle. The first connection waits while it wakes up. Try again.
  • The connection failed while negotiating TLS. Set SSL mode to require.

On this page