Creating a dataset using Amazon S3 files - Amazon QuickSight

Creating a dataset using Amazon S3 files

To create a dataset using one or more text files (.csv, .tsv, .clf, or .elf) from Amazon S3, create a manifest for Amazon QuickSight. Amazon QuickSight uses this manifest to identify the files that you want to use and to the upload settings needed to import them. When you create a dataset using Amazon S3, the file data is automatically imported into SPICE.

You must grant Amazon QuickSight access to any Amazon S3 buckets that you want to read files from. For information about granting Amazon QuickSight access to AWS resources, see Accessing data sources.

To create an Amazon S3 dataset
  1. Check Data source quotas to make sure that your target file set doesn't exceed data source quotas.

  2. Create a manifest file to identify the text files that you want to import, using one of the formats specified in Supported formats for Amazon S3 manifest files.

  3. Save the manifest file to a local directory, or upload it into Amazon S3.

  4. On the Amazon QuickSight start page, choose Datasets.

  5. On the Datasets page, choose New dataset.

  6. In the FROM NEW DATA SOURCES section of the Create a Data Set page, choose the Amazon S3 icon.

  7. For Data source name, enter a description of the data source. This name should be something that helps you distinguish this data source from others.

  8. For Upload a manifest file, do one of the following:

    • To use a local manifest file, choose Upload, and then choose Upload a JSON manifest file. For Open, choose a file, and then choose Open.

    • To use a manifest file from Amazon S3, choose URL, and enter the URL for the manifest file. To find the URL of a pre-existing manifest file in the Amazon S3 console, navigate to the appropriate file and choose it. A properties panel displays, including the link URL. You can copy the URL and paste it into Amazon QuickSight.

  9. Choose Connect.

  10. To make sure that the connection is complete, choose Edit/Preview data. Otherwise, choose Visualize to create an analysis using the data as-is.

    If you choose Edit/Preview data, you can specify a dataset name as part of preparing the data. Otherwise, the dataset name matches the name of the manifest file.

    To learn more about data preparation, see Preparing data in Amazon QuickSight.