Comment on page
Currently most types of INTEGRATION objects are not managed by SnowDDL and should be created manually by
ACCOUNTADMIN. Setting up an integration normally require additional steps to be performed outside of Snowflake, which is out of scope of SnowDDL.
Integration should be granted to SnowDDL administration role to make it possible to use it in definition of other objects (e.g.
CREATE STORAGE INTEGRATION TEST_STORAGE_INTEGRATION
TYPE = EXTERNAL_STAGE
STORAGE_PROVIDER = GCS
ENABLED = TRUE
STORAGE_ALLOWED_LOCATIONS = ('*');
GRANT USAGE ON INTEGRATION TEST_STORAGE_INTEGRATION TO ROLE SNOWDDL_ADMIN;
CREATE API INTEGRATION TEST_API_INTEGRATION
GRANT USAGE ON INTEGRATION TEST_API_INTEGRATION TO ROLE SNOWDDL_ADMIN;