I have a preexisting View, originated from a table in the datawarehouse, and I would like to add to this view a column from another table of the same schema.
Is it possible to perform this join on a preexisting View without having to transform it into a Derived Table?
You have your thinking wrong. Create another view for this new table in the schema and join the views together in the model file in an explore.
Yes, i know this is the standard process, but i just need this one column from the second table and i didn’t want to pollute the Explore with another View with just one dimension. So i’m looking for alternatives.
In a join you can use fields: -parameter in the join. That way you can join a single column, without polluting the explore with lots of irrelevant fields.
https://docs.looker.com/reference/explore-params/fields-for-join