Collecting and analyzing data with data feeds
AWS Marketplace provides data feeds as a mechanism to send structured, up-to-date product and customer information from AWS Marketplace systems to seller Amazon S3 buckets for ETL (extract, transform, and load) between seller-owned business intelligence tools. When data is available in your Amazon S3 bucket, you can use data feeds in the following ways:
-
Download the .CSV files from the Amazon S3 bucket you created in Accessing data feeds so that you can view the data in a spreadsheet.
-
Use ETL (extract, transform, and load), SQL query, business analytics tools to collect and analyze the data.
You can use AWS services to collect and analyze data, or any third-party tool that can perform analysis of .CSV-based datasets.
For more information about data feeds to collect and analyze data, see the following example.
Example: Use AWS services to collect and analyze data
The following procedure assumes that you've already configured your environment to receive data feeds to an Amazon S3 bucket and that the bucket contains data feeds.
To collect and analyze data from data feeds
-
From the AWS Glue console
, create a crawler to connect to the Amazon S3 bucket that stores the data feeds, extract the data you want, and create metadata tables in the AWS Glue Data Catalog. For more information about AWS Glue, see the AWS Glue Developer Guide.
-
From the Athena console
, run SQL queries on the data in the AWS Glue Data Catalog. For more information about Athena see the Amazon Athena User Guide.
-
From the Amazon QuickSight console
, create an analysis and then create a visual of the data. For more information about Amazon QuickSight, see the Amazon QuickSight User Guide.
For a detailed example of one way to use AWS services to collect and analyze data in
data feeds, see Using Seller Data Feed Delivery Service, Amazon Athena, and Amazon QuickSight to create seller
reports
