After running a Snowflake query in Aqua Data Studio, the results take more than a minute to return even if the result set is very small. When I check the query history in Snowflake, I see that a SHOW ROLES after each query.
It appears to me that regardless of the query, Aqua is running the show roles/show databases/show schemas. The latter two are relatively quick (less than 1 second) but the show roles is dragging the result down because it’s runs 40-50 seconds in our environment due to the number of roles we have implemented.
ADS is running the query but it is a view within Snowflake. If user is operating from a QA window, ADS repopulates the dropdowns at the top of the QA window after each query. This is done since the roles and database can change dynamically. This is inefficient. Would like a better way of keeping those drop downs current.
One user that is also facing this issue recommends changing the behavior to run SHOW GRANTS (runs in less than 2 seconds) which would show the user only the roles they have been granted. At least make the option configurable so users can toggle between SHOW ROLES and SHOW GRANTS. Running SHOW ROLES at the end of every query is counterproductive as it shows users roles they cannot access.
Hi Alonso,
I put a small fix in \\172.20.32.12\Divisions\Divisions\Aquafold\datastudio\v22.2.1
Note that it is ADS v22.2. Please pick one of the platforms that the customer uses and upload it to the ftp site for them to test. Since this is a test, please ask that only one or two test this. If it works, we will release for ga shortly.
Thanks,
Tom
Hi Alonso,
I put a small fix in \\172.20.32.12\Divisions\Divisions\Aquafold\datastudio\v22.2.1
Note that it is ADS v22.2. Please pick one of the platforms that the customer uses and upload it to the ftp site for them to test. Since this is a test, please ask that only one or two test this. If it works, we will release for ga shortly.
Thanks,
Tom
Alonso once you have it loaded, I would like to contact the customer with the details, per our call yesterday.
Alonso once you have it loaded, I would like to contact the customer with the details, per our call yesterday.
Issue #15893 |
Resolved |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
One user that is also facing this issue recommends changing the behavior to run SHOW GRANTS (runs in less than 2 seconds) which would show the user only the roles they have been granted. At least make the option configurable so users can toggle between SHOW ROLES and SHOW GRANTS. Running SHOW ROLES at the end of every query is counterproductive as it shows users roles they cannot access.