Hasura GraphQL APIs for Snowflake Streamline built-in analytics and accelerate data access
SAN FRANCISCO, December 7, 2022 — GraphQL innovator Hasura has announced a new integration for Snowflake that allows joint customers to instantly create a GraphQL data API on the Snowflake Cloud Data Platform. Available today in beta for Hasura Cloud and Enterprise users, this read-only integration significantly reduces the time required to connect multiple data sources, accelerates embedded analytics for customer-facing applications, and enables rapid development of internal applications and integrations that leverage Snowflake Aggregated Data.
“One of the benefits of using Snowflake is that it easily integrates with a variety of tools and frameworks, giving organizations more flexibility in choosing how to build their applications,” said Paul Nashawaty, senior analyst, ESG. “However, using Snowflake with multiple data sources can be challenging due to the need to keep track of all the different types of data stored in each file. Because each type of data source has its own file format, each file must be read differently when parsed. Hasura -integration with Snowflake gives users the ability to streamline requests and output, save time and money and increase productivity.”
With Hasura GraphQL, data APIs can be set up quickly and easily without having to write a single line of code. With just a few clicks, users can connect Hasura to Snowflake and generate fast and secure APIs to deliver data to internal/external consumers and applications. Hasura enables users to leverage the data stored in Snowflake in new and innovative ways by making data more accessible and easier to work with, allowing them to unlock more value from their data investments. Additionally, because Hasura automatically generates documentation for users’ APIs, it’s easy for developers to start working with this data right away, eliminating hours of training. Snowflake integration builds on existing Hasura support for data sources including PostgreSQL, SQL Server, Google BigQuery, Amazon Athena, and CockroachDB.
Examples of applications include:
- Superficial analysis data in customer-facing and internal apps: Development teams can quickly build a GraphQL API for Snowflake that efficiently serves data from multiple tables, all within a single query, instead of doing multiple fetches to individual tables. This allows developers to efficiently deliver Snowflake data to mobile and web applications, while saving countless hours writing additional APIs and queries required to access that data.
- Share Snowflake data with internal and external consumers via APIs: Data teams can create APIs to open Snowflake data to a wider set of internal and external stakeholders. Sharing data via APIs is a more secure and controlled way to open data access compared to alternatives, especially in regulated environments. With the Hasura connector, customers can now generate and secure these APIs in a fraction of the time it would otherwise take.
- Merging data from Snowflake and other sources: Customers now have an easy and efficient way to merge Snowflake data with data from other sources (databases, warehouses, third-party APIs, etc.). For example, if a company needs to map order data in Snowflake and shipment data in PostgreSQL during order fulfillment, they can do so easily because the Hasura GraphQL Engine supports these data sources and GraphQL connections across sources.
A major challenge when working with multiple data sources is that each data source may have different security protocols in place, making it difficult to give users access to all the data they need without compromising security. To alleviate this problem, all requests to the Hasura API are encrypted by default, with the platform also offering granular data access control. By using Hasura’s GraphQL Data APIs, organizations are able to create a unified data access platform across all of Hasura’s supported databases as well as other GraphQL and REST services.
“Accessing data – both application-wise and analytically – over an API not only helps accelerate development time, but also significantly increases data security,” said Hasura Co-founder and CEO Tanmai Gopal. “The innovations we announced today allow Snowflake users to quickly provide secure API access to their data and eliminate expensive consultants or months spent writing code to generate, secure and deploy APIs. With Hasura GraphQL APIs, all of this work is done for you so you can focus on what’s important – running your business.”
Hasura is helping to build the modern world of globally relevant, data-driven applications and APIs. Hasura’s range of data access solutions help organizations accelerate product delivery by instantly connecting data and services to applications with GraphQL APIs. Open sourced in July 2018, Hasura is used by tens of thousands of developers as the data access layer for modern applications. Hasura has also seen adoption across Fortune 500 companies, fast-growing startups and product development agencies. We are a globally distributed team, with offices in San Francisco and Bangalore.