PostgreSQL
| 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.
Additional Details
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.