BigQuery Drop materialized view
Deletes a materialized view. The data in the underlying tables are not affected
Drop materialized view example
DROP MATERIALIZED VIEW IF EXISTS mydataset.my_myview
Syntax reference
DROP MATERIALIZED VIEW [IF EXISTS] mv_name