This script can be used to select the required role, warehouse, database, and schema.
use role accountadmin;
use warehouse WAREHOUSENAME;
-- create or replace database DBNAME;
use database DBNAME;
-- create or replace schema SCHEMANAME;
use schema SCHEMANAME;Figure 1. Selecting database and schema