Excel Add-In for Greenplum

Build 25.0.9539

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
AllowPreparedStatementPrepare a query statement before its execution.
FetchResultSetMetadataThis field sets whether the provider retrieves metadata pertaining to the schema and table name for resultset columns returned by the server.
MaxRowsSpecifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.
OtherSpecifies advanced connection properties for specialized scenarios. Use this property only under the guidance of our Support team to address specific issues.
QueryPassthroughThis option passes the query to the Greenplum server as is.
ReadonlyToggles read-only access to Greenplum from the provider.
SupportUnboundedColumnsWhen this property is set, the provider reports Int32.MaxValue as the size of the columns of data type 'bytea' and 'text'.
TimeoutSpecifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539