SlicingDice Documentation

SlicingDice API Docs

Welcome to the SlicingDice API documentation. You'll find comprehensive guides and documentation to help you start working with SlicingDice as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    Guides

Query examples

First time checking our docs? You might want to start with the right foot by reading our Documentation Guide first.

SlicingDice is very flexible in terms of querying data, you can use our JDBC and ODBC SQL Drivers, our API-based SQL endpoint or our standard API-based JSON endpoint.

In order to make your life simpler and easier, we prepared many query examples, using SQL, our API-based SQL endpoint and the API-based JSON endpoint, for querying data on all our types of columns.

Count entities query examples

Know how many unique entities (how many primary keys) you have in a particular dimension satisfy the query conditions.

Count events query examples

Know the number of times some data was inserted for an event column in a particular dimension.

Aggregations query examples

Generate insights from the data stored at SlicingDice by calculating metrics (Average, Sum, Min, Max, etc.) and crossing data from different columns to generate pivot tables.

Top values query examples

Know what are the most common values for a specific column and how many times was the value inserted.

Exists query examples

Check whether the given entity IDs exist in a dimension.

Total query examples

Know how many unique entities you have in a particular set of dimensions (or in the whole database).


Data extraction queries

Differently from analytics-focused queries, data extraction methods allow you to retrieve data stored on SlicingDice. Below you can find all data extraction queries currently supported by SlicingDice.

Result query examples

Allows you to retrieve the values from columns for all entities or the entities that satisfy the query conditions.

Score query examples

Almost the same behavior of the Result query, but Score query allows you to retrieve values while receiving the entities' relative importance given a set of conditions.