Connect with Looker

You can configure SingleStore to work with Looker. For related information, see Looker Instructions. To create a new LookML project, see Creating and Editing Projects.

Supported version:

Looker

7.6.29 and later

Prerequisites

  • Access to Looker portal.

  • A SingleStore cluster in Active state.

Connect Looker to SingleStore

To connect Looker to SingleStore, perform the following steps:

  1. Log in to the Looker portal.

  2. On the Looker home page, under Database, select Admin > Connections.

  3. 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.

  4. Select Test these settings to test the connection settings. Once you are successfully connected, select Add connection.

Last modified: February 6, 2023

Was this article helpful?