What kind of Snowflake integration is required when defining an external function in Snowflake?

Question

Options

• AAPI integration
• BHTTP integration
• CNotification integration
• DSecurity integration

• A
  88% (22)
• B
  8% (2)
• C
  4% (1)

Explanation

An API integration is required because external functions in Snowflake call remote services via HTTPS endpoints (like AWS API Gateway or Azure API Management), and the API integration object stores the authentication credentials, allowed endpoints, and IAM role/permissions needed to make those outbound calls securely.

• B (HTTP integration) - doesn't exist as a Snowflake object type; Snowflake uses API integrations to handle HTTP-based remote calls, not a standalone "HTTP integration."
• C (Notification integration) - this is a real Snowflake object, but it's used for event notifications (e.g., SNS, Pub/Sub, Azure Event Grid), not for defining external functions.
• D (Security integration) - also real, but it handles authentication protocols like OAuth and SAML for identity providers, not remote function invocation.

Memory tip: Think "external function = external API call = API integration." The word external maps directly to API - both refer to something outside Snowflake that you need a formal integration object to reach.

No community discussion yet for this question.