- Trifacta® Enterprise Edition
- Trifacta Professional Edition
- Trifacta Premium
Greenplum uses a high-performance architecture to distribute the load of multi-terabyte data warehouses and can leverage a system's resources in parallel to process a query. For more information, see https://greenplum.org/.
Limitations and Requirements
NOTE: During normal selection or import of an entire table, you may encounter an error indicating a problem with a specific column. Since some tables require filtering based on a particular column, data from them can only be ingested using custom SQL statements. In this case, the problematic column can be used as a filter in the WHERE clause of a custom SQL statement to ingest the table.
- For more information, please consult the CData driver documentation for the specific table.
- For more information on using custom SQL, see Create Dataset with SQL.
Supports Basic (username/password) authentication.
via Trifacta application
When you create the connection, please review the following properties and specify them accordingly:
|Host||Name of the host.|
The port number of the Greenplum server. The default port value is 5432.
The name of the Greenplum database.
|Connect String Options|
The following default value sets the connection timeout in seconds:
Setting this value to
The Greenplum user account used to authenticate.
|Password||The password used to authenticate the user.|
For more information, see the driver documentation http://cdn.cdata.com/help/SGF/jdbc/Connection.htm.
Depending on your product edition, you can create connections of this type. Key information:
For more information, seeTrifacta SaaS API Reference docs: Premium | Standard
Data Type Conversions
For more information, see the driver documentation http://cdn.cdata.com/help/SGF/jdbc/default.htm .
This page has no comments.