Skip to main content

Query Tool

This guide provides a step by step walkthrough of the Crysp IQ Query Tool

1. Click "Consume"​

Start by clicking on the "Consume" menu item

Click 'Consume'

2. Click "Data Warehouse Query"​

Then select the "Data Warehouse Query" menu option

Click 'Data Warehouse Query'

3. View CryspIQ Entities​

The query tool shows all available entities in Crysp IQ, you can drag these entities to the middle part of the query tool to view the attributes

View CryspIQ Entities

4. View and select attributes​

Here, you can select the attributes to use in the query builder. These attributes will be available in the query tool for filtering, sorting and grouping data as well as for applying ANSI SQL functions.

View and select attributes

5. Add and relate entities​

You are also able to add more entities and create relationships between the entities

Add and relate entities

6. Write ANSI standard SQL to query CryspIQ​

You can create ANSI standard SQL to query Crysp IQ. Create your SQL statement in the Query Editor to query your data.

Write ANSI standard SQL to query CryspIQ

7. Click "Preview"​

Click on "Preview"

Click 'Preview'

8. View Query Results​

You can now see the query results on this page.

View Query Results

This guide covered the steps to Query Tool in Crysp IQ.