Guanyuan BI is a modern BI based on digital business operations with a core concept of making business easy to use. It also aims at hybrid data analysis needs, composed of a suite of products in one modern BI station.

Version Requirements #

1. Log in to Guanyuan BI Saas service. https://www.guandata.com/abi
2. Use the built-in ClickHouse data source.

Connect to ByteHouse #

1. Add data sources in Guanyuan BI, select the ClickHouse connector.

2. Fill in connection and verification information.
   • Connection method: Select JDBC URL
   • Username: Default is bytehouse
   • Password: API key
   • Database name: Fill in the connected database name
   • JDBC URL: Format is jdbc:clickhouse://<Host>:8123/<Database name>?ssl=true&max_execution_time=600&socket_timeout=600000

The fields mentioned above, Host and API key, can be found in 获取连接信息Obtaining relevant information.

Showcase effects #

Create dataset

Create dashboard