Surface materialized views in view names

[AetherUnbound]

Description

Right now we have we have a mix of views & materialized views in the database. For instance, audio_view and audioset_view - the former is actually a materialized view whereas the latter is a standard view. The syntax for operating with these tables can be different (e.g. DROP MATERIALIZED VIEW vs DROP VIEW).

It might be useful to reflect which views are actually materialized by incorporating it in their name. We could use matview instead of view for the suffix. Here are the current tables:

deploy@localhost:openledger> \d
+--------+----------------------------+-------------------+--------+
| Schema | Name                       | Type              | Owner  |
|--------+----------------------------+-------------------+--------|
| public | audio                      | table             | deploy |
| public | audio_popularity_constants | materialized view | deploy |
| public | audio_popularity_metrics   | table             | deploy |
| public | audio_view                 | materialized view | deploy |
| public | audioset_view              | view              | deploy |
| public | image                      | table             | deploy |
| public | image_popularity_constants | materialized view | deploy |
| public | image_popularity_metrics   | table             | deploy |
| public | image_view                 | materialized view | deploy |
| public | smithsonian_new_unit_codes | table             | deploy |
+--------+----------------------------+-------------------+--------+

This would mean we'd update the following:

• audio_view -> audio_matview
• image_view -> image_matview

I'm excluding the popularity constants matviews because they do not have any suffix, but perhaps we should add suffixes there as well.

Note that this will also necessarily require changes in the ingestion server code for which tables to reference.

Implementation

• 🙋 I would be interested in implementing this feature.

[AetherUnbound]

Closing this as it's no longer relevant - we don't have these matviews any more!