What to use instead for primary key and forieng key in Sql data warehouse? RRS feed

  • Question

  • Hello,

    Just simple thing, in normal database we have a table with primary and one table have forieng key relating to primary table .Same thing if I want do in Sql data warehouse How I am going to do. As primary key is not available here.

    4 Dimension tables and one fact table so when I am querying the relationship should be there right?

    How to define primary key and forieng key in Sql data warehouse?

    Wednesday, July 4, 2018 9:46 AM

All replies

  • Hi DanishNB,

    Azure SQL Data Warehouse uses Fact, Dimension, and Integration tables based upon a star schema. The below link explains this in greater detail. 

    Designing tables in Azure SQL Data Warehouse

    If you should have additional specific questions, please continue the discussion.



    Monday, July 9, 2018 6:28 PM
  • Hello Mike- Our legacy dataware house is more specific dependant on enforcing constraints.

    Here is in SQL DW- not sure how we do that MS in future add those features?

    Just finding out ways to complish that...fact and Dim is based on PK and related FK rt?

    Any specific more pointers would help?



    Thursday, July 19, 2018 6:55 PM