Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
I am trying to mask a column on a DLT materialized view - this is created using DLT syntax. I am not able set the column masking after creation. Appreciate any workaround.
We get the following error: [EXPECT_TABLE_NOT_VIEW.NO_ALTERNATIVE] 'ALTER TABLE ... ALTER COLUMN' expects a table but `catalog`.`schema`.`MV` is a view. SQLSTATE: 42809
Also, if you go to the table through Catalog, and follow the docs steps:
In a MV, you will face the following message: To add or remove column mask for Materialized Views, use the CREATE OR REPLACE statement
Which indicates that, for now, this operation is not possible for MVs.
If you believe this feature of adding column mask to MVs through ALTER TABLE/VIEW would be beneficial, you could submit an idea in Databricks' Ideas Portal.
Best regards, Lucas Rocha Technical Solutions Engineer
We get the following error: [EXPECT_TABLE_NOT_VIEW.NO_ALTERNATIVE] 'ALTER TABLE ... ALTER COLUMN' expects a table but `catalog`.`schema`.`MV` is a view. SQLSTATE: 42809
Also, if you go to the table through Catalog, and follow the docs steps:
In a MV, you will face the following message: To add or remove column mask for Materialized Views, use the CREATE OR REPLACE statement
Which indicates that, for now, this operation is not possible for MVs.
If you believe this feature of adding column mask to MVs through ALTER TABLE/VIEW would be beneficial, you could submit an idea in Databricks' Ideas Portal.
Best regards, Lucas Rocha Technical Solutions Engineer
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.