Which command creates an API integration in Snowflake?

• A. CREATE API INTEGRATION
• B. CREATE INTEGRATION API
• C. CREATE API PROVIDER
• D. CREATE EXTERNAL_INTEGRATION

Answer: (A)

Creating an API integration in Snowflake is done with a command that names the integration and specifies it as an API integration. That exact wording is what Snowflake recognizes to set up the object that lets Snowflake communicate with external REST APIs, including how requests are authenticated and signed. The option that uses the correct order and keywords—CREATE API INTEGRATION—is the valid way to instantiate this integration.

The other options don’t fit because they either place keywords in the wrong order or refer to a different type of object. For example, attempting to use a form like CREATE INTEGRATION API isn’t valid syntax, and CREATE API PROVIDER doesn’t correspond to a Snowflake DDL for creating an API integration. CREATE EXTERNAL_INTEGRATION would create a different kind of integration for external data sources, and in Snowflake the convention uses the two-word phrase EXTERNAL INTEGRATION, not an underscore-delimited name.