Data setup

The demo project assumes that the source data is already loaded into your Teradata instance, this mimics the way that dbt is used in a production environment. To achieve this objective we provide public datasets available in Google Cloud Platform (GCP), and scripts to load those datasets in Teradata.

1. Create or select a working database. The dbt profile in the project points to a database called teddy_retailers. You can change the schema value to point to an existing database in your Teradata system or you can create the teddy_retailers database running the following script in your database client:

   CREATE DATABASE teddy_retailers
   AS PERMANENT = 110e6,
       SPOOL = 220e6;
   

2. Load initial data set. Run the scripts in the references/inserts/ folder of the project in your database client, in this order:

   1. create_db.sql — creates the teddy_retailers database and the nos_auth authorization object needed for GCS access.
   2. create_data.sql — loads the four source tables from Google Cloud Storage using Teradata NOS.

   Each table should load in under 10 seconds. Expected row counts: source_products (50), source_customers (1,000), source_orders (858), source_order_products (9,131).