Question 470
Consider this Snowflake situation: An external function requires Snowflake to invoke an approved HTTPS service but developers mistakenly configure only an S3 storage integration. Which platform behavior BEST explains the appropriate solution?
Explanation
Correct Answer
The decisive Snowflake behavior is: API integrations govern access to external APIs, unlike storage integrations that authorize object-storage locations. It supports the response: Use an appropriate API integration and approved external-function configuration for the service endpoint. Confirm it with this observable result: A sample external function call reaches the intended endpoint and denies unauthorized destinations. Distinguish this mechanism from superficially related Snowflake features.
Incorrect Answers
The Spark connector provides integration between Spark workloads and Snowflake-managed data. That explanation applies to a different technical failure. Here the controlling principle is: API integrations govern access to external APIs, unlike storage integrations that authorize object-storage locations.
The offered statement is true for this other mechanism: Scheduled SQL tasks and direct streaming ingestion solve different arrival and processing patterns. It does not explain the facts described here, which follow from: API integrations govern access to external APIs, unlike storage integrations that authorize object-storage locations.
Semi-structured values retain nested structure that must be projected with supported SQL path syntax. That explanation applies to a different technical failure. Here the controlling principle is: API integrations govern access to external APIs, unlike storage integrations that authorize object-storage locations.