cancel
Showing results for 
Search instead for 
Did you mean: 

Analytics Blog

News, events, thought leadership and more.
Announcement | Looking to expand your Alteryx skillset?! Check out the latest set of interactive lessons in Alteryx Academy: Creating Analytic Apps
Alteryx
Alteryx

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 AuroraAmazon 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
Asteroid

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.

Community Operations Specialist
Community Operations Specialist

@Hareesh

 

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

Asteroid

@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 :-)

Meteoroid

 

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

Asteroid

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

Community Operations Specialist
Community Operations Specialist

@sathiya Athena is available in 2018.1

 

@Hareesh 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