in customer-stack/create-resources.py [0:0]
def get_api_integration_info_for_policy(snowflake_cursor, api_integration_name):
logger.info("Describing API Integration")
storage_user_arn = ''
storage_external_id = ''
snowflake_cursor.execute(("describe integration \"%s\"") % (api_integration_name))
rows = snowflake_cursor.fetchall()
for row in rows:
value = list(row)
if (value[0] == "API_AWS_IAM_USER_ARN"):
api_user_arn = value[2]
if (value[0] == "API_AWS_EXTERNAL_ID"):
api_external_id = value[2]
return {
SERVICE: "apigateway.amazonaws.com",
USER_ARN: api_user_arn,
EXTERNAL_ID: api_external_id
}