Panoply is a fully managed data warehouse service that will spin up a Redshift instance in just a few clicks. With Panoply, you can use your favorite analysis, SQL, and visualization tools just like you would if you were creating a Redshift data warehouse on your own.

Panoply Setup Requirements

To set up Panoply in Stitch, you need:

  • Admin permissions in Panoply.


Step 1: Locate the Connection Details in Panoply

  1. Sign into your Panoply account.
  2. In the left panel menu, click Connect.
  3. The database connection info - the host, port, database name, and username - will display.

Leave this page open - you’ll need it in the next step.


Step 2: Connect Stitch

  1. If you aren’t signed into your Stitch account, sign in now.
  2. Click the Destination tab.
  3. Click the Panoply icon.
  4. Fill in the fields as follows:

    • Host (Endpoint): Enter the host address (endpoint) used by the Panoply instance.

    • Port: Enter the port used by the Panoply instance. The default is 5439.

    • Username: Enter the username of the database user you want to use to connect Panoply to Stitch.

    • Password: Enter the password of the database user you want to use to connect Panoply to Stitch.

    • Database: Enter the name of the database in your Panoply data warehouse you want to connect to Stitch.

When finished, click Update Panoply Settings.

Stitch will perform a connection test to the Panoply database; if successful, a Success! mesage will display at the top of the screen. Note: This test may take a few minutes to complete.


Troubleshooting

If you receive an error message, reach out to support for assistance.


Learning About Stitch & Panoply

Now that your Panoply data warehouse is up and running, we recommend learning about how Stitch will load your data into it.

  • Panoply Destination Overview: This overview will give you the high-level basics for working with your Panoply data warehouse.

  • Destination Data Loading Guide: This article covers many of the common scenarios Stitch will encounter when loading data into your Panoply destination and the expected behavior for each scenario.


Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.