CREATE OR REPLACE VIEW will soon preserve grants, comments and tags by default

UpdateOct 6, 20262d2 days ago·Unverified·Added Oct 8, 2026

Starting December 2, 2026, CREATE OR REPLACE VIEW will update views in-place, instead of dropping and re-creating the view. Grants, tags, and comments are preserved with two caveats: As views execute with view owner's permissions, grants are not preserved if a non-owner alters the view query via CREATE OR REPLACE VIEW You must first remove governed tags on...

Topics: SQL, Governance, Security