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. |
FetchResultSetMetadata | This field sets whether the provider is getting detailed information about resultset columns from the server. |
IncludeTableTypes | If set to true, the provider will query for the types of individual tables and views. |
InsertMode | Specifies what method to use when inserting bulk data. By default DML mode is used. |
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. |
Other | These hidden properties are used only in specific use cases. |
Readonly | You can use this property to enforce read-only access to Amazon Redshift from the provider. |
RedshiftToS3RoleARN | The Amazon Resource Name of the role to use when authenticating S3 with IAM role by the COPY command for the bulk inserts. See InsertMode . |
S3Bucket | Specifies the name of AWS S3 bucket to upload bulk data for staging. |
S3BucketFolder | Specifies the name of the folder in AWS S3 bucket to upload bulk data for staging. By default bulk data are staged in the root folder. |
StripOutNulls | When set the null characters are stripped out from character values in bulk operations. |
Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
TimeZone | Set time zone for the current session. |