Search

Welcome to Datagrid
Welcome to Datagrid
AWS Timestream

AWS Timestream

AWS Timestream is a fast, scalable, fully managed time-series database service for IoT and operational applications that makes it easy to store and analyze trillions of events per day at 1/10th the cost of relational databases. By connecting AWS Timestream to Datagrid, you can seamlessly integrate your time-series data with other business-critical information, enabling enhanced reporting, analysis, and decision-making.

1. How-to

1. Prerequisites

To configure the AWS Timestream connector, follow these steps:

  • An active AWS account with the necessary permissions to access Timestream.
  • IAM role with permissions to read from Timestream.
  • AWS credentials configured in Datagrid.
  • Select the data you want to import into Datagrid

2. Connect

Creating a dataset from the AWS Timestream connector involves selecting the specific data you want to import:

  1. Connect AWS Timestream App: a. Click on the "+ Create” Button on the top left of the screen. b. Select the "Connect Apps" item. c. Search for the AWS Timestream connector from the list. d. Login with your AWS account. AWS may prompt you to authorize Datagrid's access to your data. Grant the necessary permissions to proceed. e. Click on the “Next” button.
  2. Pick your Data: a. Pick the AWS Timestream data you want to include in your dataset (e.g., Databases, Tables, Measures). b. Click on the “Start First Import” Button to start syncing your AWS Timestream dataset.

3. Set Up a Schedule:

Scheduling regular data pulls ensures your Datagrid datasets remain up-to-date with the latest information from AWS Timestream:

  1. Navigate to AWS Timestream Dataset: a. Go to the left side panel and locate and click on the AWS Timestream dataset you created.
  2. Schedule Settings: a. Click on the “...” on the top right of the dataset. b. Click on “Edit Pipeline” to edit your connector's name. c. Click the “Schedule” button on the right, beside the “Import Configuration” button.
  3. Configure Schedule: a. Set the desired frequency for data pulls (e.g., daily, weekly, monthly). b. Specify the time of day for the data pull to occur. c. Specify downtime if needed – when the sync should not happen. d. Click the “Update” button to update the new configuration.

4. Data Access

  • Object
    • Database
    • Table
    • Measure
    • Dimension
    • Record

5. Use Cases

  • IoT Data Analysis: Analyze time-series data from IoT devices stored in Timestream to identify trends, detect anomalies, and optimize device performance.
  • DevOps Monitoring: Collect and analyze operational metrics from your applications and infrastructure in Timestream to monitor health, identify performance bottlenecks, and improve availability.
  • Real-time Analytics: Build real-time dashboards and reports in Datagrid using Timestream data to gain insights into key business metrics and make data-driven decisions.
  • Security Analytics: Analyze security logs and events stored in Timestream to detect threats, investigate incidents, and improve your security posture.

6. FAQ

Q: What permissions are required to connect AWS Timestream to Datagrid? A: You need an IAM role with permissions to read from Timestream.

Q: How often can I schedule data pulls from AWS Timestream? A: You can schedule data pulls daily, weekly, or monthly.

Q: What type of data can I import from AWS Timestream? A: You can import databases, tables, measures and dimensions.

7. Support & Additional Resources