star schema in ADLS

Anshal 1,201 Reputation points

Hi friends, please guide me how I build a star schema in ADLS Gen2 and also

synapse . can it be done , link and documentation will help.

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,127 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,007 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 4,461 Reputation points

    While ADLS Gen2 is schema-on-read , it helps to organize your data to reflect the star schema. For example:

    • /fact_sales/
    • /dim_customers/
    • /dim_products/
    • ...

    So in your case, Azure Synapse Analytics can be used to query and analyze data on ADLS Gen2. Ensure you have an Azure Synapse Workspace and necessary components.

    Synapse can natively integrate with ADLS Gen2. You'll just want to create linked services and datasets for your data.

    Using either serverless SQL pool or provisioned SQL pool, you can develop and run T-SQL queries on your data in ADLS, treating them as if they were in a traditional star schema setup.

    Here are some links that can help you :