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

Prepare a query statement before its execution.

bool

false

If the AllowPreparedStatement property is set to false, statements are parsed each time they are executed. Setting this property to false can be useful if you are executing many different queries only once.

If you are executing the same query repeatedly, you will generally see better performance by leaving this property at the default, true. Preparing the query avoids recompiling the same query over and over. However, prepared statements also require the adapter to keep the connection active and open while the statement is prepared.

The application name connection string property expresses the HTTP User-Agent.

string

""

AsyncQueryTimeout

The timeout for asynchronous requests issued by the provider to download large result sets.

int

300

If the AsyncQueryTimeout property is set to 0, asynchronous operations will not time out; instead, they will run until they complete successfully or encounter an error condition. This property is distinct from Timeout which applies to individual HTTP operations while AsyncQueryTimeout applies to execution time of the operation as a whole.

If AsyncQueryTimeout expires and the asynchronous request has not finished being processed, the adapter raises an error condition.

The name of a custom stage to use during bulk write operations.

string

""

The name of a custom stage to use during bulk write operations. This can be an internal or external stage. If the stage is external, the AWS or Azure credentials must be provided as well via the ExternalStageAWSAccessKey/ExternalStageAWSSecretKey or ExternalStageAzureAccessKey properties.

When this is left unspecified, the adapter will generate a temporay stage automatically during the upload process and delete it after the upload is complete.

Whether to support Apache Arrow.

bool

true

Whether to support Apache Arrow.

Your AWS account access key. Only used when defining a CustomStage for bulk write operations.

string

""

Your AWS account access key. This value is accessible from your AWS security credentials page:

Sign into the AWS Management console with the credentials for your root account.

Select your account name or number and select My Security Credentials in the menu that is displayed.

Click Continue to Security Credentials and expand the Access Keys section to manage or create root account access keys.

Your AWS account secret key. Only used when defining a CustomStage for bulk write operations.

string

""

Your AWS account secret key. This value is accessible from your AWS security credentials page:

The string value of the Azure Blob shared access signature.

string

""

The string value of the Azure Blob shared access signature.

You can go to "Shared access signature" in "Settings" section for your Azure Blob container through Azure Portal, then click "Generate SAS token and URL" and copy the value from "Blob SAS token" textbox. Please be cautionus to select the proper permission (Create, Write, Delete) in "Permissions" dropdown list and validity of Start and Expiry time before you generate SAS token.

Whether to ignore case in identifiers. Default: false.

bool

false

A session parameter that specifies whether Snowflake will treat identifiers as case sensitive. Default: false(case is sensitive).

If set to true, the provider will report the types of individual tables and views.

bool

false

If set to true, the adapter will report the types of individual tables and views.

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.

int

-1

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.

Specifies the number of concurrent requests.

string

"5"

This property allows you to issue multiple requests simultaneously, thereby improving performance.

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.

bool

false

A boolean indicating whether DELETE statements should be converted to MERGE statements automatically to allow for upsert functionality. This property is primarily intended for use with tools where you have no direct control over the queries being executed. Otherwise, as long as Query Passthrough is True, you could execute the MERGE command directly.

When this property is False, DELETE bulk statements won't executed against the server. When it is set to True and the DELETE query contains the primary key field, the Snowflake will send a MERGE query that will execute an DELETE if match is found in Snowflake. For example this query:

Will be sent to Snowflake as the following MERGE request:

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.

bool

false

A boolean indicating whether INSERT statements should be converted to MERGE statements automatically to allow for upsert functionality. This property is primarily intended for use with tools where you have no direct control over the queries being executed. Otherwise, as long as Query Passthrough is True, you could execute the MERGE command directly.

When this property is False, INSERT statements are executed directly against the server. When it is set to True and the INSERT query contains the primary key field, the Snowflake will send a MERGE query that will execute an INSERT if no match is found in Snowflake or an UPDATE if it is. For example this query:

Will be sent to Snowflake as the following MERGE request:

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.

bool

false

A boolean indicating whether UPDATE statements should be converted to MERGE statements automatically to allow for upsert functionality. This property is primarily intended for use with tools where you have no direct control over the queries being executed. Otherwise, as long as Query Passthrough is True, you could execute the MERGE command directly.

When this property is False, UPDATE statements are executed directly against the server. When it is set to True and the UPDATE query contains the primary key field, the Snowflake will send a MERGE query that will execute an INSERT if no match is found in Snowflake or an UPDATE if it is. For example this query:

Will be sent to Snowflake as the following MERGE request:

These hidden properties are used only in specific use cases.

string

""

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

The maximum number of results to return per page from Snowflake.

int

5000

The Pagesize property affects the maximum number of results to return per page from Snowflake. Setting a higher value may result in better performance at the cost of additional memory allocated per page consumed.

You can use this property to enforce read-only access to Snowflake from the provider.

bool

false

If this property is set to true, the adapter will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.

Specifies whether to repalce invalid UTF8 characters with a '?'.

bool

false

Specifies whether to repalce invalid UTF8 characters with a '?'

Whether or not to retry when network issues occur at during chunk downloading.

bool

false

Typically if a network issue such as a timeout occurs during chunk downloading of data, the Snowflake Adapter will throw an exception. Set this property to true to cause the Snowflake Adapter to attempt retrying the request before failing.

The session parameters for Snowflake. For example: SessionParameters='QUERY_TAG=MyTag;QUOTED_IDENTIFIERS_IGNORE_CASE=True;';.

string

""

The session parameters for Snowflake. For example: SessionParameters='QUERY_TAG=MyTag;QUOTED_IDENTIFIERS_IGNORE_CASE=True;';

The value in seconds until the timeout error is thrown, canceling the operation.

int

120

If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.

If Timeout expires and the operation is not yet complete, the adapter throws an exception.

This field sets whether async query is enabled.

bool

false

This field sets whether async query is enabled.