Newly created shares now support auto-updating. Automatically updated shares no longer require running explicit UPDATE SHARE commands.

To create an auto-updating share, use the UPDATE AUTOMATIC option in the CREATE SHARE statement.

The option for manually updating shares remains available, and continues to be the default setting.

Check out more information on auto-updating shares in our documentation: https://motherduck.com/docs/sql-reference/motherduck-sql-reference/create-share/#update-clause