GitHub user avamingli closed a discussion: [Feature] Dynamic Tables
### Description Snowflake has a special table called Dynamic Tables: https://docs.snowflake.com/en/user-guide/dynamic-tables-intro The Dynamic Tables is much like Materialized View but in Snowflake, Materialized View is not exactly the one in Postgres/GPDB/CBDB. Here is difference between Materialized Views and Dynamic Tables in Snowflake: https://docs.snowflake.com/en/user-guide/dynamic-tables-comparison#dynamic-tables-compared-to-materialized-views A main difference is that Materialized View could be used to Rewrite Query in Snowflake, but Dynamic tables can't. Rewrite Query in Snowflake is our Answer Query Using Materialized Views(AQUMV) in CBDB. And Materialized View could only has one simple table in Snowflake, that is exactly the matview candidate we could use for AQUMV currently(But we are planning to support complex querys have multiple tables or joins). Dynamic Tables are very useful for users in some cases. We don't have exactly one like Materialized View or Dynamic Tables in Snowflake, but we could have sth like that. Maybe not all concepts or features are exactly matched, but most of them could be implemented in Postgres/CBDB. And if we have Dynamic Tables in CBDB, unlike Snowflake, I think it could be used to AQUMV too. Because we have the ability to track matview data's status and even if it has external tables #693 with a GUC to control. ### Use case/motivation _No response_ ### Related issues _No response_ ### Are you willing to submit a PR? - [X] Yes I am willing to submit a PR! GitHub link: https://github.com/apache/cloudberry/discussions/706 ---- This is an automatically sent email for dev@cloudberry.apache.org. To unsubscribe, please send an email to: dev-unsubscr...@cloudberry.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@cloudberry.apache.org For additional commands, e-mail: dev-h...@cloudberry.apache.org
