@ilir_nuredini It totally makes sense. Thanks to confirm it. I would say that the best way to validate tables with expectations would be to use private materialized views and not views as it suggested in the link.

Note. Private materialized views were previously created with the TEMPORARY parameter). CREATE MATERIALIZED VIEW (Lakeflow Declarative Pipelines) | Databricks Documentation