Location Id
Order Id
Order Item Id
Item option IDs - this could be in an array
Item price
Item quantity


Then you join to order to get the total price and create/close out times

Location to get the store information

Products to get the item name

Options to get the names of the options in the array.

Since these are all numbers it will be drastically smaller and faster than storing this all in text - you only need the text once in the dimension tables and can reuse it over and over. Joins and filters are also faster on numbers vs text.

And if you are filter on time it usually converts that to a Unix time stamp in the background and joins it that way so the conversion is added overhead, so you’ll sometimes see the times stored as an integer not a datetime