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):

  1. Automated data ingestion; the easiest way to pull data from your sources

  2. Reverse ETL; production-ready to your target endpoints with built-in change management

  3. 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.

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):

  1. Automated data ingestion; the easiest way to pull data from your sources

  2. Reverse ETL; production-ready to your target endpoints with built-in change management

  3. 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.

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):

  1. Automated data ingestion; the easiest way to pull data from your sources

  2. Reverse ETL; production-ready to your target endpoints with built-in change management

  3. 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.

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

Deliver the goods to your inbox