Hi, we’ve been using Looker for 2+ years without any previous experience with this tool. We have all data stored in db in star schema - Kimball dimensional data modelling. We are used to create models in the following way:
This approach is too complicated and complex. It generates a lot of .view and .explore files. Plus we have to create dim_status multiple times if it’s used in one SELECT more than once.
So my question is: those who use star schema in dbs how do you handle Looker models? We are thinking about creating denormalised tables up on star schema for Looker purposes. It would be faster to query in Looker and easier for developers to build Looker models based on them. What do you think? What’s your approach?