Change Snowflake Database Owner

1
votes

We are trying to display data in a database that belongs to ACCOUNTADMIN role using AWS QuickSight. The problem is when we are trying to connect QuickSight to Snowflake, QuickSight automatically uses database that is in SYSADMIN role, there is no option where I can choose to display database that is in ACCOUNTADMIN role in QuickSight. Therefore, is there a SQL syntax that changes DSA database owner ACCOUNTADMIN to SYSADMIN including the tables, views, and schema in it as shown below

enter image description here

1
snowflake-cloud-data-platformamazon-quicksightsnowsql

1 Answers

0
votes

The grant ownership seem to be what you want, and thus

grant ownership on database dsa to role SYSADMIN;

should work.

I found that help page on the Snowflake Documentation site via the search change ownership