Are LookML models provided?

Yes. We provide a starter LookML project with models for P&L, budget vs actuals, scenario comparison, and KPIs.

Which databases are supported?

Grove FP data can be synced to BigQuery, Snowflake, or Redshift for Looker to query directly.

Can I customise the LookML models?

Absolutely. The provided models are a starting point. Extend them with custom dimensions, measures, and derived tables.

How is data kept fresh?

Data syncs from Grove FP to your data warehouse on a configurable schedule. Looker queries the warehouse directly for real-time results.

IntegrationData & BI

Looker Integration

Google Looker is an enterprise analytics platform that emphasises governed, modelled data exploration. The Grove FP integration lets you explore your planning data through LookML models for consistent, trustworthy financial analytics.

Setup time

15 minutes

Sync frequency

Scheduled data sync

Data flow

Grove FP → Looker: Financial data via API, pre-built LookML models

Overview

What it does

Connect Looker to the Grove FP data layer. We provide pre-built LookML models for common financial planning use cases — P&L analysis, budget vs actuals, scenario comparison, and KPI tracking.

Benefits

Why connect Looker

Pre-built LookML models for financial planning — no modelling from scratch

Governed data exploration ensures everyone works from the same definitions

Embed Looker dashboards in other tools or portals for wide distribution

Combine Grove FP data with your data warehouse for cross-domain analytics

Setup

How to connect Looker

Set up the data connection

Configure a database connection in Looker pointing to your Grove FP data warehouse or API.

Import LookML models

Import the Grove FP LookML project, which includes pre-built models, views, and explores for financial data.

Customise models

Extend the base LookML models with your own custom dimensions, measures, and derived tables.

Build dashboards

Use Looker's explore interface to build dashboards and save them for your team.

Share and embed

Share dashboards via Looker, embed them in other applications, or schedule automated report delivery.

Use cases

How finance teams use this integration

Self-service financial analytics

Give business users governed access to financial data through Looker's explore interface. They can slice and dice without breaking the model.

Embedded analytics

Embed Looker dashboards in your internal portal or executive intranet for always-on financial visibility.

Data warehouse integration

Combine Grove FP financial data with data from your warehouse (BigQuery, Snowflake) for comprehensive business intelligence.

Works well with

Related integrations

Data & BI

Power BI

Microsoft Power BI is the industry-leading business intelligence platform. The Grove FP integration lets you push your planning data into Power BI for advanced visualisations, dashboards, and embedded analytics.

View integration

Data & BI

Tableau

Tableau is a leading data visualisation and analytics platform used by finance and analytics teams worldwide. The Grove FP integration lets you connect Tableau directly to your planning data for rich financial visualisations.

View integration

Spreadsheets

Google Sheets

Google Sheets is the go-to collaborative spreadsheet for many teams. The Grove FP integration provides two-way sync, so you can work in Google Sheets when it suits you and have data flow back to Grove FP automatically.

View integration

FAQ

Frequently asked questions

This integration is for Google Looker (the enterprise platform), not Looker Studio (formerly Data Studio). Looker Studio support is planned.

Connect Looker to Grove FP today

Set up in 15 minutes. No credit card required. 30-day money-back guarantee.