Quick BI is a next-generation self-service business intelligence (BI) platform that is tailored for cloud users and enterprises. Quick BI provides a GUI and supports flexible and efficient multidimensional analysis. Quick BI helps you gain fine-grained data-driven insights into your business. You can connect to ApsaraDB ClickHouse over the Internet or a virtual private cloud (VPC), add an ApsaraDB ClickHouse data source to Quick BI, and build a BI system for your ApsaraDB for ClickHouse cluster. This topic describes how to add an ApsaraDB ClickHouse data source to Quick BI.
Prerequisites
- An ApsaraDB ClickHouse cluster is created. For more information, see Create an ApsaraDB for ClickHouse cluster.
- A username and a password of a database account are created. For more information, see Create an account.
- The CIDR blocks of Quick BI are added to the whitelist of ApsaraDB ClickHouse. For more information, see Configure a whitelist.
- If Quick BI is not deployed in the same VPC as the ApsaraDB ClickHouse cluster, you must apply for a public endpoint for the ApsaraDB ClickHouse cluster. For more information, see Apply for a public endpoint.
Limits
- Only workspace administrators and developers can add data sources.
- Only Quick BI Enterprise Standard and Quick BI Pro allow you to add ApsaraDB for ClickHouse data sources in group workspaces.
Procedure
What to do next
- You can add data tables in the database of the ApsaraDB for ClickHouse cluster or add user-defined SQL statements for ad hoc analysis to Quick BI. For more information, see Create a dataset.
- For more information about how to add visual charts and analyze data, see Create a standard dashboard and Overview.
- For more information about how to drill down and further analyze data, see Drilling, filter interactions, and hyperlinks.