Optimizing Base Model

I am currently building my base model by joining views in an Explore and extending. Since Looker has to write the SQL, is it best create a derived table which selects all the fields in your data set. Referring to a mention I heard at a Data Guild meeting about using a SELECT *. One issue occurred during testing was the naming collision of the fields from joined tables. Since SELECT * was used example I am trying to understand if I am implementing the proper technique and what are some best practices around developing the base model. Thanks

This topic has been closed for comments