You can use Looker to query and visualize data by means of Dremio.
Supported Authentication Methods
There are two methods of authenticating that you can choose from when you connect from Looker to Dremio:
- Use a username and password for your Dremio cluster.
- Use a personal access token (PAT) obtained from Dremio. To create a PAT, follow the steps in Creating a PAT
Creating a Connection
Log into Looker.
In the menu bar at the top of the page, select Admin, and then select Connections under Database.
Click the Add Connection button in the top-right corner of the page to open the Connection Settings page for creating a connection.
Specify a name for the connection.
In the Dialect field, select Dremio 11+.
In the Remote Host:Port fields, specify the hostname or IP address of your Dremio cluster, as well as the port to connect to. By default, the port number is 31010.
In the Database field, specify any value. Though Looker requires a value in this field, Dremio does not use the value.
In the Username and Password fields, specify your authentication credentials:
If you want to authenticate by using a Dremio username and a password, specify them in the Username and Password fields.
If you want to authenticate by using a personal access token, specify these values:
- In the Username field, specify your Dremio username.
- In the Password field, paste the personal access token.
If your Dremio cluster is configured to use TLS, ensure that the SSL check box is selected.
Click Test These Settings at the bottom of the page to check that the information that you specified is all valid.
Click Add Connection if the test of the connection is successful.
The new connection is listed on the Connections page.