Custom Views

Custom Views are pre-built SQL views in your Hardal ClickHouse database that surface your data in a specific shape — tailored to your business, your reporting tool, or your team's workflow.

What they are

A Custom View is a named view (e.g. view_daily_revenue_by_product) that Hardal creates in your database. Once active, it's available in:

• The Hardal dashboard
• Any BI tool connected via database connection (Looker Studio, Hex, Tableau, Power BI)
• Direct ClickHouse queries via the API

When to use one

Custom Views are useful when:

• You need a metric or aggregation the built-in reports don't provide
• You want to join Hardal event data with your own fields or segments
• Your BI tool needs data in a specific format or column structure
• You want to share a pre-filtered dataset with a stakeholder without giving full database access

How to request one

Reach out to the Hardal team with a description of what you need:

Include:

• What data you want to see
• How it should be grouped or filtered
• Which tool you plan to use it in

Accessing existing views

Once a view is created, query it directly:

SELECT * FROM view_your_custom_view_name
LIMIT 100

Or use the Analytics API to fetch data programmatically.