Download or Move Snowflake Worksheet

Question

our org is a snowflake customer. Right now we are trying to migrate snowflake user account to our parent company account i.e [email protected] >> [email protected]. The problem is once we create a parent company account we dont have any option to move the worksheets, dashboards or filters from the child company account. Many of our users have more than 400 worksheets and we dont want to create that manually. Is there is any options to migrate worksheets from one account to another. Sharing is not an option because the child user account will be removed. I found this snowsightextension resource to export and import the worksheet but it stopped working recently due to snowflake authentication method changes. Any help is much appreciated.

Answer 1

Worksheets can be found in a user's stage:

LIST @~/worksheet_data;

Using snowsql or another connector, you can execute a GET command to download those files, and then a PUT to push them to the new account location.

Answer 2

there is an option to recover worksheets of a dropped user that may do what you need in a very risky way. Maybe it is possible to drop user manually get their worksheets as tar gz undrop the user

https://docs.snowflake.com/en/user-guide/ui-snowsight-worksheets#label-snowsight-worksheets-recover-dropped