Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
Property | Description |
AllowPreparedStatement | Prepare a query statement before its execution. |
AllowUserVariables | When set to True, user variables (prefixed by an $) can be used in SQL queries. |
ApplicationName | The application name connection string property expresses the HTTP User-Agent. |
AsyncQueryTimeout | The timeout for asynchronous requests issued by the provider to download large result sets. |
BatchMode | Allow specifying the batch mode. Default: Auto. |
CustomStage | The name of a custom stage to use during bulk write operations. |
ExternalStageAWSAccessKey | Your AWS account access key. Only used when defining a CustomStage for bulk write operations. |
ExternalStageAWSSecretKey | Your AWS account secret key. Only used when defining a CustomStage for bulk write operations. |
ExternalStageAzureSASToken | The string value of the Azure Blob shared access signature. |
IgnoreCase | Whether to ignore case in identifiers. Default: false. |
IncludeTableTypes | If set to true, the provider will report the types of individual tables and views. |
MaximumColumnSize | The maximum column size. |
MaxRows | Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses. |
MaxThreads | Specifies the number of concurrent requests. |
MergeDelete | A 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. |
MergeInsert | A boolean indicating whether INSERT statements should be converted to MERGE statements automatically. Only used when the INSERT contains a table's primary key field. |
MergeUpdate | A 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. |
Other | These hidden properties are used only in specific use cases. |
Pagesize | The maximum number of results to return per page from Snowflake. |
PseudoColumns | This property indicates whether or not to include pseudo columns as columns to the table. |
QueryPassthrough | This option passes the query to the Snowflake server as is. |
Readonly | You can use this property to enforce read-only access to Snowflake from the provider. |
ReplaceInvalidUTF8Chars | Specifies whether to repalce invalid UTF8 characters with a '?'. |
RetryOnS3Timeout | Whether or not to retry when network issues occur at during chunk downloading. |
RTK | The runtime key used for licensing. |
SessionIdleTimeout | The 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. |
SessionParameters | The session parameters for Snowflake. For example: SessionParameters='QUERY_TAG=MyTag;QUOTED_IDENTIFIERS_IGNORE_CASE=True;';. |
Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
UseAsyncQuery | This field sets whether async query is enabled. |
UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |