Omnata has been working in close partnership with Snowflake in leveraging their new External Access feature which allows Omnata Sync to call out directly to SaaS application end-points. Omnata Sync is a first of its kind, fully native, two-way integration app for Snowflake.

Co-founder of Omnata, James Weakley, was quoted in this article by Snowflake.

Reverse ETL: Enables copying data from Snowflake to operational systems and SaaS tools, such as Slack, so that business teams can leverage data to personalize customer experiences or drive actions. Omnata uses External Access for this scenario: 

“External Access in Snowpark unlocks an enormous number of use cases for developers on the Snowflake Data Cloud, and is central to the functionality of our Native Application, Omnata Sync. Snowflake has simplified the process of connecting to external systems while maintaining the trusted perimeter that their customers rely upon.

By leveraging External Access with Snowpark, Omnata have launched the first fully native data integration product built on Snowflake which supports syncing data both to and from external Software-As-a-Service applications. Our customers have the convenience of running their data integration workloads from within their own Snowflake account, and they have full visibility and control of which external systems our native application is allowed to sync data with.” – James Weakley, Co-Founder, Omnata Co-founder

Building on top of the External Access feature, Omnata Sync provides all of the features customers expect of an ELT, ETL or Reverse ETL tool, such as;

• Inbound and outbound data syncs

• Data-warehouse native diff engine

• Scheduled runs, dbt integration & activity history

• Rate-limiting, retries and error handling

• Out-of-the-box plugins (connectors) and an open development framework

All of this is built using the Snowflake Native App Framework, secured and governed, and runs 100% inside your deployment.

Get in touch or start a 30-day free trial on the Snowflake Marketplace.