The table(s) must exist in Redshift and the user specified in Username must have insert permission. The secret access key for the S3 staging area If the S3 staging area is in a different AWS region (not recommended), specify it here (see AWS Regions and Endpoints). If the data will contain ', change the default value to a sequence of characters that will not appear in the data.Īn AWS IAM role with read write permission on the bucket (leave blank if using an access key) The character(s) used to quote (escape) field values in the delimited text files in which the adapter accumulates batched data. See Replicating Oracle data to Amazon Redshift for more information. With an input stream of a user-defined type, do not change the default. For example, ConversionParams: 'IGNOREHEADER=2, NULL AS='NULL', ROUNDEC'
