![]() For the purposes of this demo, I assume you know how to go about it. If you don’t know how to create such keys, this is a good starting point. Remember-where possible, avoid using root or admin credentials. Make sure that your AWS IAM has the right permissions to conduct all these operations.įirst, let’s create some access keys. Pick whichever AZ works best for you ,but keep it consistent. Note that throughout the setup, I will be using us-east-1 region. Set up Athena to speak with the data in the S3 buckets.Create some access keys that we can use later in Tableau to access our data.Depending on your operating system, you need to move this file to:įor Windows C:\Program Files\Tableau\Driversįor Mac ~/Library/Tableau/Drivers location AWS Setup jar file named something like AthenaJDBC41 or AthenaJDBC42. ![]() Be sure to download the version with AWS SDK. For Tableau Desktop 2020.2 – 2022.1, you need to download the JDBC Driver with AWS SDK (.zip file). If you suspect Java is already installed, you can check the version before you get started. You can find all the details on how to do it here. Let’s make it happen! Java and Tableau Athena Driver Installedįirst off, make sure Java is installed on the machine where Tableau Desktop will be used. Then we will need to set up AWS, and lastly, we will connect to AWS from Tableau. The setup we will follow here is not suitable for a production environment.Īll right, let’s get started! There are effectively three areas where we will work: First, we will need to install some software on our computer. Important: This article simply aims at helping you get familiar with these platforms and the possibilities afforded by them, especially when working in conjunction with each other. Tableau Desktop installed on your machine and a basic knowledge of how to connect to a Server database.Some exposure to AWS if you know how to create IAM users and S3 buckets, you will be fine.In my example, we will use just a few dozen rows of data. Although Amazon offers free tier accounts, note that Athena is not covered under the free plan, so you may need to spare a few cents. An Amazon Web Services account ready for use with permissions to create IAM users, S3 buckets and create Athena assets.If you have an IT manager/department/function that takes care of the AWS installation, feel free to skip to the Tableau section, towards the end of the article.Ī bit of housekeeping before we start. We will be using the guides provided by AWS and Tableau as reference points to effectively open a connection from Tableau to a CSV file that will be stored in an S3 bucket. Today, I will cover how to make these two great platforms, Tableau and Amazon Athena, work together in just a few steps.
0 Comments
Leave a Reply. |