MENU
    Mode Analytics on Redshift
    • 08 Jul 2021
    • 1 Minute to read

    Mode Analytics on Redshift


    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?