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!

Alteryx Designer Desktop Discussions

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

Azure Data Lake - Extract Files Like

MatthewBr
Alteryx Alumni (Retired)

I would like to connect to Azure Data Lake and extract all of the JSON files within that directory similar to a Dynamic Input Tool.  All of the files in the directory have the same schema within them.   Each week it could be 500 or 5000 files. What are my best options?  

 

Thanks in advance community! 

 

 

MatthewBr_0-1651065589989.png

 

1 REPLY 1
IraWatt
17 - Castor
17 - Castor

Hey @MatthewBr,

My first port of call would be to try the Azure Data Lake Tools - Alteryx Community. I also found an interesting article on downloading using using precog: Precog + Alteryx: A Slam-Dunk Analytics Partnershi... - Alteryx Community. If nether of these are the answer there is always the download tool.

 

As you may need to look through directories to download different files I would recommend a batch macro, with the links to the different files being the control parameter.

 

If you want clarification or have any issues feel free to ask :) 

All the best,

Ira 

Labels