Snowflake

Overview

This section guides you through configuring and running the integration between Snowflake and NCP.

By following these steps, you'll enable NCP to:

• Fetch and index time-series data, application flows, and syslogs for analysis

• Enable natural language queries via NCP’s chat interface for troubleshooting, monitoring, and anomaly detection

• Improve operational visibility and enable real-time, data-driven decisions

Prerequisites

Before you begin, ensure you have the following:

• Snowflake Account Details

  • Snowflake URL (e.g., xyz.snowflakecomputing.com)

  • Account Name (e.g., xyz)

  • Warehouse, Database, and Schema names for query execution

• Snowflake Credentials

  • User credentials (username/password or other authentication methods such as OAuth)

Configure Snowflake as a Data Source in NCP

To connect NCP with your Snowflake instance, follow these steps:

1. Log in to the NCP GUI

2. Navigate to Settings → Data Sources → Snowflake

   
3. Click on Add Configuration

4. Enter the following details:

   • Name: A label for the Snowflake configuration (e.g., Snowflake-Prod-Cluster)

   • Account URL: Your Snowflake account URL

   • Username: Your Snowflake user

   • Password: Corresponding password

   • Warehouse: Compute the warehouse to use

   • Database: The target database

   • Table: Name of the table you wish to query

   • Schema: The Snowflake schema where your tables or logs reside

   
5. Click Save