View source for Snowflake Metrics Data Source

This document provides step-by-step guidance for configuring the Snowflake metrics data source in FojiSoft, based on the user interface elements visible in the provided screenshot.
----

== '''Data Source Setup: Maintenance Schedule''' ==

=== '''1. Data Source Configuration''' ===

* '''Name''':
** Enter a unique and descriptive name for your data source. 
* '''Maintenance Schedule'''
** Select a maintenance schedule from the dropdown if it applies. 
* '''Folders''':
** Specify the target folder or group where this data source will be categorized. This field is optional unless organization within FojiSoft's system hierarchy is required.

=== '''2. Connection Settings''' ===

* '''Connection''':
** Select a valid Snowflake connection from the dropdown menu. Ensure the connection is preconfigured in FojiSoft’s platform with appropriate authentication and access credentials. This is a required field.
** If no connection is available in the dropdown, check the global connection settings or add a new Snowflake connection.
* '''Scan Interval''':
** Set the frequency at which the data source queries Snowflake for updated metrics.
** Default interval: <code>15 minutes</code>. Adjust based on the criticality and refresh requirements of the monitored metrics.

=== '''3. Query''' ===

* '''Query Editor''':
** Define the SQL query to fetch the required data from Snowflake.
** This is a mandatory field, as indicated by the "Query is required" error. Ensure your SQL script:
*** Selects the appropriate tables and columns relevant to your metrics.
*** Aligns with the Snowflake schema and has correct privileges for data access.
** Example query:
** Test the query in Snowflake to validate before pasting it here.

----

== '''Finalizing the Data Source''' ==

* Toggle the '''Enabled''' switch to activate the data source. Once enabled, the data source will start querying metrics as per the defined interval and connection settings.
* Click the '''Create''' button (visible at the top right in the UI) to save and activate your data source configuration.

----

== '''Error Troubleshooting''' ==

* '''"Query is required" Error''':
** Ensure a valid SQL query is entered in the query field.
** Verify Snowflake connectivity and schema compatibility.
* '''Connection Errors''':
** Revisit the Snowflake connection settings in FojiSoft. Confirm that credentials and permissions are correctly set.

----This setup ensures that FojiSoft integrates seamlessly with Snowflake to extract, monitor, and visualize operational metrics effectively.
[[Category:Settings]]