Jul 20, 2024 路 2 min read 路 Show Databases: What does it do? Used to find: Which Databases are accessible to the current Role Related Pages create database show schemas show tables SHOW DATABASES Lists all the databases for which the Current User has at least USAGE privi...
Join discussion
Jul 18, 2024 路 4 min read 路 Show Grants: What does it do? Used to find: Which Users have access to a given Role? Which Users or Roles were granted to a given Role (confusing - but it makes sense below) Which Roles have access to a given Table or View Which Privileges (eg. C...
ASerge commented
Jul 14, 2024 路 3 min read 路 Create Warehouse What does it do? Used to create a Virtual Warehouse which can be used to execute queries. Required Privileges Your current role needs to have the following privileges: CREATE WAREHOUSE 馃挕 By default, only the SYSADMIN role has the p...
Join discussion