I have been granted read only access to a Vendor's azure data lake and given a SAS connect string. How can I query this data via Azure Synapse and store the results in my own data lake?
fyi- The vendor's data is stored in JSON file format in this following folder structure YYYY/MM/DD/HH/(then hundreds of JSON files in each HH folder).