UPDATE SHARE

Shares can either be manually or automatically updated by the share creator. All users of the share will automatically see share updates within 1 minute, containing both DDL (like CREATE TABLE) and DML (inserts, updates, or deletes) changes. These updates are transactionally consistent snapshots, i.e. never partial database updates.

The share creator can have the share be automatically updated when the underlying database changes. This is done by specifying the UPDATE AUTOMATIC option during share creation. Alternatively the share creator can manually update the share with a new point-in-time snapshot of the database. This is done by running the UPDATE SHARE command.

Syntax

UPDATE SHARE <share name>;