This writer 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 writer currently uses Snowflake as its backend.
To connect Keboola Connection to your Looker account, you need API credentials from Looker administration.
The exact required steps are described in the Looker documentation.
Client ID and
Client secret to authenticate Keboola Connection with Looker.
Create a new Looker writer 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 Connection 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 writer 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.