Hi @JasonW-5564 ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
The credential to data lake can be defined with SAS secret and below documents are tutorials explaining the loading using examples. Wild cards can be used to select all the JSON files under specific folder.
sql-data-warehouse-load-from-azure-data-lake-store
copy-into-transact-sql
Please suggest for further queries and we will be glad to assist.
--
- Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
- Want a reminder to come back and check responses? Here is how to subscribe to a notification.