We suffix views with '_vw' and materialized views with '_mv'. This makes it easy to not have to consult the DDL every time we need to know what a table is. I've

We suffix views with '_vw' and materialized views with '_mv'. This makes it easy to not have to consult the DDL every time we need to know what a table is. I've also run into several instances of: object_name_mv object_name_vw I can only assume that at some point the view was non-performant for user-facing application and was turned into a snapshot. In general, I'm a fan of suffixing views with '_vw' to basically be a red flag saying "there's another query behind me."