Direct SQL Access

AdLibertas offers customers the ability to access their datasets directly using Amazon Athena.

How it works

With just your credentials, AdLibertas will collect data from all of your data sources, unify, and store the compressed data in a customer-specific AWS account. You can use Amazon Athena to directly SQL-query your normalized data from here.

Since Athena is an easy to use serverless Amazon-managed service, teams can get directly access their data using standard SQL. And since AdLibertas is pulling and storing the data, there is no need for data engineering effort to get up and running.

Getting Started

AdLibertas customers can contact their account representative to request access to Athena. You will be given:

A Sign-in URL:

User name: example_account

One-time Password: *******

  • A Sign-in URL:

  • User name: example_account

  • One-time Password: *******

Note: Once you have access to the AWS Management Console you will have administrative access for the purposes of Amazon Athena access and while data can’t be deleted via Athena, account access does allow the ability to permanently alter datasets.

Once you have access to your account:

  1. Change Region to Us-West-2

  2. Change workgroup to your example_account

  3. Change database to your example_account

Custom or granular access:

While AdLibertas out-of-the box user-level reporting allows highly sophisticated reports to be constructed without the need for custom SQL, customers do have the need to create more complex queries that are out of scope from a UI. Most often, these customers will lean on writing their own queries to access the data. A popular use case is downloading the members of an AB test, then running user-level event counts to gain more sophisticated insights into test-outcome probabilities and confidence, not already supported.

Targeting or CRM management

Since all audiences are readily available for SQL export, customers can easily export user IDs for the purposes of targeting or CRM management. A great example would be running a report on your top-performing users, then giving them a special offer to incentivize retention or conversion.

Last updated