Views vs Materialized Delta Tables

User16826990884
Databricks Employee
Databricks Employee

Is there general guidance around using views vs creating Delta tables? For example, I need to do some filtering and make small tweaks to a few columns for use in another application. Is there a downside of using a view here?

User16826990884
Databricks Employee
Databricks Employee

Views won't duplicate the data so if you are just filtering columns or rows or making small tweaks then views might be a good option. Unless, of course, the filtering is really expensive or you are doing a lot of calculations, then materialize the views as Delta tables for faster queries.

View solution in original post