John Ryanarticles.analytics.today·Jul 20, 2024Snowflake Syntax: SHOW DATABASESShow 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...Discuss·86 readssnowflake
John Ryanarticles.analytics.today·Jul 18, 2024Snowflake Syntax: Show GrantsShow 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...Discuss·956 readssnowflake
John Ryanarticles.analytics.today·Jul 14, 2024Snowflake Syntax: Create a Virtual WarehouseCreate 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...Discuss·47 readssnowflake syntax