Add Snowflake tables to a Snowflake Data Clean Room¶

When an administrator initially configured the environment for a Snowflake Data Clean Room, they registered the databases that contain the tables available to clean room collaborators.

When tables, schemas, and databases are added to the Snowflake account after this initial configuration, the administrator must refresh the clean room environment before collaborators can work with these tables in a clean room. Administrators must follow this process even if the database that contains the new tables was previously registered.

To register new tables, schemas, or databases in the clean room environment:

1. Access the URL that corresponds to the region where your Snowflake account is located:

   Region	Sign up page
   AWS US West (Oregon) AWS US East (Ohio) AWS US East (N. Virginia) Azure West US 2 (Washington) Azure Central US (Iowa) Azure South Central US (Texas) Azure East US 2 (Virginia)	https://cleanroom.c1.us-east-1.aws.app.snowflake.com
   AWS Canada (Central) Azure Canada Central (Toronto)	https://cleanroom.c1.ca-central-1.aws.app.snowflake.com
   AWS Asia Pacific (Mumbai) Azure Central India (Pune)	https://cleanroom.c1.ap-south-1.aws.app.snowflake.com
   AWS Asia Pacific (Singapore) Azure Southeast Asia (Singapore)	https://cleanroom.c1.ap-southeast-1.aws.app.snowflake.com
   AWS Asia Pacific (Sydney) Azure Australia East (New South Wales)	https://cleanroom.c1.ap-southeast-2.aws.app.snowflake.com

2. Select Snowflake Admin.

3. Select Login to Snowflake, and authenticate as a user with the ACCOUNTADMIN role.

4. Do one of the following:

   1. If you added a new schema or table to a previously registered database, select Resync.

   2. If you added a new database, select Edit, and then select the database.