Excel Add-In for Presto

Build 25.0.9434

Miscellaneous

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


PropertyDescription
SessionPropertiesSession properties to set for the system and for catalogs, specified as a list of key-value pairs and split with the comma. For example, abc=xyz,example.foo=bar sets the system property abc to the value xyz and the foo property for catalog example to the value bar.
MaxRowsSpecifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.
OtherSpecifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details.
QueryPassthroughThis option passes the query to the Presto server as is.
ReadonlyToggles read-only access to Presto from the provider.
SortColumnsIndicates whether to sort columns alphabetically.
TimeoutSpecifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error.
UserDefinedViewsSpecifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434