- We can create a new data source and specify the following options:
- Warehouse: COMPUTE_WH
- Database: SNOWFLAKE_SAMPLE_DATA
- Schema: TPCH_SF1000
You can learn more about the TPC sample dataset at http://www.tpc.org/tpc_documents_current_versions/pdf/tpc-ds_v2.5.0.pdf.
- When we are choosing Warehouse, we are choosing to compute resources for our DW. In our case, COMPUTE_WH is a X-Large. We also have SF_TUTS_WH that is X-Small.
- Build the data model, as shown in the following screenshot:

- Let's answer the following business question: List the totals for the extended price, discounted extended price plus tax, average quantity, ...