Hex
Hex supports querying and visualizing both internal data and external data in StarRocks.
Add a data connection in Hex. Note that you must select MySQL as the connection type.
The parameters that you need to configure are described as follows:
- Name: the name of the data connection.
- Host & port: the FE host IP address and FE query port of your StarRocks cluster. An example query port is
9030
. - Database: the data source that you want to access in your StarRocks cluster. The value of this parameter is in the
<catalog_name>.<database_name>
format.catalog_name
: the name of the target catalog in your StarRocks cluster. Both internal and external catalogs are supported.database_name
: the name of the target database in your StarRocks cluster. Both internal and external databases are supported.
- Type: the authentication method that you want to use. Select Password.
- 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.