Hi @Ram001
Azure dedicated sql pool is what formally named Azure SQL DW. It is a relational database.
Check the documentation here for more information, but the short answer is in this part:
Dedicated SQL pool (formerly SQL DW) stores data in relational tables with columnar storage. This format significantly reduces the data storage costs, and improves query performance. Once data is stored, you can run analytics at massive scale.
With that said, remember that dedicated sql pool can use external tables which mean that the data in this case is stored in the external source and not internally which is the meaning of external tables
. Therefore, you can use data which is not stored directly in the tables inside the dedicated sql pool.
Is this answer your question or do you need more clarification?