Share post
Share post
Share post
Blog: Product
Ask questions first, sync data later: Omnata & Snowflake Intelligence deliver seamless AI
Ask questions first, sync data later: Omnata & Snowflake Intelligence deliver seamless AI



Snowflake |
Analytics
By:
8 December 2025
Snowflake Intelligence has just gone GA, and Omnata is thrilled to be a launch partner in APJ.
We are bringing Snowflake’s AI features to the forefront in the Omnata Native App for Snowflake. The new frontiers that Snowflake are opening give data and business teams alike the tools for faster decision making and more dynamic interactions between people, their data and what they understand about their organisations.
At Omnata, we are building and shipping for this new frontier.
When we began building an ETL platform on Snowflake we knew that data replication would be our first act, but the possibilities of a native app connected to the enterprise were far greater. Snowflake Intelligence is the beginning of this.
Omnata’s true native architecture is the easiest way to connect to data
Omnata is unique amongst integration platforms in that it runs as a true native app. This means, it has no infrastructure either inside or outside of Snowflake and this delivers key benefits over the alternatives.
Get started in minutes
More deeply connected to Snowflake
Enable all types of users
Accelerating the traditional data integration process
The first act of any integration tool has been to land data in Snowflake.
Whether you use an external SaaS tool like Fivetran, or the newly launched Snowflake Openflow, these traditional data pipeline tools are built with ingesting data as their sole specialized task. They are not connected to the endpoint in a flexible and dynamic way, the endpoints simply contain the data which needs to be moved from point A to point B.
And the data engineering process that these tools were built around fits, as such.
First one needs to understand the business questions that their customers are asking. They research the source, scope out the object model, and begin to iterate on the downstream products that answer those questions. While leaps and bounds have been made in recent years, the process still has considerable lead time and cycle times slow down decision making.
Omnata + Snowflake Intelligence flips this process on its head.
Omnata + Snowflake Intelligence flips this on its head
Omnata’s architecture as a native app is more connected to both Snowflake and your application endpoints.
Now all you need to do is create a connection in Omnata, and you can immediately ask questions directly from your connected endpoint. How does Omnata do this?
Omnata already ships the full suite of integration capabilities with the Sync Engine and its Plugins (Connectors):
Automated data ingestion; the easiest way to pull data from your sources
Reverse ETL; production-ready to your target endpoints with built-in change management
Plugin functions; the building blocks for AI, custom operations and automation to/from your endpoints
Omnata accelerates with AI
Omnata (will soon) work with Snowflake Intelligence in two powerful modes:
Live-query mode - uses Omnata functions to query endpoints in real-time.
Semantic view mode - queries landed data using Omnata’s AI-ready semantic models for each endpoint

Real-Time Queries (Coming soon)
Ask questions directly to your connected applications without landing any data. Omnata's live-query functions act as wrappers around your native CRM, service desk, or project management APIs, providing a seamless conduit between Snowflake Intelligence and your enterprise data.
Use this when you need:
Instant answers without waiting for production data pipelines
To explore an endpoint before committing to a full integration
Up-to-the-second insights from rapidly changing data
Automated Semantic Views (Coming soon)
For data you've already synced, Omnata automatically creates semantic views that Snowflake Intelligence can understand. We fetch and apply metadata directly from your connected endpoints, so the AI knows what your data means without manual configuration.
Use this when you need:
Complex queries across multiple landed datasets
Historical trend analysis
Data that's been enriched and transformed
Maximum granularity and query performance
Use cases
The possibilities of Snowflake Intelligence are truly endless, but here are some examples connected to a Salesforce sandbox.
For Data Teams
"What objects exist in our Salesforce environment?" Before building any pipelines, use Omnata's live-query functions to explore connected endpoints. See what's available, understand data structures, and make informed decisions about what to sync.
"How can I analyse sales in the CRM?" Ask real-time research questions that leverage the general knowledge of LLMs with the context of your live environment.

For Business Performance & Understanding
"What are our top support tickets this week?" Connect Zendesk or Jira and ask Snowflake Intelligence directly. No need to wait for nightly data refreshes or understand table structures.
"Show me deals closing this quarter." Query your CRM in real-time while analysts work with historical data in the warehouse. Get the best of both worlds.
"What is the…" Connect collaboration tools like Monday.com, Airtable, and Confluence to centralize organizational intelligence. Ask questions across wikis, project boards, and documentation without switching contexts.
“Tell me why people contact us”

