The samples/tasty_bytes/tb_zts_financial_governance.sql script is failing on line 161:
_ALTER WAREHOUSE tasty_test_wh SUSPEND;_
with the following error message:
Invalid state. Warehouse 'TASTY_TEST_WH' cannot be suspended.
The issue is produced because the INITIALLY_SUSPENDED parameter is set to TRUE in line 48 of the CREATE WAREHOUSE statement:
INITIALLY_SUSPENDED = true;
To resolve the issue, you can either set the INITIALLY_SUSPENDED parameter to FALSE or comment line 161 out.
The samples/tasty_bytes/tb_zts_financial_governance.sql script is failing on line 161:
_ALTER WAREHOUSE tasty_test_wh SUSPEND;_with the following error message:
Invalid state. Warehouse 'TASTY_TEST_WH' cannot be suspended.The issue is produced because the INITIALLY_SUSPENDED parameter is set to TRUE in line 48 of the CREATE WAREHOUSE statement:
INITIALLY_SUSPENDED = true;To resolve the issue, you can either set the INITIALLY_SUSPENDED parameter to FALSE or comment line 161 out.