If you want Amazon Redshift to encrypt data while uploading the

.csv

files to Amazon Redshift, you must enable server-side encryption. To enable server-side encryption, select

S3 Server Side Encryption

in the data object operation advanced properties.

For a server-side encryption, you can also use AWS KMS-managed customer master key to encrypt data when you run a mapping in the native environment, on the Spark engine, or on the Databricks Spark engine. Perform the following steps to enable server-side encryption with AWS KMS-managed customer master key:

Provide the customer master key ID when you create an Amazon Redshift connection.
Select
S3 Server Side Encryption
as the encryption type in the advanced properties of the data object operation.