How it works
We created a connection to our Salesforce environment using Omnata
The Omnata Salesforce Plugin ships with live-query functions via Snowflake UDFs that reference connections created in Omnata
Omnata also ships a Snowflake Intelligence agent (coming soon) that knows how to use the Omnata UDFs
Snowflake Intelligence combines our instructions with its general knowledge of the Salesforce CRM and SOQL language to operate our functions.
These seemingly simple questions would be complex to build and deliver as a traditional data pipeline and product. However, this was answered in about 30 seconds! It illustrates how quickly Omnata’s direct connect architecture is supercharged by Snowflake Intelligence.
Data teams can deliver incremental result to their customers much faster dramatically speed up cycle times.
By the way, the answer is correct! Salesforce is our most popular connector and those are the main reasons we get inbound enquiries.
What about other apps and databases?
While this preview example focuses primarily on Salesforce as a source/target, we already ship and will continue to ship these features across all of our connectors.
Accelerate AI on enterprise app data
Modernize and expand your connectivity to your most complex enterprise platforms
Centralize organisational intelligence that resides in productivity workspaces
Connect to wikis, docs sites and productivity tools and built LLMs from the content.
Notion (coming soon)
Next Steps
Snowflake Intelligence represents a fundamental shift in how we interact with data and Omnata is poised to deliver more value than ever leveraging Snowflake’s latest AI features.
Ready to try it? We're opening preview access to both real-time query functions and automated semantic views. Reach out us to learn more.
Snowflake Intelligence has just gone GA, and Omnata is thrilled to be a launch partner in APJ.
We are bringing Snowflake’s AI features to the forefront in the Omnata Native App for Snowflake. The new frontiers that Snowflake are opening give data and business teams alike the tools for faster decision making and more dynamic interactions between people, their data and what they understand about their organisations.
At Omnata, we are building and shipping for this new frontier.
When we began building an ETL platform on Snowflake we knew that data replication would be our first act, but the possibilities of a native app connected to the enterprise were far greater. Snowflake Intelligence is the beginning of this.
Omnata’s true native architecture is the easiest way to connect to data
Omnata is unique amongst integration platforms in that it runs as a true native app. This means, it has no infrastructure either inside or outside of Snowflake and this delivers key benefits over the alternatives.
Get started in minutes
More deeply connected to Snowflake
Enable all types of users
Accelerating the traditional data integration process
The first act of any integration tool has been to land data in Snowflake.
Whether you use an external SaaS tool like Fivetran, or the newly launched Snowflake Openflow, these traditional data pipeline tools are built with ingesting data as their sole specialized task. They are not connected to the endpoint in a flexible and dynamic way, the endpoints simply contain the data which needs to be moved from point A to point B.
And the data engineering process that these tools were built around fits, as such.
First one needs to understand the business questions that their customers are asking. They research the source, scope out the object model, and begin to iterate on the downstream products that answer those questions. While leaps and bounds have been made in recent years, the process still has considerable lead time and cycle times slow down decision making.
Omnata + Snowflake Intelligence flips this process on its head.
Omnata + Snowflake Intelligence flips this on its head
Omnata’s architecture as a native app is more connected to both Snowflake and your application endpoints.
Now all you need to do is create a connection in Omnata, and you can immediately ask questions directly from your connected endpoint. How does Omnata do this?
Omnata already ships the full suite of integration capabilities with the Sync Engine and its Plugins (Connectors):
Automated data ingestion; the easiest way to pull data from your sources
Reverse ETL; production-ready to your target endpoints with built-in change management
Plugin functions; the building blocks for AI, custom operations and automation to/from your endpoints
Omnata accelerates with AI
Omnata (will soon) work with Snowflake Intelligence in two powerful modes:
Live-query mode - uses Omnata functions to query endpoints in real-time.
Semantic view mode - queries landed data using Omnata’s AI-ready semantic models for each endpoint

