Querybook
Querybook supports querying and visualizing both internal data and external data in StarRocks.
Prerequisitesβ
Make sure that you have finished the following preparations:
-
Clone and download the Querybook repository.
git clone git@github.com:pinterest/querybook.git
cd querybook -
Create a file named
local.txt
under therequirements
folder in the project's root directory.touch requirements/local.txt
-
Add the required packages.
echo -e "starrocks\nmysqlclient" > requirements/local.txt
-
Start the container.
make
Integrationβ
Visit the following URL and add a new query engine:
https://localhost:10001/admin/query_engine/
Take note of the following points:
-
For Language, select Starrocks.
-
For Executor, select sqlalchemy.
-
For Connection_string, enter a URI in the StarRocks SQLAlchemy URI format as below:
starrocks://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>
The parameters in the URI are described as follows:
User
: the username that is used to log in to your StarRocks cluster, for example,admin
.Password
: the password that is used to log in to your StarRocks cluster.Host
: the FE host IP address of your StarRocks cluster.Port
: the FE query port of your StarRocks cluster, for example,9030
.Catalog
: the target catalog in your StarRocks cluster. Both internal and external catalogs are supported.Database
: the target database in your StarRocks cluster. Both internal and external databases are supported.