4 ms·
Snowflake has STREAM which can be crated on a view. It also has Dynamic Tables, from which you read a delta using STREAM or using row timestamp. SQL server has
by DenisM 24d ago
Snowflake has STREAM which can be crated on a view. It also has Dynamic Tables, from which you read a delta using STREAM or using row timestamp.
SQL server has Query Notification.
You can also read from debezium or other cdc, but thats more like table change than query result change.
- gregw2 23d agoAnd Bigquery has continuous queries: https://docs.cloud.google.com/bigquery/docs/continuous-queries-introduction https://docs.cloud.google.com/bigquery/docs/continuous-queri... And many databases have triggers. And with postgres you can combine triggers with NOTIFY to push changes downstream. But yeah, I feel like most databases are way behind Oracle on this feature and it's so so useful.