UPDATE SHARE
Currently, sharing a database only creates a point-in-time snapshot of the database.
To update the database to a newer version, you need to explicitly execute the UPDATE SHARE
statement.
All users of the share will automatically see data related changes (like inserts and updates) within 1 minute. Changes from ALTER TABLE
statements will also be reflected automatically. Users will see all other catalog related changes (from things like CREATE TABLE/VIEW/SCHEMA
statements), in addition to data related changes, upon new connections (native) or page reload (web).
Syntax
UPDATE SHARE <share name>;