Real-Time Queries (Coming soon)
Ask questions directly to your connected applications without landing any data. Omnata's live-query functions act as wrappers around your native CRM, service desk, or project management APIs, providing a seamless conduit between Snowflake Intelligence and your enterprise data.
Use this when you need:
Instant answers without waiting for production data pipelines
To explore an endpoint before committing to a full integration
Up-to-the-second insights from rapidly changing data
Automated Semantic Views (Coming soon)
For data you've already synced, Omnata automatically creates semantic views that Snowflake Intelligence can understand. We fetch and apply metadata directly from your connected endpoints, so the AI knows what your data means without manual configuration.
Use this when you need:
Complex queries across multiple landed datasets
Historical trend analysis
Data that's been enriched and transformed
Maximum granularity and query performance
Use cases
The possibilities of Snowflake Intelligence are truly endless, but here are some examples connected to a Salesforce sandbox.
For Data Teams
"What objects exist in our Salesforce environment?" Before building any pipelines, use Omnata's live-query functions to explore connected endpoints. See what's available, understand data structures, and make informed decisions about what to sync.
"How can I analyse sales in the CRM?" Ask real-time research questions that leverage the general knowledge of LLMs with the context of your live environment.

For Business Performance & Understanding
"What are our top support tickets this week?" Connect Zendesk or Jira and ask Snowflake Intelligence directly. No need to wait for nightly data refreshes or understand table structures.
"Show me deals closing this quarter." Query your CRM in real-time while analysts work with historical data in the warehouse. Get the best of both worlds.
"What is the…" Connect collaboration tools like Monday.com, Airtable, and Confluence to centralize organizational intelligence. Ask questions across wikis, project boards, and documentation without switching contexts.
“Tell me why people contact us”

How it works
We created a connection to our Salesforce environment using Omnata
The Omnata Salesforce Plugin ships with live-query functions via Snowflake UDFs that reference connections created in Omnata
Omnata also ships a Snowflake Intelligence agent (coming soon) that knows how to use the Omnata UDFs
Snowflake Intelligence combines our instructions with its general knowledge of the Salesforce CRM and SOQL language to operate our functions.
These seemingly simple questions would be complex to build and deliver as a traditional data pipeline and product. However, this was answered in about 30 seconds! It illustrates how quickly Omnata’s direct connect architecture is supercharged by Snowflake Intelligence.
Data teams can deliver incremental result to their customers much faster dramatically speed up cycle times.
By the way, the answer is correct! Salesforce is our most popular connector and those are the main reasons we get inbound enquiries.
What about other apps and databases?
While this preview example focuses primarily on Salesforce as a source/target, we already ship and will continue to ship these features across all of our connectors.
Accelerate AI on enterprise app data
Modernize and expand your connectivity to your most complex enterprise platforms
Centralize organisational intelligence that resides in productivity workspaces
Connect to wikis, docs sites and productivity tools and built LLMs from the content.
Notion (coming soon)
Next Steps
Snowflake Intelligence represents a fundamental shift in how we interact with data and Omnata is poised to deliver more value than ever leveraging Snowflake’s latest AI features.
Ready to try it? We're opening preview access to both real-time query functions and automated semantic views. Reach out us to learn more.
Snowflake Intelligence has just gone GA, and Omnata is thrilled to be a launch partner in APJ.
We are bringing Snowflake’s AI features to the forefront in the Omnata Native App for Snowflake. The new frontiers that Snowflake are opening give data and business teams alike the tools for faster decision making and more dynamic interactions between people, their data and what they understand about their organisations.
At Omnata, we are building and shipping for this new frontier.
When we began building an ETL platform on Snowflake we knew that data replication would be our first act, but the possibilities of a native app connected to the enterprise were far greater. Snowflake Intelligence is the beginning of this.
Omnata’s true native architecture is the easiest way to connect to data
Omnata is unique amongst integration platforms in that it runs as a true native app. This means, it has no infrastructure either inside or outside of Snowflake and this delivers key benefits over the alternatives.
Get started in minutes
More deeply connected to Snowflake
Enable all types of users
Accelerating the traditional data integration process
The first act of any integration tool has been to land data in Snowflake.
Whether you use an external SaaS tool like Fivetran, or the newly launched Snowflake Openflow, these traditional data pipeline tools are built with ingesting data as their sole specialized task. They are not connected to the endpoint in a flexible and dynamic way, the endpoints simply contain the data which needs to be moved from point A to point B.
And the data engineering process that these tools were built around fits, as such.
First one needs to understand the business questions that their customers are asking. They research the source, scope out the object model, and begin to iterate on the downstream products that answer those questions. While leaps and bounds have been made in recent years, the process still has considerable lead time and cycle times slow down decision making.
Omnata + Snowflake Intelligence flips this process on its head.
Omnata + Snowflake Intelligence flips this on its head
Omnata’s architecture as a native app is more connected to both Snowflake and your application endpoints.
Now all you need to do is create a connection in Omnata, and you can immediately ask questions directly from your connected endpoint. How does Omnata do this?
Omnata already ships the full suite of integration capabilities with the Sync Engine and its Plugins (Connectors):
Automated data ingestion; the easiest way to pull data from your sources
Reverse ETL; production-ready to your target endpoints with built-in change management
Plugin functions; the building blocks for AI, custom operations and automation to/from your endpoints
Omnata accelerates with AI
Omnata (will soon) work with Snowflake Intelligence in two powerful modes:
Live-query mode - uses Omnata functions to query endpoints in real-time.
Semantic view mode - queries landed data using Omnata’s AI-ready semantic models for each endpoint

