Cubes: Mapping of date parts in date datatype columns

date_model_example.json

{
    "cubes": [
        {
            "name": "example",
            "measures": ["amount"],
            "dimensions": ["date"],
            "mappings": {
              "date.year": {"column":"date", "extract":"year"},
              "date.month": {"column":"date", "extract":"month"},
              "date.day": {"column":"date", "extract":"day"}
            }
        }
    ],
    "dimensions": [
        {
            "name":"date",
            "levels": ["year", "month", "day"]
        }
    ]
}

According to SQLAlchemy sources, you can extract in most of the databases: 'month', 'day', 'year', 'second', 'hour', 'doy' (day of the year), 'minute', 'quarter', 'dow' (day of the week), 'week', 'epoch', 'milliseconds', 'microseconds', 'timezone_hour', 'timezone_minute'.