Amazon QuickSight - Amazon Timestream

Amazon QuickSight

You can use Amazon QuickSight to analyze and publish data dashboards that contain your Amazon Timestream data. This section describes how you can create a new QuickSight data source connection, modify permissions, create new datasets, and perfrom an analysis. This video tutorial describes how to work with Timestream and Quicksight.

Note

All datasets in QuickSight are read-only. You can’t make any changes to your actual data in Timestream by using QuickSight to remove the data source, dataset, or fields.

Accessing Amazon Timestream from QuickSight

Before you can proceed, Amazon QuickSight needs to be authorized to connect to Amazon Timestream. If connections are not enabled, you will receive an error when you try to connect. A QuickSight administrator can authorize connections to AWS resources. To authorize a connection from QuickSight to Timestream, follow the procedure at Using Other AWS Services: Scoping Down Access, choosing Amazon Timestream in step 5.

Create a new QuickSight data source connection for Timestream

  1. Ensure you have configured the appropriate permissions for Amazon QuickSight to access Amazon Timestream, as described in Accessing Amazon Timestream from QuickSight.

  2. Begin by creating a new dataset. Choose Datasets from the naviagtion pane, then choose New Dataset.

  3. Select the Timestream data source card.

  4. For Data source name, enter a name for your Timestream data source connection, for example US Timestream Data.

    Note

    Because you can create many datasets from a connection to Timestream, it's best to keep the name simple.

  5. Choose Validate connection to check that you can successfully connect to Timestream.

    Note

    Validate connection only validates that you can connect. However, it doesn’t validate a a specific table or query.

  6. Choose Create data source to proceed.

  7. For Database, choose Select... to view the list of available options. Choose the one you want to use.

  8. Choose Select to continue.

  9. Choose one of the following:

    • To import your data into QuickSight’s in-memory engine (called SPICE), choose Import to SPICE for quicker analytics.

    • To allow QuickSight to run a query against your data each time you refresh the dataset or use the analysis or dashboard, choose Directly query your data.

  10. Choose Edit/Preview and then Save to save your dataset and close it.

Edit permissions for the QuickSight data source connection for Timestream

The following procedure describes how to view, add, and revoke permissions for other QuickSight users so that they can access the same Timestream data source. The people need to be active users in QuickSight before you can add them.

Note

In QuickSight, data sources have two permissions levels: user and owner.

  • Choose user to allow read access.

  • Choose owner to allow that user to edit, share, or delete this QuickSight data source.

  1. Ensure you have configured the appropriate permissions for Amazon QuickSight to access Amazon Timestream, as described in Accessing Amazon Timestream from QuickSight.

  2. Choose Datasets at left, then scroll down to find the data source card for your Timestream connection. For example US Timestream Data.

  3. Choose the Timestream data source card.

  4. Choose Share data source. A list of current permissions displays.

  5. (Optional) To edit permissions, you can choose user or owner.

  6. (Optional) To revoke permissions, choose Revoke access. People you revoke can't create new datasets from this data source. However, their existing datasets will still have access to this data source.

  7. To add permissions, choose Invite users, then follow these steps to add a user:

    1. Add people to allow them to use the same data source.

    2. For each, choose the Permission that you want to apply.

  8. When you are finished, choose Close.

Create a new QuickSight dataset for Timestream

  1. Ensure you have configured the appropriate permissions for Amazon QuickSight to access Amazon Timestream, as described in Accessing Amazon Timestream from QuickSight.

  2. Choose Datasets at left, then scroll down to find the data source card for your Timestream connection. If you have many data sources, you can use the search bar at the top of the page to find it with a partial match on the name.

  3. Choose the Timestream data source card. Then choose Create data set.

  4. For Database, choose Select... to view the list of available options. Choose the database that you want to use.

  5. For Tables, choose the table that you want to use.

  6. Choose Edit/Preview.

  7. (Optional) To add more data, choose Add data at top right.

    1. Choose Switch data source, and choose a different data source.

    2. Follow the UI prompts to finish adding data.

    3. After adding new data to the same dataset, choose Configure this join (the two red dots). Set up a join for each additional table.

    4. If you want to add calculated fields, choose Add calculated field.

    5. To use Sagemaker, choose Augment with SageMaker. This option is only avaialble in QuickSight Enterprise edition.

    6. Uncheck any fields you want to omit.

    7. Update any datatypes you want to change.

  8. When you are done, choose Save to save and close the dataset.

Create a new analysis for Timestream

  1. Ensure you have configured the appropriate permissions for Amazon QuickSight to access Amazon Timestream, as described in Accessing Amazon Timestream from QuickSight.

  2. Choose Analyses at left.

  3. Choose one of the following:

    • To create a new analysis, choose New analysis at right.

    • To add the Timestream dataset to an existing analysis, open the analysis you want to edit. Choose the pencil icon near at top left, then Add data set.

  4. Start the first data visualization by choosing fields on the left.

  5. For more information, see Working with Analyses - Amazon QuickSight

Video Tutorial

This video explains how Quicksight works with Timestream.