Real-Time Queries (Coming soon)
Ask questions directly to your connected applications without landing any data. Omnata's live-query functions act as wrappers around your native CRM, service desk, or project management APIs, providing a seamless conduit between Snowflake Intelligence and your enterprise data.
Use this when you need:
Instant answers without waiting for production data pipelines
To explore an endpoint before committing to a full integration
Up-to-the-second insights from rapidly changing data
Automated Semantic Views (Coming soon)
For data you've already synced, Omnata automatically creates semantic views that Snowflake Intelligence can understand. We fetch and apply metadata directly from your connected endpoints, so the AI knows what your data means without manual configuration.
Use this when you need:
Complex queries across multiple landed datasets
Historical trend analysis
Data that's been enriched and transformed
Maximum granularity and query performance
Use cases
The possibilities of Snowflake Intelligence are truly endless, but here are some examples connected to a Salesforce sandbox.
For Data Teams
"What objects exist in our Salesforce environment?" Before building any pipelines, use Omnata's live-query functions to explore connected endpoints. See what's available, understand data structures, and make informed decisions about what to sync.
"How can I analyse sales in the CRM?" Ask real-time research questions that leverage the general knowledge of LLMs with the context of your live environment.

For Business Performance & Understanding
"What are our top support tickets this week?" Connect Zendesk or Jira and ask Snowflake Intelligence directly. No need to wait for nightly data refreshes or understand table structures.
"Show me deals closing this quarter." Query your CRM in real-time while analysts work with historical data in the warehouse. Get the best of both worlds.
"What is the…" Connect collaboration tools like Monday.com, Airtable, and Confluence to centralize organizational intelligence. Ask questions across wikis, project boards, and documentation without switching contexts.
“Tell me why people contact us”

How it works
We created a connection to our Salesforce environment using Omnata
The Omnata Salesforce Plugin ships with live-query functions via Snowflake UDFs that reference connections created in Omnata
Omnata also ships a Snowflake Intelligence agent (coming soon) that knows how to use the Omnata UDFs
Snowflake Intelligence combines our instructions with its general knowledge of the Salesforce CRM and SOQL language to operate our functions.
These seemingly simple questions would be complex to build and deliver as a traditional data pipeline and product. However, this was answered in about 30 seconds! It illustrates how quickly Omnata’s direct connect architecture is supercharged by Snowflake Intelligence.
Data teams can deliver incremental result to their customers much faster dramatically speed up cycle times.
By the way, the answer is correct! Salesforce is our most popular connector and those are the main reasons we get inbound enquiries.
What about other apps and databases?
While this preview example focuses primarily on Salesforce as a source/target, we already ship and will continue to ship these features across all of our connectors.
Accelerate AI on enterprise app data
Modernize and expand your connectivity to your most complex enterprise platforms
Centralize organisational intelligence that resides in productivity workspaces
Connect to wikis, docs sites and productivity tools and built LLMs from the content.
Notion (coming soon)
Next Steps
Snowflake Intelligence represents a fundamental shift in how we interact with data and Omnata is poised to deliver more value than ever leveraging Snowflake’s latest AI features.
Ready to try it? We're opening preview access to both real-time query functions and automated semantic views. Reach out us to learn more.
subscribe
Deliver the goods to your inbox
subscribe
Deliver the goods to your inbox
subscribe