SingleStore Managed Service

Connecting Looker to SingleStore DB

This guide discusses connecting Looker to SingleStore DB with the following configuration:

  • SingleStore DB running on premises

  • SingleStore Managed Service

The steps to connect are:

  1. Open the Looker portal.

  2. Provide user name and password to Log in.

  3. On the Looker home page, select Admin > Connections (under Database).

  4. On the Connections page, click Add Connection and provide the following details:

    • Name: < Name of the connection >

    • Dialect: MemSQL

    • Host: < IP address of the machine running SingleStore DB >

    • Port: 3306

    • Database: < Name of the database >

    • Username: < user name for the database >

    • Password: < password for the database >

      Note: When connecting with SingleStore Managed Service, provide the client endpoint URL from the cloud connection in place of the IP address.

  5. Click Test these settings and once successfully connected, click Add connection.

After this you can create projects to explore the Looker functions and features. For configuring additional SingleStore DB database properties go here.

Now you can start to work on your LookerML project following this link: https://docs.looker.com/data-modeling/getting-started/create-projects