FireDAC Components for Snowflake

Build 21.0.7958

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.
ApplicationNameThe application name connection string property expresses the client application's name.
AsyncQueryTimeoutThe timeout for asynchronous requests issued by the provider to download large result sets.
CustomStageThe name of a custom stage to use during bulk write operations.
EnableArrowWhether to support Apache Arrow.
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.
ExternalStageAzureAccessKeyThe storage key associated with your Azure Blob storage account. Only used when defining a CustomStage for bulk write operations.
IgnoreCaseWhether to ignore case in identifiers. Default: false.
IncludeTableTypesIf set to true, the provider will report the types of individual tables and views.
MaximumColumnSizeThe maximum column size.
MaxRowsLimits 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.
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.
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.
SessionParametersThe session parameters for Snowflake. For example: SessionParameters='QUERY_TAG=MyTag;QUOTED_IDENTIFIERS_IGNORE_CASE=True;';.
SupportEnhancedSQLThis property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseAsyncQueryThis field sets whether async query is enabled.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7958