Back to prompts
Data & AnalysisPremiumadvanced
4.7

The Data Warehouse Builder

Spin up a complete database schema before lunch.

Copy & Paste this prompt
Provide end-to-end SQL scripts to build and load a small data warehouse.

Requirements:
- Create all objects in a "dw" schema
- 5 dimension tables and 2 fact tables
- Include a Date dimension
- Provide INSERT statements with sample data (one INSERT per row)
- Include constraints
- Provide all SQL statements together in one script
#sql#data-warehouse#database#schema-design

Works with

chatgptclaudegemini