Comment on page

Integrations

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. STORAGE INTEGRATION for STAGE, NOTIFICATION INTEGRATION for PIPE, etc.).
Example of storage integration
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;
Example of API integration
CREATE API INTEGRATION TEST_API_INTEGRATION
API_PROVIDER=aws_api_gateway
API_AWS_ROLE_ARN='arn:aws:iam::123456789012:role/my_cloud_account_role'
API_ALLOWED_PREFIXES=('https://xyz.execute-api.us-west-2.amazonaws.com/production')
ENABLED=TRUE;
​
GRANT USAGE ON INTEGRATION TEST_API_INTEGRATION TO ROLE SNOWDDL_ADMIN;

Administration user

Object OWNERSHIP

Last modified 7d ago