JDBC Driver for Snowflake

Build 23.0.8839

Miscellaneous

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


PropertyDescription
AllowPreparedStatementPrepare a query statement before its execution.
AllowUserVariablesWhen set to True, user variables (prefixed by an $) can be used in SQL queries.
ApplicationNameThe application name connection string property expresses the HTTP User-Agent.
AsyncQueryTimeoutThe timeout for asynchronous requests issued by the provider to download large result sets.
BatchModeAllow specifying the batch mode. Default: Auto.
BatchSizeThe maximum size of each batch operation to submit.
ConnectionLifeTimeThe maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.
ConnectOnOpenThis property specifies whether to connect to the Snowflake when the connection is opened.
CustomStageThe name of a custom stage to use during bulk write operations.
ExternalStageAWSAccessKeyYour AWS account access key. Only used when defining a CustomStage for bulk write operations.
ExternalStageAWSSecretKeyYour AWS account secret key. Only used when defining a CustomStage for bulk write operations.
ExternalStageAzureSASTokenThe string value of the Azure Blob shared access signature.
IgnoreCaseWhether to ignore case in identifiers. Default: false.
IncludeTableTypesIf set to true, the provider will report the types of individual tables and views.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
MaxThreadsSpecifies the number of concurrent requests.
MergeDeleteA boolean indicating whether batch DELETE statements should be converted to MERGE statements automatically. Only used when the DELETE statement's where clause contains a table's primary key field only and they are combined with AND logical operator.
MergeInsertA boolean indicating whether INSERT statements should be converted to MERGE statements automatically. Only used when the INSERT contains a table's primary key field.
MergeUpdateA boolean indicating whether batch UPDATE statements should be converted to MERGE statements automatically. Only used when the UPDATE statement's where clause contains a table's primary key field only and they are combined with AND logical operator.
OtherThese hidden properties are used only in specific use cases.
PagesizeThe maximum number of results to return per page from Snowflake.
PoolIdleTimeoutThe allowed idle time for a connection before it is closed.
PoolMaxSizeThe maximum connections in the pool.
PoolMinSizeThe minimum number of connections in the pool.
PoolWaitTimeThe max seconds to wait for an available connection.
PseudoColumnsThis property indicates whether or not to include pseudo columns as columns to the table.
QueryPassthroughThis option passes the query to the Snowflake server as is.
ReadonlyYou can use this property to enforce read-only access to Snowflake from the provider.
ReplaceInvalidUTF8CharsSpecifies whether to repalce invalid UTF8 characters with a '?'.
RetryOnS3TimeoutWhether or not to retry when network issues occur at during chunk downloading.
RTKThe runtime key used for licensing.
SessionIdleTimeoutThe timeout minutes for Session, the values comes from Snowflake's session policy, which indicate the session policy parameter SESSION_IDLE_TIMEOUT_MINS. The default value is 240 minutes.
SessionParametersThe session parameters for Snowflake. For example: SessionParameters='QUERY_TAG=MyTag;QUOTED_IDENTIFIERS_IGNORE_CASE=True;';.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseAsyncQueryThis field sets whether async query is enabled.
UseConnectionPoolingThis property enables connection pooling.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839