Connect with Looker
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
You can configure SingleStore to work with Looker.
Supported version:
Looker |
7. |
Prerequisites
-
Access to Looker portal.
-
A SingleStore cluster in
Active
state.
Connect Looker to SingleStore
To connect Looker to SingleStore, perform the following steps:
-
Log in to the Looker portal.
-
On the Looker home page, under Database, select Admin > Connections.
-
On the Connections page, select Add Connection and enter the following details:
-
Name: The name of the connection.
-
Dialect: SingleStore 7+.
-
Host: The IP address or the hostname of your cluster.
-
Port (default is
3306
) -
Database: The name of the database.
-
Username:< user name for the database >
-
The SingleStore username and password.
-
-
Select Test these settings to test the connection settings.
Once you are successfully connected, select Add connection.
References
Last modified: April 30, 2024