Periscope
Periscope is a cloud based data management platform. Periscope eliminates the overhead of preparing and modeling data, and managing cloud infrastructure.
Setup guide
Follow our step-by-step Periscope setup guide to connect Periscope with Fivetran.
Type transformation mapping
The data types in Periscope 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
Periscope does not charge you extra when Fivetran loads data into your destination.