def get_api_integration_info_for_policy()

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
    }