To be able to query data within the Data Platform using SQL.
- Data Analyst
The Data Platform provides AWS Athena as the tool to execute SQL queries against the data within the platform.
Logging into Athena
After logging into the Data Platform AWS account, navigate to Athena using the AWS console.
You'll want to make sure that your region is currently set to London, in AWS this is achieved using the region selector as shown below.
Then you'll want to ensure that you are switched to the Athena Workgroup for your department. You can check your current workgroup by hovering over the workgroup tab displayed at the top of the Athena page. If the workgroup isn't correct then switch your workgroup to the one you were given before proceeding.
From the "Query editor" you should have access to a number of tables, from which you can construct and execute queries.