Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx to AWS Athena Complex JSON gzip file connection

Antonio
5 - Atom

I have successfully connected an Alteryx workflow to an Athena table which queries a complex json file using the Input Tool. I expanded the hierarchy of the json array using CROSS JOINS and UNNEST SQL functions in Athena ti create the table. The Alteryx workflow output from the Athena table resulted in un-expanded json format and I am back where I started. I need to to be able to get the result in the Alteryx workflow to be the same as the result in the Athena query. Am I missing something; or is this functionality to get expanded json not yet available in Alteryx?

4 REPLIES 4
BrandonB
Alteryx
Alteryx

Have you tried the JSON Parse tool in the developer category? This can parse JSON fields.

 

https://help.alteryx.com/current/designer/tools/developer/json-parse-tool

DiganP
Alteryx Alumni (Retired)

@Antonio Can you send a screenshot of the JSON data? and also the SQL query you are using in the Alteryx SQL Editor? I'm curious as it should un-nest the JSON via the SQL query. 

 

As @BrandonB  recommended, you can also use the JSON parse tool to parse the data without the use of the SQL statement. 

Digan
Alteryx
Antonio
5 - Atom

Thanks for the reply Brandon. I tried the Alteryx json parse tool but it did not work because the data from Athena is already in a table format; but your reply helped me in solving this issue...

Antonio
5 - Atom

Alteryx throws an error when I tried to read the Athena View created from the Athena un-nest query; and I was reading the Athena table which is the reason Alteryx is returning the nested result. I applied the un-nest query in Alteryx SQL Editor and it worked. Thanks for your reply which helped me identify the issue...

Labels