Go through the 6 steps to run Verifiable Analytics on the tables that you are connected to in the Data Sources Page.

Query contents & navigation

The user can either navigate through the given arrows (screenshot 1) or the navigation panel on the right (screenshot 2). The navigation panel as well provides the user with information about the already selected values and lets the user navigate back to any of the previous or possible next steps of the querying process.

Step 1 - Select Data Source

Select a data source from the data source list, in the data-sources page. 

Step 2 - Select a table for the analytical operation. 

Step 3 - Select a column for analytical operation. 

The column name is presented together with its data type. 

Step 4 - Choose analytical operation

We currently support SUM and COUNT operations. SUM operation will be only available to the integer, bigint, smallint and decimal data types. COUNT will be available to all data types.

Step 5 - Select a Filter (Optional action)

You will be able to pick an optional filter, which will be added to the query. It can be enabled or disabled via a checkbox. The filter allows you to select a column from the dropdown menu on which the filter is to be applied. In the second dropdown menu a filter value is selected. A full relation between a column type and its possible filters are provided below. 

Step 6 - Review

Here is a finalized SQL query preview and before triggering the “Run Query” Action.

Usually the Analytical result is instant and the proof is asynchronous. So when you go to the “Proofs” page, the downloadable proof file for that query will appear. The larger the data set, the longer the “Proof” takes to generate. Ve

After the user runs the query, he’ll be presented with a query result and an option to view all proof requests (redirects to proofs page), where he’ll be able to download the proof file for this query.