You can use the views to replace these commands however, there are The INFORMATION_SCHEMA views provides a SQL interface to the same information provided by the SHOW commands. Returns results if role has been assigned the MONITOR USAGE global privilege otherwise, returns results only for the ACCOUNTADMIN role.Ĭonsiderations for Replacing SHOW Commands with Information Schema Views ¶ the role with the OWNERSHIP privilege on the task), or a role with the global MONITOR EXECUTION privilege. Results returned only for the ACCOUNTADMIN role, the task owner (i.e. Results returned only for the ACCOUNTADMIN role or task owner (role with OWNERSHIP privilege on task). Results are only returned for the role that has access to the specified object. Results returned only for the ACCOUNTADMIN role. Results depend on the privileges assigned to the user’s current role.ĭATABASE_REFRESH_PROGRESS, DATABASE_REFRESH_PROGRESS_BY_JOB ![]() Results depend on MONITOR USAGE privilege. The table functions in INFORMATION_SCHEMA can be used to return account-level usage and historical information for storage, warehouses, user logins, and queries:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |