Our database is in Aurora Postgres on AWS. I access it using psycopg2 in python. The data is such that each row represents an instance of an item being brought. There areI multiple columns such as the time_when_sold, item_name, item_category, customer_name. I want to create a multi-dimensional data cube so that the data can be better organized and pre-aggregated, which would make query results faster too. However, I cannot figure out how to create the data cube on postgres specifically. The online resources I've gone through don't seem to talk about postgres. Any help will be greatly appreciated.
I have managed to execute the query "create extension cube". Beyond this I am failing to create the cube the way i want it.
