All of the tables in the data warehouse are contained within the same database.
You cannot join tables across multiple data warehouses.
Learn key concepts for designing tables in Azure SQL Data Warehouse.
A star schema organizes data into fact and dimension tables.
For a list of the supported data types, see data types in CREATE TABLE reference in the CREATE TABLE statement.There are several factors that affect the choice of the distribution column.For more information, see Design guidance for distributed tables.The hash distribution distributes rows based on the value in the distribution column.The hash-distributed table is designed to achieve high performance for query joins on large tables.Replication requires extra storage, though, and is not practical for large tables.