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. |
AsyncQueryTimeout | The timeout for asynchronous requests issued by the provider to download large result sets. |
CustomStage | The name of a custom stage to use during bulk write operations. |
EnableArrow | Whether to support Apache Arrow. |
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. |
MaxRows | Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time. |
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. |
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. |
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. |