Question

A data provider has created a direct share containing a secure view over a curated sales table. After the consumer account has already imported the shared database, the provider adds a new column to the underlying base table and updates the secure view definition to expose that column. What must the provider do so the consumer sees the newly exposed column?

Accepted Answer

Nothing extra — because the consumer queries live data through the share, the updated secure view immediately reflects the new column

Answer

Recreate the entire share and have the consumer re-import the shared database before the new column is visible

Answer

Manually copy the updated view into the consumer account using a database replication job

Answer

Grant SELECT on the new column to the consumer account's ACCOUNTADMIN role for the change to propagate