Direct SQL Access
AdLibertas offers customers the ability to access their datasets directly using Amazon Athena.
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.
AdLibertas customers can contact their account representative to request access to Athena. You will be given:
A Sign-in URL:
- A Sign-in URL: https://example.signin.aws.amazon.com/console
- 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:
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.