Search code examples
snowflake-cloud-data-platformamazon-quicksightsnowsql

Change Snowflake Database Owner

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

Solution

  • 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