Supported GreenPlum Server Versions

5.3.0, 5.13.0

Encoding Support

Automatic encoding conversion

Connection Preview Support

Supports regular tables, does not support views or other special tables.

SQL Query Dataset Support for SQL

Only supports SELECT statements, supports all SELECT-related features supported by the connected GreenPlum server. Users need to ensure the syntax complies with GreenPlum standards.

GreenPlum Server Authentication Method Support

Supports username and password methods, does not support SSL authentication methods.

Unsupported Field Types

The following types of columns in GreenPlum tables cannot be processed correctly. If other fields of this table are needed, you can input a SELECT statement in the SQL query, excluding this field.

• interval
• point
• line
• lseg
• box
• path
• polygon
• circle
• macaddr
• bit varying
• tsquery
• tsvector
• xml
• json
• Arrays
• Composite Types
• Range Types