ODBC (32- and 64-bit)
|Driver Configuration Requirements|
The ODBC driver can be downloaded from PostgreSQL.
|Type of Support||
Read & Write; In-Database
Database version 9.4
Alteryx tools used to connect
Standard workflow processing
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.