Snowflake
Introduction
Hasura supports connecting to a Snowflake service to automatically build a GraphQL API based on its schema.
- Hasura GraphQL Engine
v2.24.0onwards
Get Started
To try Hasura with Snowflake, you'll need a new or existing Snowflake instance.
Here are 2 ways you can get started with Hasura and Snowflake:
- Hasura Cloud: You'll need to be able to access your Snowflake instance service from Hasura Cloud.
- Docker: Run Hasura with Docker and then connect your Snowflake instance to Hasura.
Feature Support
| Feature | Snowflake |
| Remote Relationships | ✅ |
| Views | ✅ |
| Default Values | ✅ |
| Custom Functions | ✅ |
| Logical Models | ✅ |
| Native Queries | ✅ |
Queries
| Feature | Snowflake |
| Simple | ✅ |
| Nested Object | ✅ |
| Aggregation | ✅ |
| Filter / Search | ✅ |
| Sort | ✅ |
| Distinct | ✅ |
| Paginate | ✅ |
| Multiple Arguments | ✅ |
| Multiple Queries | ✅ |
| Variables / Aliases / Fragments | ✅ |
Mutations
| Feature | Snowflake |
| Insert | ❌ |
| Upsert | ❌ |
| Update | ❌ |
| Delete | ❌ |
| Multiple per Request | ❌ |
Subscriptions
| Feature | Snowflake |
| Value of Field | ❌ |
| Updates to Rows | ❌ |
| Value of Derived Field | ❌ |
| Streaming Subscriptions | ❌ |
Event Triggers
| Feature | Snowflake |
| INSERT | ❌ |
| UPDATE | ❌ |
| DELETE | ❌ |
| MANUAL | ❌ |
Managing data with the Hasura Console
The Hasura Console is a web UI that allows you to manage your data and metadata. It is available at
http://localhost:8080/console when you run Hasura locally, or from your project's Console endpoint when you use
Hasura Cloud.
The data-management features (such as creating tables) are available in the Data tab. You can access your GraphQL API
in the API tab and interact with it using the GraphiQL interface.
We recommend using your preferred Snowflake client instead. The Hasura Console is designed to be a tool for managing your GraphQL API, and not a full-fledged database management tool.
Keep up to date
Currently, Hasura supports read-only queries, subscriptions, relationships, and permissions on Snowflake.
If you'd like to stay informed about the status of Snowflake support, subscribe to our newsletter and join our discord!
