https://community.databricks.com/t5/data-engineering/views-vs-materialized-delta-tables/m-p/19105#M12761 <P>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?</P> Fri, 25 Jun 2021 18:40:31 GMT User16826990884 2021-06-25T18:40:31Z https://community.databricks.com/t5/data-engineering/views-vs-materialized-delta-tables/m-p/19105#M12761 <P>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?</P> Fri, 25 Jun 2021 18:40:31 GMT https://community.databricks.com/t5/data-engineering/views-vs-materialized-delta-tables/m-p/19105#M12761 User16826990884 2021-06-25T18:40:31Z https://community.databricks.com/t5/data-engineering/views-vs-materialized-delta-tables/m-p/19106#M12762 <P>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.</P> Fri, 25 Jun 2021 19:18:16 GMT https://community.databricks.com/t5/data-engineering/views-vs-materialized-delta-tables/m-p/19106#M12762 User16826990884 2021-06-25T19:18:16Z