Please enable JavaScript.
Coggle requires JavaScript to display documents.
DP-203 - Chapter 7 - Implementing the Serving Layer - Coggle Diagram
DP-203 - Chapter 7 - Implementing the Serving Layer
Dimensional model
Star schema
Hierarchy
Accessing parquet files
using
serverless SQL pool
CREATE EXTERNAL TABLE
Data source
file format = PARQUET
location
using
Spark
Azure databricks
setup service principal to access data lake
Synapse Spark
create a lake database
Share data across Azure services
metastores
Synapse
shared metamodel between SQL and spark pools
SQL pool has only read access to spark tables :warning:
maintain metadata in Synapse
:red_flag:
Databricks
Hive metastore