Looker Integration

[emresemercioglu]

We will create LookML files via CLI.

👍 Upvote if you plan to use this integration.
✍️ If you have any ideas, questions or use cases you'd like to share about this issue, feel free to use comments.

[jpau]

Thanks Emre! This would be great.

I wonder what the development workflow would look like. For example -- would the CLI generate view files only, or might it stub model files too? And after the initial creation, on further iterations, would the CLI track the LookML-specific parts that get updated? Or might the onus be on the user -- at least at the start -- to track those manually?

[buremba]

Hey @jpau , we will be generating view files a structure everything under a model. There is a similar project here as well:
https://github.com/lightdash/dbt2looker (See https://github.com/lightdash/dbt2looker/blob/main/example/lookml/hubble_analytics.model)

For the LookML specific attributes, you will be able to configure the fields as follows:

columns:
  - name: col
    meta:
      metriql.dimension:
         report:
            looker:
              type: distance

The report.looker spec will be identical to LookML dimension: https://docs.looker.com/reference/field-reference/dimension-type-reference

[buremba]

@UmarMajeed-Rana is working on this integration, thanks Umar!

[buremba]

@all-contributors please add @UmarMajeed-Rana for code, platform.

[allcontributors]

@buremba

I've put up a pull request to add @UmarMajeed-Rana! 🎉

[buremba]

It's implemented, please see: https://metriql.com/integrations/bi-tools/looker