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.
If you’re looking for a cost-effective, no-effort way to test out Stitch or get started consolidating your data, Panoply is your best bet.
Pricing
Pricing varies from plan to plan, but every Panoply plan includes:
- Unlimited queries
- Unlimited user accounts
- Automatic maintenance, vacuuming, and backups
Panoply charges based on the amount of data stored and offers several plan options for your needs. Refer to their pricing page for more information.
Setup
High-level details about Stitch’s implementation of Panoply, such as supported connection methods, availability on Stitch plans, etc.
Replication
Details about Stitch and replication for Panoply destinations.
Incremental Replication - Upserts |
Supported Using a table’s Primary Keys, Stitch will perform an update operation on existing rows to overwrite the data. |
Primary Keys |
Unsupported Panoply destinations do not have native support for Primary Keys. As Stitch requires Primary Keys to de-dupe data during Incremental Replication, Primary Keys for tables are retained using table comments. Removing or incorrectly altering table comments can lead to replication issues. |
Multipe data types |
Unsupported Panoply destinations do not support multiple data types in a single column. To accommodate this scenario, Stitch will create additional columns for each data type. Refer to the Table structural changes guide for examples and more info. |
Nested data structure support |
Unsupported Panoply destinations do not have native support for nested data structures. To ensure nested data can be loaded, Stitch will flatten objects and arrays into columns and subtables, respectively. For more info and examples, refer to the Handling nested data structures guide. |
Incompatible sources |
Has possible incompatibilities Incompatibilities may exist with the following integrations: Refer to the Destination and integration compatibility guide for more info. |
Limitations
In this section:
-
Object name limits - Details about object naming rules imposed by Panoply destinations.
-
Table limits - Details about table rules imposed by Panoply destinations.
-
Data limits - Details about data limitations imposed by Panoply destinations.
-
Column naming - Details about transformations performed by Stitch to ensure source column names adhere to the object naming rules imposed by Panoply destinations.
Object name limits
Details about object naming rules imposed by Panoply destinations.
Case sensitivity |
Insensitive This means that Panoply destinations treat upper- and lowercase characters as the same. For example: When column names are loaded into Panoply, any uppercase characters will be forced into lowercase. This means that |
Table name length |
127 characters Tables with names that exceed this limit will be rejected. Rejected tables are logged in the |
Column name length |
115 characters Columns with names that exceed this limit will be rejected. Rejected columns are logged in the |
Table limits
Details about table rules imposed by Panoply destinations.
Max # of columns per table |
1,600 columns |
Max # of tables per database |
100,000 tables |
Data limits
Details about data limitations imposed by Panoply destinations.
Max record size |
4 MB Records that exceed this limit will be rejected. Rejected columns are logged in the |
Timezone support |
Unsupported Panoply will store the value in UTC as More info about timestamp data types can be found in Amazon’s documentation. |
Date ranges |
4713 BC to 294276 AD Date values outside of this range will be rejected and logged in the More info about Panoply date data types can be found in Amazon’s documentation. |
Timestamp ranges |
4713 BC to 294276 AD Timestamp values outside of this range will be rejected and logged in the More info about Panoply time data types can be found in Amazon’s documentation. |
Integer range |
-9223372036854775808 to 9223372036854775807 Integer values outside of this range will be rejected and logged in the |
Decimal precision |
Must be between 1 and 38 (38 is the default) Decimal values outside of this range will be rejected and logged in the |
Decimal scale |
Must be between 0 and the precision value Decimal values outside of this range will be rejected and logged in the |
VARCHAR max width |
65K String values outside of this range will be rejected and logged in the |
Column naming
Details about transformations performed by Stitch to ensure source column names adhere to the object naming rules imposed by Panoply destinations.
Compare destinations
Not sure if Panoply is the data warehouse for you? Check out the Choosing a Stitch Destination guide to compare each of Stitch’s destination offerings.
Related | Troubleshooting |
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.