ConnectApi.QuerySqlInput

Represents the input to create an SQL query.

PropertyTypeDescriptionRequired or OptionalAvailable Version
adaptiveTimeoutIntegerAmount of time (in seconds) for the query engine to respond to the request. 0 will return the queryId, status, and metadata, but no data associated with the SQL. The maximum value is 15.Optional63.0
querySettingsMap<String, String>Settings to adjust the query execution behavior:
  • date_style—Order of Year, Month, and Day for parsing date strings, for example MDY and DMY.
  • lc_time—Locale for date literals using ISO language and country code, for example en_US and de_AT.
  • query_timeout—Execution limit in milliseconds before the query is terminated, for example 1800000ms.
Optional62.0
rowLimitLongMaximum number of rows to include in the response. Fewer rows may be returned.Optional62.0
sqlStringSQL expression.Required62.0
sqlParametersList<ConnectApi.QuerySqlParameterItem>Value and type information about the SQL parameters.Optional62.0

See Also