Skip to main content
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:

Contact Hardal Support

Describe your use case and we’ll build the view for you
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.

Database Connection

Connect your BI tool to query Custom Views