AI Service Graph Connector for Snowflake
Summarize
Summary of AI Service Graph Connector for Snowflake
The AI Service Graph Connector for Snowflake integrates your Snowflake environment with ServiceNow AI Control Tower, enabling automated discovery, import, and management of AI assets such as Cortex agents, models, and prompts. It collects usage data and provides visibility into AI operations through dashboards, supporting governance and lifecycle tracking.
Show less
Key Features
- Automated discovery of Cortex agents and AI models within Snowflake.
- Monitoring and metadata capture for fine-tuning jobs.
- Tracking of AI asset lineage and dependencies.
- Analytics on AI usage and session monitoring.
- Integration with the ServiceNow CMDB to maintain a comprehensive AI asset inventory.
- Support for multi-account Snowflake deployments, enhancing scalability and flexibility.
Prerequisites and Setup
ServiceNow Setup: Requires roles snaidisc.discoveryadmin and sncmdbintutil.sgcadmin. Initial setup involves updating data source access permissions to allow creation and modification of data sources, and clearing cache using background scripts to ensure data consistency.
Snowflake Setup: Requires creation of a dedicated service account with least-privilege access and a specific connector role granted permissions such as USAGE on relevant databases and schemas, and Cortex access privileges. The connector uses JWT key-pair authentication, which requires generating RSA key pairs and configuring Snowflake user profiles accordingly.
Network and Account Configuration: ServiceNow instance IP addresses must be allowed in Snowflake network policies. Snowflake account identifiers must be formatted in lowercase-digit-hyphen (LDF) format for API compatibility; otherwise, use the account locator instead.
Data Integration and Mapping
The connector imports AI asset data from Snowflake into ServiceNow by mapping Snowflake tables into corresponding CMDB and custom tables, such as AI models, prompts, datasets, and system components. It also captures AI usage data for operational insights.
Benefits for ServiceNow Customers
- Gain centralized visibility and governance over AI assets and operations within your Snowflake environment.
- Leverage automated asset discovery and lineage tracking to maintain accurate and up-to-date AI inventories.
- Utilize usage analytics for monitoring AI performance and optimizing resource utilization.
- Ensure secure and compliant integration through least-privilege service accounts and key-pair authentication.
The AI Service Graph Connector for Snowflake enables you to discover and import AI assets from your Snowflake environment into ServiceNow AI Control Tower.
The connector integrates with your Snowflake account to catalog AI systems, agents, models, and prompts. Usage data is automatically collected and populated into the AI Control Tower value dashboard, providing comprehensive visibility and governance of your AI operations.
Key capabilities:
- Automated discovery of Cortex agents and models.
- Fine-tuning job monitoring and metadata capture.
- AI asset lineage and dependency tracking.
- Usage analytics and session monitoring.
- Integration with ServiceNow CMDB for comprehensive asset management.
- Support for multi-account Snowflake deployments.
Download apps from the Store
Visit the ServiceNow store website to download the AI Service Graph Connector for Snowflake application.
Supported ServiceNow versions
| Release | Status |
|---|---|
| Australia | Supported |
| Zurich | Supported |
User Roles
You must have one of the following roles assigned.
| Required Roles |
|---|
| sn_ai_disc.discovery_admin |
| sn_cmdb_int_util.sgc_admin |
ServiceNow Prerequisites
Complete the following setup steps once when configuring the connector for the first time.
The connector requires write permissions to the Data Source table to create data sources.
- Select Global from the application picker.
- Navigate to Application Access.
- Select the Can create, Can update, and Can delete check boxes.
- Select Update.
- Switch to the connector application scope.
Clear the cached data for the Data Source and Tables.
- Navigate to .
- Enter the following script in the Run Script text box:
GlideTableManager.invalidateTable('sys_data_source'); GlideCacheManager.flushTable('sys_data_source'); GlideTableManager.invalidateTable('sys_db_object'); GlideCacheManager.flushTable('sys_db_object'); - Select Run Script.Note:The script might take several minutes to complete. After completion, switch to the connector application scope.
- After completion, switch to the connector application scope.
Snowflake Prerequisites
To configure a Snowflake service user for Key-Pair Authentication instead of a Programmatic Access Token (PAT), generate an RSA key pair and assign the public key to a Snowflake user profile.
Verify that the user's Authentication Policy allows key-pair connections.
Complete the following configuration steps in your Snowflake environment before creating a connection.
We should always use the following format for connection url:
- https://<account_identifier>.snowflakecomputing.com
- If account identifier contains uppercase letters or special characters, use your account locator in connection URL as follows https://<account_locator>.snowflakecomputing.com
If your account identifier contains uppercase letters or special characters, use your account locator (for example, xy12345) instead. Your account locator is always LDF-safe.
Service Account and Role Configuration
Create a dedicated service account in Snowflake with least-privilege access. The connector requires specific permissions to query Cortex agents, models, and observability data.
Create role for the connector and grant the following privileges:
Core Discovery Access:
- GRANT USAGE ON DATABASE <database_name>
- GRANT USAGE ON SCHEMA <schema_name>
- GRANT MANAGE ACCOUNTS
- GRANT DATABASE ROLE SNOWFLAKE.CORTEX_USER
Create a service account user and assign the connector role:
- CREATE USER <service_account_name> TYPE=SERVICE
- GRANT ROLE <connector_role> TO USER <service_account_name>
- ALTER USER <service_account_name> SET DEFAULT_WAREHOUSE = <warehouse_name>
The connector uses JWT key-pair authentication to securely connect to Snowflake.
For detailed steps on generating RSA key pairs and configuring key-pair authentication in Snowflake, see Configuring Keystore for Snowflake Keypair authentication [KB2834688] article in the Now Support Knowledge Base.
Data Mapping
The connector maps Snowflake AI assets to ServiceNow CMDB tables and custom tables for comprehensive asset management.
| Data Source | Import Set Table | Target Table(s) |
| SG-Snowflake Agents | sn_ai_disc_sgc_sno_sgc_snowflake_agents |
cmdb_ci_function_ai cmdb_ci_ai_model_deployment cmdb_ai_model_product_model cmdb_ai_dataset_product_model cmdb_ai_prompt_product_model cmdb_ai_system_component_product_model alm_ai_model_digital_asset alm_ai_dataset_digital_asset alm_ai_system_digital_asset cmdb_ci_ai_model_deployment cmdb_rel_ci sn_ai_disc_ai_lineage sn_ai_disc_ai_tool sn_ai_disc_ai_prompt sn_ai_disc_ai_usage sn_ent_ai_system_subcomponent_m2m |
| SG-Snowflake Usage | sn_ai_disc_sgc_sno_sgc_snowflake_usage | sn_ai_disc_ai_usage |