PostgreSQL

Version:
2021.3
Last modified: August 11, 2021
Connection Type

ODBC (64-bit)

Type of Support

Read & Write; In-Database

Validated On

Database Version: 11.7
ODBC Client Version: 1.04.32.1000

For more information about the Simba PostgreSQL ODBC driver, see the Installation and Configuration Guide on Simba portal.

Alteryx Tools used to Connect

Standard Workflow Process

Link
Input Data Tool Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

In-Database Workflow Process

Select Greenplum as the Data Source.

Link
Blue icon with database being plugged in.

Connect In-DB Tool

Link
Blue icon with a stream-like object flowing into a database.

Data Stream In Tool

Supported Versions

Database Version: 9.4

Maximum Columns In Table: 250 - 1600, depending on column types

Maximum Column Name Length: 63 characters

Maximum Row Size: 1.6 TB

ODBC Client Version 09.06.0310

You can use either the ANSI 32-bit driver or the Unicode® ODBC driver. If using the ODBC connection for spatial data, use the Unicode® ODBC driver.

The driver does not support certain available JSONb query operators (?,?|,?&). For more information, see the PostgreSQL documentation.

In-Database

Due to PostgreSQL database limitations, only two tables can be combined with the Union In-DB Tool that contain completely different column names. Three or more tables will produce an error.

To configure the PosgreSQL Bulk connection for writing data, please see the Configure PosgreSQL Bulk Connection for Writing Data article.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.