Before writing a CREATE EXTERNAL ACCESS INTEGRATION statement:
- Read
references/parameters.mdto review all available parameters and their defaults. - For each parameter, decide whether the user's request implies a non-default value.
- Include only the parameters that differ from the default or that the user explicitly requested.
- Never use
CREATE OR REPLACE— useCREATE EXTERNAL ACCESS INTEGRATION(IF NOT EXISTS is not supported for this object). - ALLOWED_NETWORK_RULES must reference EGRESS-mode network rules only; INGRESS or INTERNAL_STAGE rules will cause an error.
- ALLOWED_AUTHENTICATION_SECRETS should be
noneunless the external endpoint requires authentication; when secrets are needed, list them explicitly rather than usingall. - ENABLED = TRUE is the default; only include it explicitly if setting to FALSE or the user wants the integration disabled at creation time.
Source: Gyrus-Dev/frosty — distributed by TomeVault.