To create an auto-updating share in MotherDuck, use the CREATE SHARE statement with the UPDATE AUTOMATIC option. This ensures that the share is automatically updated when the underlying database changes. Here's an example:
```
CREATE SHARE my_share FROM my_database (UPDATE AUTOMATIC);
LBKSWould you like more detail on this process?
Sources:
- [CREATE SHARE | MotherDuck Docs](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/create-share/)
- [UPDATE SHARE | MotherDuck Docs](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/update-share/)