forked from randypitcherii/cloud_cost_monitoring
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathteardown.sql
26 lines (25 loc) · 1.15 KB
/
teardown.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
USE ROLE SYSADMIN;
DROP DATABASE CLOUD_COST_MONITORING_DEV;
DROP DATABASE CLOUD_COST_MONITORING_PROD;
DROP DATABASE CLOUD_COST_MONITORING_TEST;
DROP WAREHOUSE CLOUD_COST_MONITORING_DEV_WH;
DROP WAREHOUSE CLOUD_COST_MONITORING_PROD_WH;
DROP WAREHOUSE CLOUD_COST_MONITORING_TEST_WH;
DROP WAREHOUSE SIGMA_CLOUD_COST_MONITORING_REPORTING_WH;
USE ROLE SECURITYADMIN;
DROP ROLE CLOUD_COST_MONITORING_DEV_READ_WRITE;
DROP ROLE CLOUD_COST_MONITORING_DEV_TRANSFORMER;
DROP ROLE CLOUD_COST_MONITORING_DEV_TRANSFORMER;
DROP ROLE CLOUD_COST_MONITORING_DEV_WH_ALL;
DROP ROLE CLOUD_COST_MONITORING_PROD_READ_WRITE;
DROP ROLE CLOUD_COST_MONITORING_PROD_REPORTING_READ;
DROP ROLE CLOUD_COST_MONITORING_PROD_TRANSFORMER;
DROP ROLE CLOUD_COST_MONITORING_PROD_WH_USAGE;
DROP ROLE CLOUD_COST_MONITORING_TEST_READ_WRITE;
DROP ROLE CLOUD_COST_MONITORING_TEST_TRANSFORMER;
DROP ROLE CLOUD_COST_MONITORING_TEST_WH_USAGE;
DROP ROLE SIGMA_CLOUD_COST_MONITORING_REPORTER;
DROP ROLE SIGMA_CLOUD_COST_MONITORING_REPORTING_WH_USAGE;
DROP USER DBT_CLOUD_COST_MONITORING_PROD_SERVICE_ACCOUNT;
DROP USER DBT_CLOUD_COST_MONITORING_PROD_SERVICE_ACCOUNT;
DROP USER SIGMA_CLOUD_COST_MONITORING_SERVICE_ACCOUNT;