Amazon Redshift Spectrum

Select the Redshift driver and select Configure.

Enter your ConnectionSettings and credentials.

In the AdditionalOptions area, select the Retrieve Entire Results Into Memory option.

Select OK to save the connection.

Select the Write to File or Database dropdown and select Other Databases > Amazon Redshift Bulk.

Select a Data Source Name (or select ODBC Admin to create one). See ODBC and OLEDB Database Connections.

(Optional) Enter a User Name and Password.

In the AmazonS3 section, enter or paste your AWS Access Key and AWS Secret Key to access the data for upload.

In the Secret Key Encryption dropdown, select an encryption option:

In the Endpoint dropdown, select Default to allow Amazon to determine the endpoint automatically based on the bucket you select. To specify an endpoint for private S3 deployments, or if you know a specific bucket region, you can alternately select an endpoint (S3 region), enter a custom endpoint, or select from one of ten previously-entered custom endpoints.

If the Bucket you select is not in the region of the endpoint you specify, the following error occurs: "The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint." Select Default to clear the error.

(Optional) Select Use Signature V4 for Authentication to use Signature Version 4 instead of the default Signature Version 2. This increases security, but connection speeds might be slower. This option is automatically enabled for regions requiring Signature Version 4.

Regions requiring Signature Version 4: Regions created after January 30, 2014 support only Signature Version 4. These regions require Signature Version 4 authentication:

Select a Server-SideEncryption method for uploading to an encrypted Amazon S3 bucket. For more information on Amazon S3 encryption methods, see the Amazon Simple Storage Service Developer Guide.

In Bucket Name, enter the name of the AWS bucket in which your data objects are stored.