New Data Warehouse Integrations for PowerMetrics

Metric-first analytics are reshaping how teams access and use data. Companies are building robust metrics strategies that enable consistent definitions, exploration, and visualization—directly within their existing data stack. Whether your data lives in a cloud data warehouse, semantic layer, cloud service APIs, or spreadsheets, you need a metrics strategy that grows with your data infrastructure.

We're excited to announce integrations with seven leading data warehouses: Snowflake, Google BigQuery, Databricks, Microsoft Azure SQL, Amazon Redshift, PostgreSQL, and MariaDB. These integrations give data teams direct access to their gold-standard data while enabling business users to explore metrics with an interactive catalog, advanced analysis, visualization, and dashboards.

PowerMetrics is the only hybrid metrics solution that supports data warehouse metrics, semantic layer metrics (from Cube and dbt Labs Semantic Layer), and a custom modelling and hosted data solution. You can create metrics from data pulled from hundreds of cloud services (Shopify, Facebook Ads, Zendesk), files (Excel, Google Sheets, Smartsheet, Airtable), and direct REST/API queries. The reality is data teams work with data at every stage—from raw to business-level, pre-aggregated, and analytics-ready. PowerMetrics connects to all of these sources and evolves as your data stack grows.

Are your data scientists or analysts using an enterprise BI solution like Tableau, Power BI, or Sigma? PowerMetrics is designed to work alongside these tools, providing a better experience that business users prefer. This combination lets metric creators and consumers use the application and interface that fits their needs.

Why data warehouse metrics?

Metrics built on data warehouse tables and views deliver significant advantages for data teams. The most important: no external data storage. Your single source of truth in your modern data stack remains the authoritative source, extended through to the metrics layer. Data cleansing and transformation happen within the data warehouse, enabling you to use preferred tools like dbt Core or dbt Cloud to create gold-standard, metrics-ready data. You have full control over the transformation process, table structure, naming conventions, and performance optimizations. And you unlock the full power and performance of your underlying data warehouse.

Our data warehouse integrations enable:

• Fastest metric creation from data warehouse tables and views
• Easy metric building from any popular data warehouse without vendor lock-in
• Real-time queries performed directly on your data warehouse—no external data transfer
• Full data warehouse performance with no data size limitations
• Automatic updates via webhook as soon as underlying tables or views change
• Complete data governance within your own data warehouse using your preferred tools
• Self-serve analytics for business users while maintaining full control of your data stack
• Interchangeable metric types: data warehouse metrics work seamlessly with semantic layer metrics, data feed metrics, calculated metrics, and instant metrics

Data warehouse customer snapshot

Media Propulsion Laboratory (MPL) is a leading digital advertising consultancy using PowerMetrics and BigQuery to visualize client campaign data.

Part of the Craft&Crew group of companies, MPL serves clients including Google and Conagra Brands. MPL needed to visualize and share marketing and campaign data internally and with customers. They switched from Looker Studio to PowerMetrics for its user-friendly design—a professional yet intuitive solution that works for marketing teams, not just data specialists. PowerMetrics enabled their clients to make data-driven decisions without requiring technical expertise.

MPL pulls data from multiple marketing services including Pinterest, Google Analytics 4, and Facebook, but stores everything in BigQuery. They use the PowerMetrics data warehouse integration to build metrics from BigQuery tables and views, allowing a single table to power multiple metrics. These metrics are shared through the metric catalog, where business stakeholders instantly see which metrics are available and certified by the data team. Non-technical users analyze single or multiple metrics, create dashboards, and generate reports. The data team maintains full control over who can see or edit each metric and dashboard.

PowerMetrics has transformed our approach to data analytics at Media Propulsion Laboratory. The intuitive design, coupled with remarkable ease of use, has empowered teams throughout the company. Klipfolio's responsive, knowledgeable, and collaborative approach made the entire experience exceptional.

Richard Marginson, General Manager, Media Propulsion Laboratory

Level up data-driven decision making

Make metric analysis easy for everyone.

Get Started Now

Get started today

Connect to your data warehouse, create and curate metrics, and enable self-serve analysis, visualization, and dashboard creation for your business users. These integrations are available now.

Let PowerMetrics help you build a metrics strategy that scales with your data stack. Try it yourself and share your feedback.