Mode Analytics on Redshift
  • 08 Jul 2021
  • 1 Minute to read
  • Dark
    Light
  • PDF

Mode Analytics on Redshift

  • Dark
    Light
  • PDF

Article summary

Panoply on Redshift

To connect Mode Analytics to Panoply:

  1. First of all, you must be in an organization account to be able to connect a private database connection.
  2. On first time use, in the Home Page, click Connect Database button.
    mode-1-connect-to-db RS.png

Alternatively, you can also connect to the database by clicking your organization just below the Mode logo in the top left corner.

mode-2-click-organization RS.png

And select Connect a Database.
mode-3-select-connect-db RS.png

  1. A list of common databases to connect to will appear. Choose PostgreSQL.

mode-4-select-postgres RS.png

  1. Enter the server and database connection details, which are found on the Connect page in Panoply.
Note

Make sure to set the value of the Port field to 5439, because, by default, it is set to 5432.

mode-5-postgres-config RS.png

  1. Click the Connect button, and you’ll be redirected to successful page notification.

mode-6-connect-success RS.png

  1. Click New Report button to use your data right away.

mode-7-new-report RS.png

You have successfully connected Mode Analytics to your Panoply data warehouse.


Was this article helpful?

What's Next