Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Analytics

News, events, thought leadership and more.

New AWS Athena and Redshift Spectrum Connectors Drive Faster Insights

RamanK
Alteryx Alumni (Retired)
‎03-14-2018 09:00 AM

With the release of 2018.1, Alteryx delivers increased analytic flexibility for users and builds on our great partnership with Amazon Web Services (AWS). The new Amazon Athena and Redshift Spectrum connections through the Input and Output tools further empower Alteryx users to harness the full value of their existing analytics architecture and emerging big data assets.

 

The Amazon Athena connection allows users to read and write (Bulk Loader is also an available option for performance) to Athena, making it easy for users to query their AWS data instantly for analytics. Amazon Athena is a server less, interactive query service that makes it easy to analyze big data in Amazon S3 using standard SQL.

 

The Amazon Redshift Spectrum connection also allows for both reading and writing (Bulk Loader is also an available option for performance). Amazon Redshift Spectrum enables users to quickly run Amazon Redshift SQL queries against exabytes of data in Amazon S3. Redshift Spectrum extends the analytic power of Amazon Redshift beyond data stored in the Redshift data warehouse to query the unstructured data Amazon S3 - without having to load or transform any data.

 

The new AWS connections add analytic flexibility for users and build upon the previously released connections for AWS – Amazon Aurora, Amazon Redshift, and Amazon S3. Alteryx 2018.1 continues to push the analytics needle by making working with data much easier - regardless of where it's from, what shape it's in, or where it needs to go.

 

Upgrade to 2018.1 if you are already an Alteryx user (or try it out for free if you are new to Alteryx) to experience these new features and others for yourself. Also, if you’d like to learn more about the Alteryx and AWS partnership, please visit our AWS partner microsite for demos, joint client testimonials, and more.

 

aws-athena-1.png

 

 

 

Raman Kaler
Sr. Manager, Alliance Marketing

Raman is responsible for alliance marketing at Alteryx, where she focuses on defining strategy and executing joint marketing programs with key strategic technolog partners. She currently focuses on alliance marketing efforts with, among others, Amazon Web Services, Microsoft, Salesforce, and Tableau. Raman has proven success in creating strategic marketing and business development programs that drive and support pipeline growth.

Raman is responsible for alliance marketing at Alteryx, where she focuses on defining strategy and executing joint marketing programs with key strategic technolog partners. She currently focuses on alliance marketing efforts with, among others, Amazon Web Services, Microsoft, Salesforce, and Tableau. Raman has proven success in creating strategic marketing and business development programs that drive and support pipeline growth.

Comments
saiHareesh
8 - Asteroid
‎03-27-2018 12:34 PM

HI,
I Have upgraded my alteryx designer to 2018.1.3 and i am unable to see the connection for Athena. The only thing i can see is( screenshot below)

Alteryx_AWSathena.PNG
Please help me with the connection.

0 Likes
DanM
Alteryx Community Team
Alteryx Community Team
‎03-27-2018 01:33 PM

@saiHareesh

 

There isn't a specific connector for Athena. You will need to use an ODBC driver to connect to Athena. Here is more details https://help.alteryx.com/current/index.htm?_ga=2.71758230.403253465.1522008027-1960283514.1520617682...

 

DanM

0 Likes
saiHareesh
8 - Asteroid
‎03-27-2018 02:27 PM

@DanM

I was thinking there is a specific connector in new release under connector section. Thank you for the update. I was able to connect :-)

0 Likes
sathiya
8 - Asteroid
‎03-27-2018 07:54 PM

 

The screenshot shows Amazon Redshift Bulk , Amazon Athena Bulk is this available on the 2018.1 version ?

0 Likes
saiHareesh
8 - Asteroid
‎03-28-2018 10:32 AM

Based on my experience you you need to download drives so that it appears next time when you work.

0 Likes
DanM
Alteryx Community Team
Alteryx Community Team
‎03-28-2018 11:47 AM

@sathiya Athena is available in 2018.1

 

@saiHareesh You should not have to install the drivers to see the Athena Bulk Loader in the Output tool. We display all available bulk load options in the Output tool. The Input tool only displays SQL, Oracle, and Hadoop. All other database connections must be made through the Other Databases using the specific driver needed to connect.

 

Thanks

DanM