In today’s data-driven world, enterprises need more than just access to data, they need the ability to turn data into insight, and insight into action. Application experiences are only as powerful as the data that fuels them. Whether it’s building real-time dashboards, enabling contextual search, or powering intelligent workflows, developers need access to fast, secure, and scalable data infrastructure. That’s where the integration between Snowflake and Volt MX comes in.
Whether you’re building intelligent dashboards, powering personalized experiences, or automating workflows, Volt MX now makes it easier than ever to connect to Snowflake’s powerful data cloud, right from within your enterprise applications using pre-built adapters and backend services available in the Volt MX Marketplace.
With these latest integration capabilities, organizations can now connect with Snowflake more easily, making it simpler to leverage data for scalable and intelligent application development.
Why Integrate Snowflake with Volt MX?
Snowflake is a powerful data cloud platform used by enterprises to store, process, and analyze vast amounts of structured and semi-structured data. Volt MX is a unified low-code platform built to streamline enterprise app development across mobile, web, tablet, desktop, wearables and more.
Bringing the two together allows developers to:
- Seamlessly access Snowflake data in real-time.
- Build data-rich app experiences with minimal backend effort.
- Unlock AI-powered capabilities like semantic search.
- Ensure security and scalability with OAuth 2.0 and governed access.
The integration empowers business and technical teams alike to move faster, from ideation to impact.
Integration Options
Volt MX now offers three powerful integration capabilities that enable direct access to Snowflake’s rich data ecosystem.
1. Backend Service for Snowflake SQL API
This service provides a direct connection to Snowflake’s SQL REST API, allowing users to execute SQL queries and manage Snowflake data. With this backend service, developers can connect to Snowflake’s SQL API to:
- Perform SQL queries directly on Snowflake data.
- Read, write, and use data from Snowflake in your application.
- Manage deployments (e.g., provision users, roles, create tables).
- Submitting SQL statements for execution.
- Checking and managing statement execution status.
- Cancelling SQL queries when needed.
It’s ideal for applications that need real-time data access and full control over database interactions.
Marketplace link: Snowflake SQL API
2. Data Adapter for Snowflake Cortex Search
This adapter integrates with Snowflake Cortex, enabling apps to tap into advanced, AI-powered search capabilities within your Snowflake data environment.
Leveraging Snowflake Cortex Search API, this adapter helps to develop custom applications and integrations that:
- Perform queries using specific search services within databases and schemas.
- Retrieve metadata to manage and explore your deployment, such as available databases and schemas.
Marketplace link: Snowflake Cortex Search
3. Data Adapter for Snowflake Table API
This adapter supports a robust Table API, enabling various table operations:
- List tables: Lists the tables under the database and schema
- Create a table: Create a table.
- Fetch a table: Fetch a Table using the describe command output.
- Clone table: Create a new table by cloning from the specified resource
- Create a (or alter an existing) table: Create a (or alter an existing) table. Even if the operation is just an alter, the full property set must be provided.
- Delete a table: Delete a table with the given name.
Marketplace link: Snowflake Table API
Real-World Examples
These integrations empower developers with direct and efficient ways to interact with Snowflake, enhancing application capabilities through streamlined data access and advanced search functionalities within Volt MX.
Businesses across industries—such as finance (risk analysis), healthcare (patient insights), retail (personalized recommendations), and many others, including manufacturing, logistics, and telecommunications—can leverage this integration to build data-driven, high-performance applications.
Some use-cases are:
- Real-Time Analytics Dashboards: Deliver interactive, real-time data-rich insight/dashboards powered by Snowflake, helping stakeholders make informed data-driven decisions on the go.
- AI-Powered Search in Apps: Utilise Snowflake Cortex to deliver intelligent, contextual search capabilities in customer-facing applications, enhancing discoverability and personalisation.
- Automated Workflows: Connect workflows to real-time Snowflake data, for example, automating alerts, escalations, or form pre-fill logic based on stored values.
- Retail & Inventory Optimization: Access real-time inventory, orders, and customer trends from Snowflake within a custom retail app.
- Healthcare Insights: Utilise Snowflake data to populate personalised patient dashboards, analytics views, or medication alerts within clinical applications.
How the Integration Works
The integration setup is done inside Volt Foundry, the backend engine of Volt MX. Here’s a quick overview of the process:
Step 1: Set Up Your Snowflake Environment
- Create a Snowflake account (free trial or production)
- Set up your database architecture: warehouse, database, schema, and table
- Add sample data to simulate real use cases
Step 2: Establish Secure Connection via OAuth 2.0
To securely connect Volt MX with Snowflake:
- Create an Identity Service in Volt Foundry using OAuth 2.0.
- Generate the Authorization Endpoint, Token Endpoint, Client ID, and Client Secret using SQL scripts in Snowflake.
- Link these values in Foundry and test the connection
- Once successful, you’ll receive a secure Bearer token for authenticated API access
Note: Volt Foundry supports multiple identity providers, you’re free to use any identity service that fits your organisation’s needs.
Step 3: Import & Configure Data Adapters
Download the appropriate adapter/service from the Volt MX Marketplace:
- Snowflake SQL API (backend service)
- Snowflake Cortex Search Adapter
- Snowflake Table API Adapter
Import them into Foundry and configure:
- Open the specific app you’re working on and create a new Integration Service using the imported adapter
- Link the app to the identity service you configured earlier.
- Go to the Operations List tab to define operations: set input parameters, headers, and expected outputs
- In the Request Input > Header section, add the Bearer token (from the Identity Service) and set the User-Agent (usually your app name)
- Click Save and Add Operation to view the output.
With that, your app’s backend is now securely connected to Snowflake.
Step 4: Connect to Your Volt Iris Apps
- Associate your Foundry app with a Volt Iris project
- Drag and drop services into the UI or use controller code
- Customize logic using the Action Editor or your own JavaScript
- Build the UI and test your app
That’s it, your app now has a secure, scalable connection to Snowflake, with full search, query, and data management capabilities built right in.
Watch the Tutorial: Step-by-Step Demo
We’ve put together a comprehensive YouTube walkthrough that guides you through the full integration, from setting up Snowflake to building your Volt MX app.
In this tutorial, you’ll learn how to:
- Set up your Snowflake environment
- Configure OAuth 2.0 Identity Services in Volt Foundry
- Use the SQL API, Cortex Search and Table API backend service/data adapters.
- Connect and consume Snowflake data within your Volt MX app
Watch the tutorial here.
Note: This video uses a demo setup with sample data. For production environments, always follow your organization’s security policies and configure proper access controls.
Ready to Get Started?
With Volt MX’s new integration capabilities, accessing and utilizing Snowflake’s enterprise-grade data is faster and easier than ever. Whether you’re building internal business tools, customer-facing apps, intelligent search features or automating workflows, you can now deliver smarter features backed by real-time data with ease.
Ready to unlock the power of Snowflake in Volt MX?
Get started today by exploring these integrations on the Volt MX Marketplace: