When a new table (table_6) is added to a schema in the provider's account that is part of a data share, the consumer will not automatically see the new table. The consumer will only be able to access the new table once the appropriate privileges are granted by the provider. The correct process, as outlined in option D, involves using the provider's ACCOUNTADMIN role to grant USAGE privileges on the database and schema, followed by SELECT privileges on the new table, specifically to the share that includes the consumer's database. This ensures that the consumer account can access the new table under the established data sharing setup.
Reference:
Snowflake Documentation on Managing Access Control
Option A sounds right to me. The documentation mentions that the match_by_column_name parameter expects the CSV file to have a header row that matches the table column names.
MENU
Shawn
27 days agoDemetra
15 days agoDeja
1 months agoElise
8 days agoDelsie
16 days agoTwana
18 days agoAlison
21 days agoHester
23 days agoTequila
23 days agoAnnamae
1 months agoNorah
1 months agoIra
11 days agoKeva
1 months agoMargurite
2 months agoFallon
2 months agoDeeanna
2 months agoJesse
2 months ago