Tutorial: Subscribe to Worldwide Event Attendance (Test Product) on AWS Data Exchange - AWS Data Exchange User Guide

Tutorial: Subscribe to Worldwide Event Attendance (Test Product) on AWS Data Exchange

Worldwide Event Attendance (Test Product) is a free product that helps subscribers understand how to subscribe to and interact with an AWS Data Exchange product containing Amazon Redshift data sets. You can use this product for testing purposes and to learn how to query, analyze, and build applications within minutes.

Worldwide Event Attendance (Test Product) contains an Amazon Redshift data set named Worldwide Event Data (Test Data) that is in the US East (N. Virginia) AWS Region.

Note

A subscription to this product might require Amazon Redshift cluster infrastructure, which could incur extra costs. To query the Amazon Redshift data, an Amazon Redshift cluster running on an RA3 instance is required.

You use the AWS Data Exchange console to find and subscribe to Worldwide Event Attendance (Test Product). Then, you can use either the Amazon Redshift console or SQL commands to query the datashare.

Subscribing to Worldwide Event Attendance (Test Product) on AWS Data Exchange

The following procedure shows how to browse the AWS Data Exchange catalog to find and subscribe to Worldwide Event Attendance (Test Product).

To find and subscribe to Worldwide Event Attendance (Test Product)

  1. Open and sign in to the AWS Data Exchange console.

  2. From the left navigation pane, under Discover data products, choose Browse catalog.

  3. From the search bar, enter Worldwide Event Attendance (Test Product) and press Enter.

  4. Choose the Worldwide Event Attendance (Test Product) to view its details page.

    1. (Optional) To view the data dictionary, scroll down to the product Overview section to see the data dictionary under Data dictionaries.

    2. (Optional) To download the data dictionary, choose the Data dictionary and samples tab, choose the option button next to Data dictionary, and then choose Download.

    3. (Optional) To preview the sample, choose the option button next to the sample name (Worldwide Event Attendance Sample.csv), and then choose Preview sample (CSV only).

    4. (Optional) To download the sample, choose the option button next to the sample name (Worldwide Event Attendance Sample.csv), and then choose Download.

      If you are previewing the sample, you can also choose Download in the sample preview dialog box.

  5. In the top right corner, choose Continue to subscribe.

  6. Choose your preferred price and duration combination, choose whether to enable auto-renewal for the subscription, and review the offer details, including the data subscription agreement.

    Note

    Worldwide Event Attendance (Test Product) doesn't require subscription verification, but some products do. For more information, see Subscription verification for subscribers.

  7. Review the pricing information, choose the pricing offer, and then choose Subscribe.

    Note

    Worldwide Event Attendance (Test Product) is a free product. If you subscribe to a paid product, you are prompted to confirm your decision to subscribe.

It can take a few minutes for your subscription to become active after you choose Subscribe.

Navigating away from this page prior to your subscription becoming active will not prevent the subscription from processing.

Querying Worldwide Event Attendance (Test Product) data on Amazon Redshift (console)

The following procedure shows how to set up and query the datashare using the Amazon Redshift console.

To query Worldwide Event Attendance (Test Product) data on Amazon Redshift (console)

  1. Open and sign in to the Amazon Redshift console.

  2. Choose Clusters, and choose your existing RA3 cluster.

  3. Choose the Datashares tab.

  4. Select the datashare you want to create the database from.

  5. Under Subscriptions to AWS Data Exchange datashares, choose Create database from datashare.

  6. In Create database from datashare, enter the Database name for your new database, and then choose Create.

  7. Choose the Marketplace icon on the navigation pane, and open the Query editor.

  8. Under Resources, select a database and a schema.

  9. Run the following SQL query.

    select * from database.schema.table

Querying Worldwide Event Attendance (Test Product) data on Amazon Redshift (SQL)

The following procedure shows how to set up and query the datashare using the SQL commands.

To query Worldwide Event Attendance (Test Product) data on Amazon Redshift (SQL)

  1. To find the datashare, run the following command.

    SHOW DATASHARES [ LIKE 'namepattern' ]

    This command lists all datashares, including the one from Worldwide Event Attendance (Test Product), in addition to the provider's account_id and namespace. For more information, see Show Datashares in the Amazon Redshift Database Developer Guide.

  2. Run the following command to create a database from the datashare.

    CREATE DATABASE database_name

    FROM DATASHARE datashare_name OF ACCOUNT account_id NAMESPACE namespace_guid

    For more information, see Create Database in the Amazon Redshift Database Developer Guide.

  3. Run the following SQL query.

    select * from database.schema.table