Time-series databases are designed to efficiently collect, store, and query time-stamped data. Timescale is a popular time-series database built with full SQL compatibility, providing robust SQL capabilities and the scalability required for time-series data. Further, Timescale can have up to 1,000x faster queries and 90%+ data compression. Timescale is the perfect database for time-series and event data. On the other hand, Explo is a dynamic data visualization tool that allows developers to create interactive dashboards from their Timescale instance without writing a single line of code. In this blog post, we'll explore the process of integrating Explo with Timescale to create powerful, real-time data visualizations.
Before diving into the integration process, let's understand why we're doing this. Combining Timescale's robustness and scalability with Explo's user-friendly dashboarding capabilities can result in numerous advantages:
Steps to Integrate Explo with Timescale
Before integrating, you need to have both Timescale and Explo installed and set up. To sign up for an account with Timescale's cloud offering, you may go here. To sign up for an Explo account, go here.
To get credentials from Timescale, simply go through the process of setting up a Service, click 'Store your service pasword now' at the end of the process, and collect your credentials from the downloaded .sql file.
Once both platforms are set up, you can establish a connection from Timescale to Explo. In the Explo dashboard, go to the 'Data' tab and choose 'Connect Datasource'. Choose 'Timescale' as your database, fill in your Timescale credentials and establish the connection.
Once your data is imported, you can start creating dashboards. Navigate to the 'Dashboards' tab and click 'Create Dashboard'.
In the dashboard, write SQL to access your data. Click 'Save and Run' to see a sample of your data.
Visualize your data via a chart in Explo. Drag on a chart, select the dataset to create a visualization from, define the x-axis and y-axis for the chart, then watch as you created your first visual from raw warehouse data!
Integrating Timescale with Explo enables real-time data visualization of your time-series data. This combination unlocks tremendous potential, allowing for better data analysis and insights, and making complex time-series data more digestible for all members of your team. Once set up, the maintenance of this integration is minimal, making it an effective and efficient choice for your data analysis needs.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
Unordered list
Bold text
Emphasis
Superscript
Subscript
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
Unordered list
Bold text
Emphasis
Superscript
Subscript
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
Unordered list
Bold text
Emphasis
Superscript
Subscript