QuestionQ40

VerifiedOfficial exam objectives/topics

A Data Engineer must enrich customer data as part of a transformation process by calling an external REST API hosted outside Snowflake. The API must be invoked securely from SQL statements and incorporated into transformation logic without exposing credentials.

What sequence of steps correctly meets these requirements?

Explanation

Snowflake external functions invoke services outside Snowflake from SQL. The API integration stores the security-related configuration, while a cloud HTTP proxy or integration service relays requests to the remote API. The external function then references both the API integration and the proxy-service endpoint, allowing SQL transformation logic to call the service without embedding credentials.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!