Snowflake Intelligence

Use Snowflake Intelligence to explore your Hightouch models and audiences using natural-language questions powered by your warehouse.

Overview

Snowflake Intelligence is Snowflake’s Enterprise Intelligence Agent, conversational AI assistant that helps you explore warehouse data and connected systems using natural language.

By integrating Snowflake Intelligence with Hightouch, you can ask questions about your Customer Studio models, customer segments, activation campaigns, and audience performance directly from Snowflake.

This guide explains how to let Snowflake Intelligence fetch Hightouch model metadata (such as model name, description, and query type) using the Hightouch Models API.

Learning objectives

After reading this article, you’ll know how to:

• Understand how Snowflake Intelligence uses Hightouch model metadata
• Configure Snowflake to call the Hightouch Models API
• Test the connection from Snowflake
• Ask questions in Snowflake Intelligence about your Hightouch models and audiences

How Snowflake Intelligence works with Hightouch

Snowflake Intelligence can call external APIs using Snowflake’s External Access Integrations (EAIs).

When you authorize Snowflake to call the Hightouch Models API, Snowflake Intelligence can:

• Retrieve a list of your Hightouch models
• Identify which models power visual audiences
• Read model descriptions and query types
• Reference this metadata when answering user questions

Hightouch continues to remain the system of record for model definitions—Snowflake only receives the metadata needed to answer questions.

Example questions you can ask

Once connected, Snowflake Intelligence can answer questions such as:

• "What audiences have we built that target churned customers?"
• "Which segments am I sending to my email platform?"
• “Which of my audiences was updated most recently?”

Example setup: Calling the Hightouch Models API from Snowflake Intelligence

This example shows how to configure Snowflake Intelligence to call the Hightouch Models API.

You can extend this pattern to connect Snowflake Intelligence with other Hightouch APIs like our Destinations API for activation insights or Events API for real-time customer behavior, creating a comprehensive conversational interface.

1. Use a Snowflake role with integration privileges

USE ROLE ACCOUNTADMIN;
USE DATABASE DEMO_DB;
USE SCHEMA PUBLIC;

2. Create a network rule

Allows Snowflake to connect to the Hightouch API.

CREATE OR REPLACE NETWORK RULE hightouch_rule
  MODE = egress
  TYPE = host_port
  VALUE_LIST = ('api.hightouch.com:443');

3. Create a secret with your Hightouch API key

CREATE OR REPLACE SECRET hightouch_api_key
  TYPE = generic_string
  SECRET_STRING = '<API_KEY>';

4. Create the External Access Integration

CREATE OR REPLACE EXTERNAL ACCESS INTEGRATION hightouch_eai
  ALLOWED_NETWORK_RULES = (hightouch_rule)
  ALLOWED_AUTHENTICATION_SECRETS = (hightouch_api_key)
  ENABLED = TRUE;

5. Create a stored procedure to call the Hightouch Models API

CREATE OR REPLACE PROCEDURE CALL_HIGHTOUCH_API()
RETURNS STRING
LANGUAGE PYTHON
RUNTIME_VERSION = '3.10'
PACKAGES = ('requests','snowflake-snowpark-python')
EXTERNAL_ACCESS_INTEGRATIONS = (HIGHTOUCH_EAI)
SECRETS = ('cred' = HIGHTOUCH_API_KEY)
HANDLER = 'main'
AS
$$
import _snowflake
import requests
import json

def main():
    """
    Calls the Hightouch models endpoint
    """
    api_key = _snowflake.get_generic_secret_string('cred')
    url = "https://api.hightouch.com/api/v1/models"
    headers = {
        "Authorization": f"Bearer {api_key}",
    }

    try:
        resp = requests.get(url, headers=headers, timeout=30)
        resp.raise_for_status()
        return json.dumps(resp.json())
    except Exception as e:
        return f"Error: {str(e)}"
$$;

6. Test your connection

CALL CALL_HIGHTOUCH_API();

You should receive a JSON list of your Hightouch models.

Enable Snowflake Intelligence to use the procedure

Create a Snowflake Intelligence agent that can call the stored procedure.

CREATE OR REPLACE AGENT hightouch_agent
WITH PROFILE='{ "display_name": "Hightouch Agent" }'
COMMENT=$$ Enables users to interact with the Hightouch API $$
FROM SPECIFICATION
$$
{
  "models": { "orchestration": "auto" },
  "orchestration": {},
  "instructions": {
    "orchestration": "This is a simple agent for general knowledge with access to the Hightouch API"
  },
  "tools": [
    {
      "tool_spec": {
        "type": "generic",
        "name": "hightouch_models",
        "description": "{\n \"name\": \"hightouch_models\",\n \"description\": \"Fetch Hightouch models. If the user asks about audiences, they are referring to models with query_type = 'visual'\",\n \"parameters\": { \"type\": \"object\", \"properties\": {}, \"required\": [] },\n \"example_payload\": {},\n \"stored_proc_call\": \"CALL CALL_HIGHTOUCH_API();\"\n }",
        "input_schema": { "type": "object", "properties": {}, "required": [] }
      }
    }
  ],
  "tool_resources": {
    "hightouch_models": {
      "execution_environment": { "type": "warehouse", "warehouse": "" },
      "identifier": "DEMO_DB.PUBLIC.CALL_HIGHTOUCH_API",
      "name": "CALL_HIGHTOUCH_API",
      "type": "procedure"
    }
  }
}
$$;

Troubleshooting

What’s next

• Explore your Hightouch models →
• Learn more about the Hightouch Models API →
• Review Snowflake’s guide to Snowflake Intelligence →