This writer pushes data to your Looker instance. It currently uses Snowflake as backend. In broad terms it works by creating a Connection in Looker which a new LookML project can be created. It changes the column names in a way that allows Looker to understand data relations automatically when the project is created.
To connect Keboola to your Looker account you need API credentials. You can obtain them in Looker administration. Exact steps required are described in Looker docs. You will need
Client ID and
Client secret to authenticate Keboola with Looker.
Create 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 Keboola generated workspace.
When your workspace is set up and tested, go back to the configuration. Next step is to set up your Looker credentials.
Fill in the Client ID and 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 about tables and columns UI refer to Snowflake writer documentation
Each table you add can have relations set up. For that the dependent table needs to have 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.
When saved the column is renamed (this is required for Looker to understand the relation automatically) and 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 new LookML project, you select the connection name from the configuration log.
You’re done. New LookML project with automatically created relations is prepared for you.