Skip to main content
The Bronze schema contains raw CRM data tables that store customer information, product details, and sales transactions.

​
bronze.crm_cust_info

Customer information table containing demographic and registration data.
​
cst_id
INT
Customer ID - Unique identifier for each customer
​
cst_key
VARCHAR(50)
Customer key - Business key for customer identification
​
cst_firstname
VARCHAR(100)
Customer first name
​
cst_lastname
VARCHAR(100)
Customer last name
​
cst_marital_status
VARCHAR(100)
Customer marital status
​
cst_gndr
VARCHAR(10)
Customer gender
​
cst_create_date
DATE
Date when customer record was created

​
DDL

DROP TABLE IF EXISTS bronze.crm_cust_info;
CREATE TABLE bronze.crm_cust_info (
    cst_id INT,
    cst_key VARCHAR(50),
    cst_firstname VARCHAR(100),
    cst_lastname VARCHAR(100),
    cst_marital_status VARCHAR(100),
    cst_gndr VARCHAR(10),
    cst_create_date DATE
);

​
bronze.crm_prd_info

Product information table containing product catalog data.
​
prd_id
INT
Product ID - Unique identifier for each product
​
prd_key
VARCHAR(50)
Product key - Business key for product identification
​
prd_name
VARCHAR(100)
Product name
​
prd_cost
DECIMAL(10, 2)
Product cost
​
prd_line
CHAR(10)
Product line or category
​
prd_start_dt
DATE
Product start date - When product became available
​
prd_end_dt
DATE
Product end date - When product was discontinued

​
DDL

CREATE TABLE bronze.crm_prd_info (
    prd_id INT,
    prd_key VARCHAR(50),
    prd_name VARCHAR(100),
    prd_cost DECIMAL(10, 2),
    prd_line CHAR(10),
    prd_start_dt DATE,
    prd_end_dt DATE
);

​
bronze.crm_sales_details

Sales transaction details table containing order and sales information.
​
sls_ord_num
VARCHAR(50)
Sales order number - Unique identifier for each order
​
sls_prd_key
VARCHAR(50)
Sales product key - Links to product information
​
sls_cust_id
INT
Sales customer ID - Links to customer information
​
sls_ord_dt
INT
Sales order date - Date when order was placed (integer format)
​
sls_ship_dt
INT
Sales ship date - Date when order was shipped (integer format)
​
sls_due_dt
INT
Sales due date - Date when order is due (integer format)
​
sls_sales
INT
Sales amount (integer representation)
​
sls_quantity
INT
Sales quantity - Number of units sold
​
sls_price
DECIMAL(10, 2)
Sales price - Unit price

​
DDL

DROP TABLE IF EXISTS bronze.crm_sales_details;
CREATE TABLE bronze.crm_sales_details (
    sls_ord_num VARCHAR(50),
    sls_prd_key VARCHAR(50),
    sls_cust_id INT,
    sls_ord_dt INT,
    sls_ship_dt INT,
    sls_due_dt INT,
    sls_sales INT,
    sls_quantity INT,
    sls_price DECIMAL(10, 2)
);

Build docs developers (and LLMs) love

Get started for freeTalk to us