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

0 0 67
0 REPLIES 0
Top Labels in this Space
Top Solution Authors