Tutorial: Restore a deleted connection

This tutorial provides step-by-step instructions for restoring a previously deleted connection.

Prerequisites

Before continuing with this tutorial, ensure you have completed the following prerequisites:

• Tutorial: Update data and files using a connection

Delete the GOOGLE Connection

1. Access the Snoweaver application with the owner role or a custom role with the SNOWEAVER.APP_ADMIN application role.

2. Open the Connections page from the side bar menu and select the google connection to view its details.

3. Click the Delete button to remove the connection.

   

4. Confirm that the connection schema has been successfully deleted from the SNOWEAVER database.

Restore the deleted connection

1. Open the Home page and locate the Administration block.

2. Specify the following configuration and click Restore Connection:

   Deleted Connection Name:   google
   Restore Offset (minutes):  5 (select an offset just prior to deletion)

3. Click the Restore Connection button to remove the connection.

   

4. Open a Snowflake worksheet and execute the following SQL statements using a role with the necessary privileges. If you are working in a sandbox environment, you may use the AccountAdmin role or an equivalent role:

   -- Re-grant the Snoweaver operator application role to the developer role
   GRANT APPLICATION ROLE SNOWEAVER.GOOGLE_OPERATOR TO ROLE LEARN_DEV_DEVELOPER;
   
   -- Switch to the developer role
   USE ROLE LEARN_DEV_DEVELOPER;
   
   -- Set the context to the GOOGLE schema in the SNOWEAVER database
   USE SCHEMA SNOWEAVER.GOOGLE;
   
   -- List the contents of the DATA stage to verify access
   LIST @DATA;