Looker

Configuration

This data destination connector pushes data to your Looker instance where it creates a new LookML project. The column names are changed so that Looker can automatically understand data relations. The connector currently uses Snowflake as its backend.

Configuration

To connect Keboola to your Looker account, you need API credentials from Looker administration. The exact required steps are described in the Looker documentation. You need Client ID and Client secret to authenticate Keboola with Looker.

Create a new Looker data destination connector configuration in your project.

Continue by setting up a Snowflake workspace to use with Looker. You can either supply your own or use a Keboola generated workspace.

When your workspace is set up and tested, go back to the configuration. The next step is to set up your Looker credentials.

Fill in the client ID and the client secret you obtained from Looker.

Now the preparation phase is done and it’s time to set up the data you want to make available to your Looker project. Add tables to the configuration as needed. For further information, refer to the Snowflake data destination documentation.

Each table you add can have relations set up. For that the dependent table needs to have the primary key set up.

When you click “Set Foreign key”, you can select to which table’s primary key should the foreign key point to.

The column is renamed upon saving (this is required for Looker to understand the relation automatically) and the FK badge is shown next to it.

When you run the configuration, you’ll see the connection name in the log.

In Looker, when creating a new LookML project, you select the connection name from the configuration log.

You’re done. The LookML project with automatically created relations is prepared for you.