1.DDL

1.1 warehouse command

• create warehouse

create warehouse TEST

• suspend warehouse

alter warehouse test suspend

• resume warehouse

alter warehouse TEST resume

• show all warehouses

show warehouses

• abort all running queries

alter warehouse  TEST  abort all queries

• change name

alter warehouse TEST rename LG101

1.2 database command

• create database

create or replace database company

• show databases

show databases 

show databases like 'c%' 

• create schema

create schema if not exists employee

• show schemas

show schemas

show schemas like 'e%'

1.3 role

• create a role

CREATE OR REPLACE ROLE TEST_ROLE