|Type of Support:||Read & Write; In-Database|
|Validated On:||Database version 9.4
ODBC client version 09.06.0310
|Connection Type:||ODBC (32- and 64-bit)|
|Driver Details:||The ODBC driver can be downloaded from PostgreSQL.
In-Database processing requires 64-bit database drivers.
Alteryx tools used to connect
- Input Data Tool and Output Data Tool (Standard workflow processing)
- Connect In-DB Tool and Data Stream In Tool (In-database workflow processing). Select Greenplum as the Data Source.
Maximum Columns In Table: 250 - 1600, depending on column types
Maximum Column Name Length: 63 characters
Maximum Row Size: 1.6 TB
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.
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.