• I wonder if a snow flake schema might be better for you to model the ticket dimension

    While anything is possible, the uses for a snow flake schema are uncommon. It should never be used simply to normalize in the manner as a transactional database. I recommend you start with a star schema.