PostgreSQL

Version:
2019.3
Last modified: September 26, 2019
Connection Type

ODBC (32- and 64-bit)

Driver Configuration Requirements

https://www.postgresql.org/ftp/odbc/

Driver Details

The ODBC driver can be downloaded from PostgreSQL.
In-Database processing requires 64-bit database drivers.

Type of Support

Read & Write; In-Database

Validated On

Database version 9.4
ODBC client version 09.06.0310

Alteryx tools used to connect

Standard workflow processing

In-database workflow processing

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

Limitations

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: 9.03.04)

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.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.