Query Data

You can query the data entities defined in the Single Origin app or use the Single Origin API.

Single Origin app

🚧

Prerequisites

To use this feature, the user must setup a personal connector with sufficient query privileges. See Connecting to Your Data.

You can query your data without writing any SQL. To build a query, you can select:

• data entities (required)
• any additional dimension to group by (optional)

Once you select these inputs, you can execute the query (and get results in a table) and generate the corresponding SQL.

Single Origin API

For more information on how to query data using our API, see our Consumption page.

Issues

• If I change my "Data Entities" selection, my options for "Group Bys" change as well. Why?
  • It is possible to query multiple data entities from multiple views simultaneously; however, each view needs to have the same standardized dimensions defined.
  • If you add multiple data entities to your query, and the list of "Group Bys" is either very short (or if you see "No dimensions available"), then the underlying views might have few (or no) standardized dimensions in common.
• Why does a time filter sometimes appear underneath the "Query" header on the page?
  • If you select a standardized dimension to group by and that standardized dimension is a TIMESTAMP, then a time filter will appear to narrow down the time you query over.