Identify your version


Version history

All versions for Stitch's Google CloudSQL PostgreSQL integration, including release and deprecation dates.

Version Status Release date Deprecation date End of life (Sunset)
version 1 (latest) Released July 31, 2018
version 15-10-2015 Sunset October 15, 2015 September 6, 2019 December 1, 2019

Google CloudSQL PostgreSQL version features

In this section:

Google CloudSQL PostgreSQL version comparison

Google CloudSQL PostgreSQL
version 1
(latest)
STITCH
Release status

Released on July 31, 2018

Supported by

Stitch

Stitch plan

Free

Supported versions

9.3+

API availability

Available

Singer GitHub repository

singer-io/tap-postgres

CONNECTION METHODS
SSH connections

Unsupported

SSL connections

Unsupported

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Supported

Configurable Replication Methods

Supported

REPLICATION METHODS
Log-based Replication

Unsupported

Key-based Replication

Supported

Full Table Replication

Supported

DATA SELECTION
Table selection

Supported

Column selection

Supported

View replication

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Data types

In the table below are the data types Google CloudSQL PostgreSQL integrations support and the Stitch data type it will map to, depending on the version of the integration being used:

  • indicates that the data type is supported. Following the icon is the Stitch data type it will map to.
  • indicates that the data type is supported, but there is additional information you should know. Hover over the icon to view a tooltip with the information.
  • indicates that the data type isn't applicable to the integration. This is usually because the integration doesn't use that particular data type.
  • indicates that the data type isn't supported. In Stitch, columns with unsupported data types will have Unavailable in the Type column of the Tables to Replicate tab.

Refer to the Data typing guide for more info about how Stitch identifies and types data when it's loaded into your destination.

Google CloudSQL PostgreSQL
version 1
(latest)
Google CloudSQL PostgreSQL
version 15-10-2015
ARRAY ARRAY STRING
BIGINT INTEGER INTEGER
BIT BOOLEAN BOOLEAN
CHAR STRING STRING
CIDR STRING UNSUPPORTED
CITEXT STRING UNSUPPORTED
DATE STRING , formatted as DATE-TIME STRING , formatted as DATE-TIME
DECIMAL NUMBER NUMBER
DOUBLE NUMBER NUMBER
FLOAT NUMBER NUMBER
HSTORE OBJECT STRING
INET STRING STRING
INTEGER INTEGER INTEGER
IP STRING UNSUPPORTED
JSON ARRAY STRING
JSONB ARRAY STRING
LONGNVARCHAR STRING STRING
LONGVARCHAR STRING STRING
MACADDR STRING UNSUPPORTED
MONEY STRING UNSUPPORTED
NCHAR STRING STRING
NUMERIC NUMBER NUMBER
NVARCHAR STRING STRING
REAL NUMBER NUMBER
SMALLINT INTEGER INTEGER
TIME STRING , formatted as DATE-TIME STRING , formatted as DATE-TIME
TIMESTAMP STRING , formatted as DATE-TIME STRING , formatted as DATE-TIME
TINYINT INTEGER INTEGER
UUID STRING STRING
VARCHAR STRING STRING

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.