Panoply
Panoply provides continuous, automated data modeling and maintenance over Redshift. From ingestion to query, Panoply automates and simplifies data analytics, eliminating the overhead of preparing and modeling data, and managing cloud infrastructure.
Setup guide
Follow our step-by-step Panoply setup guide to connect Panoply with Fivetran.
Type transformation mapping
The data types in Panoply follow Fivetran's standard data type storage.
We use the following data type conversions:
| Fivetran Data Type | Destination Data Type | Notes |
|---|---|---|
| BOOLEAN | BOOLEAN | |
| SHORT | SMALLINT | |
| INT | INTEGER | |
| LONG | BIGINT | |
| BIGDECIMAL | DECIMAL | |
| FLOAT | REAL | |
| DOUBLE | DOUBLEPRECISION | |
| LOCALDATE | DATE | |
| LOCALDATETIME | TIMESTAMP | |
| INSTANT | TIMESTAMP | |
| STRING | VARCHAR or TEXT | VARCHAR if bytelengthis present, else TEXT |
| JSON | VARCHAR | |
| BINARY | VARCHAR |
Data load costs
Panoply does not charge you extra when Fivetran loads data into your destination.