page64
46
TPC Data Model
Figure 3-2 represents the TPC data model taken from the Snowflake sample TPCH data
found at
https://docs.snowflake.com/en/user-guide/sample-data-tpch
.
Figure 3-2.
TPC-H entity relationship diagram
You will next copy tables after which you will begin your investigation of query
profile behavior.
Initial Population
Within this section you will copy over SNOWFLAKE_SAMPLE_DATA from the
TPCH_
SF1000
schema, which contains the largest sample datasets.
ChapTer 3
The Query profiler