This topic describes how to add a Time Series Database (TSDB) data source to Quick BI.
Quick BI overview
Quick BI is a cloud computing service that supports big data analysis and data visualization. Quick BI is a lightweight, easy-to-use business intelligence (BI) tool. You can create data sources and datasets to perform ad hoc queries and analysis. Quick BI allows you to drag and drop components to visualize data. For example, you can create workbooks and dashboards. For more information about Quick BI, see What is Quick BI?
Use Quick BI to query and analyze data from a TSDB data source
Add a TSDB data source to Quick BI
You can add a TSDB data source to a group workspace in Quick BI. For more information, see Add a TSDB data source to Quick BI. Before you add a data source, take note of the following points:
A group workspace is available only for Quick BI Pro or Quick BI Enterprise Standard. Therefore, before you add a TSDB data source, make sure that you have purchased Quick BI Pro or Quick BI Enterprise Standard.
Before you add a TSDB data source to Quick BI, apply for a Transact-SQL (T-SQL) connection string. You can apply for a T-SQL connection string in the TSDB console. In the left-side navigation pane, click Instances. On the Instances page, find the instance that you want to manage and click Manage in the Actions column. In the Basic Information section on the instance details page, click Apply for T-SQL connection string.
When you add a TSDB data source to Quick BI, enter the AccessKey ID and AccessKey secret of the Alibaba Cloud account that you use to purchase the TSDB instance. On the AccessKey Management page, you can obtain the AccessKey ID and the AccessKey secret of your Alibaba Cloud account.
After you add a TSDB data source to Quick BI, you can create a dataset for data analysis.
Create a dataset for data analysis
After a TSDB data source is added, you only establish a data link between Quick BI and the TSDB instance. Before you can use Quick BI to query and analyze data, create a dataset.
A dataset is similar to a view in a relational database. A dataset in Quick BI is not used to store data. You can use an SQL statement to define a dataset rule.
After you select the TSDB data source that was added, enter a T-SQL statement that is compatible with TSDB. In the upper-right corner of the page, click Execute and view the execution result of the statement.
Save the execution result. Then, a dataset is created. After a dataset is created, you can modify the query statement that is used to define the dataset.
Time series come in two types: univariate time series and multivariate time series. A metric for a univariate time series represents a single time-dependent variable. A metric for a multivariate time series represents multiple time-dependent fields. When you query and analyze time series data, fields are measurable data, and tags and timestamps are dimension data. Therefore, we recommend that you create a dataset that contains measurable data and dimension data. Otherwise, subsequent operations for data analysis cannot be performed.
Query, analyze, and visualize data
After a dataset is created, you can create a dashboard and a workbook in Quick BI to visualize data. Then, you can create a BI portal as needed.
For more information about how to create a BI portal, see Quick BI documentation.