The statement
CREATE OR REPLACE API INTEGRATION
API_PROVIDER = git_https_api
is invalid because an object name is required right after CREATE OR REPLACE API INTEGRATION. For example:
CREATE OR REPLACE API INTEGRATION github_api_integration
API_PROVIDER = git_https_api
API_ALLOWED_PREFIXES = ('https://github.com/your-profile/')
ALLOWED_AUTHENTICATION_SECRETS = (course_repo.public.github_pat)
ENABLED = TRUE;
Without providing the name (github_api_integration in this example), Snowflake will throw a syntax error.
The statement
is invalid because an object name is required right after CREATE OR REPLACE API INTEGRATION. For example:
Without providing the name (github_api_integration in this example), Snowflake will throw a syntax error.