Building your first EQQ query takes under ten minutes. This walkthrough assumes you have the Extended Edition and at least one database connection under Settings → Database.

Step 1 - create a View

A View is a governed projection of one or more tables. Go to Manage Views → New View, pick your database, and select the tables and columns end users are allowed to see.

Manage Views - pick the schema projection users are allowed to see.
Manage Views - pick the schema projection users are allowed to see.

Step 2 - build the Query

Open Manage Queries → New Query, pick the View you just created, drag columns into the output, and add filters or sort orders from the toolbar. Use @ParameterName (SQL Server) or :ParameterName (MySQL/PostgreSQL) to make runtime inputs.

The Manage Queries page is where designers author parameterized queries.
The Manage Queries page is where designers author parameterized queries.

Step 3 - move through the lifecycle

EQQ queries progress through states: In Process → Saved → Generated → Active. Only queries in Active appear to end users. This is intentional - it lets a data steward iterate without exposing half-finished work.

Step 4 - grant roles

Under Security → Roles, give a role like Finance Query User the permission to run your new query. Assign that role to the users who need it. They will see the query in Use Queries the next time they sign in.

Step 5 - run it

Have an end user open Use Queries, pick your query, fill the parameters, click Run. Watch the grid populate. You just shipped a self-service data product in minutes.

Try EQQ free. Spin up a free trial and run your first governed query today. Start Free Trial →