Amazon QuickSight Objects
Amazon QuickSight Connector targets represent delimited file data objects that are written to Amazon S3 buckets as delimited files.
Amazon QuickSight Connector uses Amazon S3 object formats when writing data to Amazon S3.
Amazon S3 Object Format
Amazon S3 objects are delimited files. All fields in a delimited file are of string data type with a data format that you cannot change and with a defined precision of 256. Data in Amazon S3 delimited files is written in String 256 format.
An Amazon S3 delimited file uses the following data format:
- •The delimiter is a comma.
- •The qualifier is a double-quote.
- •The escape character is a backslash.
When you write data to an Amazon S3 file, the application might display an exception when you select incorrect Formatting Options. You must select valid Formatting Options and proceed with the task.
When you write data to an Amazon S3 file, if there is a single or double quote in the source data, an extra quote is added to the target.
You cannot specify space, semi colon, and comma as delimiters in the Other option under Formatting Options.