[en] PostgreSQL
[en] Connection Type | [en] ODBC (64-bit) |
[en] Type of Support | [en] Read & Write; In-Database |
[en] Validated On | [en] Database Version: 11.7, 14.1, and 15.3. [en] ODBC Client Version: 1.4.45.1001 |
[en] For more information about the Simba Athena ODBC driver, see the Simba ODBC documentation.
[en] Alteryx Tools used to Connect
[en] Standard Workflow Process
[en] Input Data Tool
[en] Link
[en] Output Data Tool
[en] Link
[en] In-Database Workflow Process
[en] Select Greenplum as the Data Source.
[en] Connect In-DB Tool
[en] Link
[en] Data Stream In Tool
[en] Link
[en] Supported Versions
[en] Maximum Columns In Table: 250 - 1600, depending on column types
[en] Maximum Column Name Length: 63 characters
[en] Maximum Row Size: 1.6 TB
[en] 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.
[en] The driver does not support certain available JSONb query operators (?,?|,?&). For more information, see the PostgreSQL documentation.
[en] 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.
[en] To configure the PosgreSQL Bulk connection for writing data, please see the Configure PosgreSQL Bulk Connection for Writing Data article.