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.
Stitch is in no way involved with the management of Panoply data warehouses. If you have billing questions or need help regarding your Panoply data warehouse, reach out to Panoply.
Panoply Setup Requirements
To set up Panoply in Stitch, you need:
Admin permissions in Panoply.
Step 1: Locate the Connection Details in Panoply
- Sign into your Panoply account.
- In the left panel menu, click Connect.
- 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
- If you aren’t signed into your Stitch account, sign in now.
- Click the Destination tab.
- Click the Panoply icon.
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
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.
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.