Snowflake Relational Data Source

Overview

This guide explains the steps to configure and enable a relational data source from Snowflake in FojiSoft for operational automation and data integration.

---

Steps to Configure a Snowflake Relational Data Source

1. Enable the Data Source
   • Toggle the Enabled switch to activate the data source configuration.
2. Name the Data Source
   • Enter a meaningful name for the data source in the Name field.
3. Set the Data Source Folder (Optional)
   • Specify the folder where this data source will be organized for better project management.
4. Connection Details
   • Select the appropriate Connection type from the dropdown. This includes selecting the Snowflake instance or connector already integrated within your FojiSoft environment.
   • If no connection exists, configure one in the integrations section of FojiSoft.
5. Define the Scan Interval
   • Enter the time interval (in minutes) for how often the system will scan and fetch data updates from the Snowflake database.
   • Example: 15 minutes.
6. Target Table
   • Select the Target Table in FojiSoft where the data will be stored or updated.
   • Use the Append Data to Table toggle if you want new data to append instead of overwriting existing records.
7. Create a Query
   • Write the SQL query in the Query field to specify the data to retrieve from Snowflake. Example:
   • Ensure the query is optimized for performance and tailored to your operational data needs.
8. Save and Activate
   • Review all configurations and click Save.
   • Once saved, the system will begin syncing data according to the specified scan interval and query.

---

Best Practices

• Query Optimization: Ensure your query retrieves only necessary data to optimize performance and reduce costs.
• Test Connections: Validate the Snowflake connection before assigning it to the data source to avoid configuration issues.
• Monitoring: Use FojiSoft's visualization tools to monitor the data flow and health of the source integration.
• Security: Follow role-based access controls and ensure sensitive data is encrypted or redacted where necessary.

---

Troubleshooting

• Connection Issues:
  • Verify Snowflake credentials and network access.
  • Test the Snowflake connector in the integrations section.
• Data Retrieval Errors:
  • Review the query syntax.
  • Check for table existence or permission issues in Snowflake.

---

This configuration enables seamless integration between Snowflake and FojiSoft for operational data automation, enhancing data-driven decision-making. For more information, refer to the FojiSoft documentation or contact support.