So I notice that in an explore, even if I just want to get stats of a single table only, when querying Looker still joins that table with another table (that I defined in the model) and the base table as well. That resulted in missing data of the single table if I don’t do full outer join. Is there a solution to this besides using outer join? I’m also curious whether this is a common use case for others?
If both tables are independent in a way that contain data that may not exist in the other, than you may need both explores, if you don’t want to do full outer join.