About

Looker (now part of Google Cloud) is a modern business intelligence platform that lets data teams define metrics in a centralized semantic layer, ensuring everyone in the company works from the same definitions. Zentry's Looker integration exposes expense, budget, and vendor data as LookML models ready to explore.

Finance analysts define spend metrics once in LookML — average transaction size, budget utilization rate, top vendor spend — and business users across the company can self-serve accurate reports without writing SQL.

Looker dashboards embedded in internal tools or sent via scheduled email deliveries keep stakeholders informed without requiring Looker access, democratizing financial insight across the organization.

Requirements

Looker Enterprise or Google Cloud Looker instance with database connection privileges. Zentry exposes a read-only database connection (PostgreSQL-compatible) that Looker connects to directly.

A Looker developer with LookML experience should configure the initial data model. Zentry provides a starter LookML project that can be customized to match your reporting needs.

Getting Started

In Zentry Settings → Integrations → Looker, enable the analytics export and copy the provided database connection credentials (host, port, database, username, password).

In Looker Admin → Connections, add a new database connection using those credentials. Then import the Zentry starter LookML project from GitHub and explore the Expenses and Budgets explores to validate data.