As we explained in IQL overview, the first part of any query is the
SELECT clause. In fact, the simplest IQL query is only a
SELECT clause. In this article, we'll see how a
SELECT clause is constructed for an identity query.
Before you can work through this article, you'll need to understand the concept of an output column. If you're not confident you're familiar with this term, read the glossary entry before you begin.
You'll also need to understand the difference between insight queries and identity queries. This article is about identity queries. For insight queries, the
SELECT clause is a little different. See this article for details.
Choosing the output column
For an identity query, the
SELECT clause in IQL is extremely simple. Just specify the name of the output column you want to return, using the syntax
dataset.column. For example:
You can only select one output column at a time, and you can only select an output column in an identity query.