Share via

Solutioning without ADLS

xyz_chatter 211 Reputation points
2021-01-22T12:24:29.163+00:00

I am planning to ingest source tables without using ADLS. I do not have any file analytics requirement, just intend to load the source to Synapse and top of that to build dimensional model.

Do you see any disadvantage/risk here as I am planning to skip ADLS from my design. Thank you!

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,466 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,903 questions
0 comments
Accepted answer
  1. MartinJaffer-MSFT 26,086 Reputation points
    2021-01-25T21:59:53.907+00:00

    Hello @xyz_chatter and welcome to Microsoft Q&A.

    The only possible disadvantage I can think of, is in some scenarios using ADLS as staging can result in faster loads when using polybase.

    Other than that, I think you should be fine skipping ADLS.

    Please let me know if this answered your query, or if you have other concerns. Thank you!

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.