Date Dimension Generation

Problem

The analysts are writing horrific CASE statements to figure out if an order happened on a weekend, a holiday, or in Q3. You build a specialized dimension table to hold this info. Write a query that outputs concept with the value: "A date dimension table pre-calculates date attributes like day of week, quarter, and is_holiday to simplify analytics."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution