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    Documentation

Below are the few but crucial terms used by SlicingDice. Understanding these terms will simplify and expedite your introduction to SlicingDice.

Entity / Entities

An entity is like a primary key in relational databases. SlicingDice uses entities to identify and associate data with individual objects such as users, devices, servers, etc.

Every entity must have a unique string ID. For example you could use your users' email addresses as an ID or, if you are storing server monitoring data, your server hostname.

Columns

SlicingDice columns are like regular columns in a relational database or on an excel spreadsheet.

On SlicingDice we have two main categories of columns, attribute and event columns. In this link you can check the difference between attribute and event columns.

A column may be either attribute or event column. Further, in-depth review on the [differences between attribute and event columns]differences-on-attribute-and-event-columns) is available. The following is a summary on the key differences:

Attribute Column

This column type is used to store any data not associated to a date/time. An attribute describes the facts, details or characteristics of an entity. You can use them to store: the name, age, and gender of users; the region of your server or IOT device, and more.

Lear more about how to insert data into attribute columns or how to create columns.

Event Column

This column type is used to store event data that is associated to a date/time. For instance you can track a click on an Add to Cart button in your Click event column by storing the value Add to Cart and the date/time of the event {% convert_date 'YYYY-MM-DDT10:35:23Z' '-1d' %}.

Learn more about how to insert data into event columns or how to create columns.

Dimensions

Unlike relational database tables where you typically define relationships between tables, SlicingDice doesn't have the concept of tables. In some cases you may need to store data for multiple entities under one project, dimensions are used to segregate your data between the entities.

Learn more about what dimensions are and how/when to create them.

Query Operators

Operators on SlicingDice are like SQL operators, such as and, or, not and freqgroup. Learn more about all supported operators and how to use them.

Query Predicates

Predicates on SlicingDice are like SQL predicates, such as equals, not equals, between and many others. Learn more about all supported predicates and how to use them.

Query Parameters

Parameters are special conditions, such as dimension, columns, minfreq and more, that can be used when inserting or querying data. Learn more about all supported parameters and how to use them.


What's Next

Quickstart guide

Glossary