Delphi x Looker - Part 2
We've released more features for Looker teams
As we’ve onboarded more Looker teams to our product, we’ve released a few additional features that make things even better for these teams.
Credential Passthrough
Many data teams that have deployed with Looker also use its RBAC features to control what data users can see. Typically, this is used for hiding experimental or sensitive models from users who don’t need to access them.
Dashboards and Looks can also be put into folders, with access controlled for specific users or roles. This is typically used for restriction to sensitive domain-specific reporting, eg Finance.
Credential Passthrough matches the credentials used to access Delphi with those on Looker, to ensure that a user can only access content they have permissions for.
Explore Filtering
In the picture above, you can see we have also introduced a way to choose which Explores you want Delphi to choose metrics and dimensions from.
While you may have a perfectly minimal Looker project, nicely split into different models for different uses and domains - we know many teams have struggled with organic growth in LookML and aren’t so fortunate to be in this situation.
Even in a well set-up Looker project, it is common and not incorrect to have the same metric exposed in different contexts. For example, Revenue can exist in an Explore looking at conversion and also in a Finance Explore. Usually, these two numbers are close but not exactly the same, and the vast majority of users will only want to see one of these.
Support for Explore field lists
explore: explore_name {
fields: [
field-or-set-specification,
field-or-set-specification,
...
]
}
In Looker, it is possible to limit the fields usable in an Explore using the “fields” array.
This is now supported in Delphi - if fields for an Explore are restricted using this feature, Delphi will only use these fields.
Michael and I were on the Spectacles webinar last week 🎉🤓, hosted by Dylan Baker - check out the recording in the link below:
https://www.spectacles.dev/webinars/natural-language-questions-and-looker-with-delphi
If you’re interested in trying out Delphi, go to app.delphihq.com and click “Sign Up”! 🦾
Alternatively, if you’d rather talk about your particular needs, please book a call with me here.