Advanced Query Interface

Query your ID graph without moving data

Why an Advanced Query Interface?

Your requirements are unique, and no platform can realistically address all use cases. Instead of guessing what you need, Optable believes you should be able to query your data from your own BigQuery account, while also keeping your data secure.

The Advanced Query Interface enables you to have a view of your entire ID graph made accessible from Google BigQuery without having to move data.

Use Cases

Here are some examples of operations you can currently perform through the Advanced Query Interface:

• Join your identity graph with non-Optable data

• Run custom algorithms (e.g., a lookalike model)

• Run aggregation functions to generate insights

• Create new computed traits and reingest them into your DCN (for when you do not control the schema of your data source and need to improve it)

Using the Advanced Query Interface

Your Advanced Query Interface contains:

• Your full identity_graph
• Filtered views per audience and match
• Routines, which are predicates you can use in a SQL WHERE clause, facilitating queries between views without joining them.

For instance, if you want the intersection between match 2 and audience 19, you can use the view audience_19 and filter it with the filter_match_2 predicate.

Another way to achieve the same result is to use two predicates.

Getting Access to Advanced Query Interface

To get access to the Advanced Query Interface, you will need to know the interface's View Link, and to be in the Allowlist. Both fields can be found/configured in the Settings > General section on the UI.

Allowlist and View Link

Allowlist

The Advanced Query Interface is only available to select users.

Because Advanced Query Interface leverages Google BigQuery, user emails must be linked to a Google account, and groups must be Google Groups.

A User Type must be specified for each user:

• Users: individual users, such as [e-mail]

• Groups: group emails, such as [e-mail], which includes many individual users such as [e-mail] and [e-mail]

• Domains: you can give access to anyone in your organization by giving domain access to, for instance, mediaco.com

• Service Accounts

If you gave access to a group such as [e-mail], but users within that group, such as [e-mail] cannot access the Advanced Query Interface, check that the User Type is set to Group and not User.

View Link

The Advanced Query Interface is not "discoverable". Not only do you need to be included in the Allowlist, but you also must know your unique DCN's project_name.dataset_name.view_name (View Link) in order to access it from your Google BigQuery account.

There are two ways to access your data.

1. You can copy the link from the UI or CLI and use it in your BigQuery query.

2. You can add the project to your BigQuery pinned projects. The project name is the first part of the View Link, before the dot. E.g., optable-platform.

Data Schema

Your Optable ID graph has a predefined schema. You can optionally take advantage of Trait Typing to customize it to your need. Your schema will then look like this: