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:
15 minutes. 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.