https://docs.foji.io/index.php?action=history&feed=atom&title=Snowflake_Metrics_Data_Source 2026-06-03T19:46:59Z Revision history for this page on the wiki MediaWiki 1.40.1 https://docs.foji.io/index.php?title=Snowflake_Metrics_Data_Source&diff=2538&oldid=prev 2024-12-09T18:19:38Z

<p>Snowflake metrics</p> <p><b>New page</b></p><div>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.<br /> ----<br /> <br /> == &#039;&#039;&#039;Data Source Setup: Maintenance Schedule&#039;&#039;&#039; ==<br /> <br /> === &#039;&#039;&#039;1. Data Source Configuration&#039;&#039;&#039; ===<br /> <br /> * &#039;&#039;&#039;Name&#039;&#039;&#039;:<br /> ** Enter a unique and descriptive name for your data source. <br /> * &#039;&#039;&#039;Maintenance Schedule&#039;&#039;&#039;<br /> ** Select a maintenance schedule from the dropdown if it applies. <br /> * &#039;&#039;&#039;Folders&#039;&#039;&#039;:<br /> ** Specify the target folder or group where this data source will be categorized. This field is optional unless organization within FojiSoft&#039;s system hierarchy is required.<br /> <br /> === &#039;&#039;&#039;2. Connection Settings&#039;&#039;&#039; ===<br /> <br /> * &#039;&#039;&#039;Connection&#039;&#039;&#039;:<br /> ** 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.<br /> ** If no connection is available in the dropdown, check the global connection settings or add a new Snowflake connection.<br /> * &#039;&#039;&#039;Scan Interval&#039;&#039;&#039;:<br /> ** Set the frequency at which the data source queries Snowflake for updated metrics.<br /> ** Default interval: &lt;code&gt;15 minutes&lt;/code&gt;. Adjust based on the criticality and refresh requirements of the monitored metrics.<br /> <br /> === &#039;&#039;&#039;3. Query&#039;&#039;&#039; ===<br /> <br /> * &#039;&#039;&#039;Query Editor&#039;&#039;&#039;:<br /> ** Define the SQL query to fetch the required data from Snowflake.<br /> ** This is a mandatory field, as indicated by the &quot;Query is required&quot; error. Ensure your SQL script:<br /> *** Selects the appropriate tables and columns relevant to your metrics.<br /> *** Aligns with the Snowflake schema and has correct privileges for data access.<br /> ** Example query:<br /> ** Test the query in Snowflake to validate before pasting it here.<br /> <br /> ----<br /> <br /> == &#039;&#039;&#039;Finalizing the Data Source&#039;&#039;&#039; ==<br /> <br /> * Toggle the &#039;&#039;&#039;Enabled&#039;&#039;&#039; switch to activate the data source. Once enabled, the data source will start querying metrics as per the defined interval and connection settings.<br /> * Click the &#039;&#039;&#039;Create&#039;&#039;&#039; button (visible at the top right in the UI) to save and activate your data source configuration.<br /> <br /> ----<br /> <br /> == &#039;&#039;&#039;Error Troubleshooting&#039;&#039;&#039; ==<br /> <br /> * &#039;&#039;&#039;&quot;Query is required&quot; Error&#039;&#039;&#039;:<br /> ** Ensure a valid SQL query is entered in the query field.<br /> ** Verify Snowflake connectivity and schema compatibility.<br /> * &#039;&#039;&#039;Connection Errors&#039;&#039;&#039;:<br /> ** Revisit the Snowflake connection settings in FojiSoft. Confirm that credentials and permissions are correctly set.<br /> <br /> ----This setup ensures that FojiSoft integrates seamlessly with Snowflake to extract, monitor, and visualize operational metrics effectively.<br /> [[Category:Settings]]</div>

Mitchell.Hirsche