- 4426 Views
- 3 replies
- 6 kudos
Unable to create materialized view in Unity enabled Catalogues.
Hi Team,I was going through one of the videos of Databricks Sql Serverless and it say there is materialized view support . We can create materialized view .I tried same on my cluster of Sql Warehouse gives below error:
- 4426 Views
- 3 replies
- 6 kudos
- 6 kudos
Materialized views is in private preview right now afaik. Please talk to your account or customer success team at Databricks in order to sign up and enable it for your workspace. Thanks!
- 6 kudos
- 17604 Views
- 1 replies
- 1 kudos
Resolved! Views vs Materialized Delta Tables
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?
- 17604 Views
- 1 replies
- 1 kudos
- 1 kudos
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 vi...
- 1 kudos