DreamFactory & Snowflake

DreamFactory, a leader in API generation has officially became an integration partner of Snowflake, the Data Cloud company, to enable rapid, secure, and scalable API generation to securely serve data from the Snowflake Data Cloud anywhere.

A Better Way Of Data Extraction

The DreamFactory and Snowflake partnership streamlines API development for organizations utilizing Snowflake as their data warehouse. This integration boosts operational efficiency by simplifying workflows and strengthening the platform’s role within enterprise ecosystems.

DreamFactory generates full CRUD REST API endpoints for any Snowflake table, view, and stored procedure. We wrap every API in enterprise security and features like RBAC, API Key Management, Authentication, Rate Limiting, full swagger documentation.
‍
DreamFactory's secure API generation, complete with auto-generated documentation, ensures that APIs are not only quickly deployable but also secure and well-integrated into existing systems. DreamFactory enables developers to generate secure REST APIs to access Snowflake data tables efficiently. This capability allows seamless data access and integration without extensive coding.

Try it on Snowflake Marketplace
Let's examine the comparison below:

Traditional Reverse-ETL Pipeline Process

DreamFactory Automated API Generation

  • Extract, Transfer, Load: Developers must first set up ETL pipelines to move data from Snowflake into their own environments. This step often involves significant overhead in terms of configuration and maintenance.
  • API Development: Once the data is in place, developers need to manually code the APIs using API frameworks like Express.js, Django, Flask, or FastAPI. This includes designing the endpoints, handling security like key management, and ensuring scalability and performance, which requires deep technical expertise and considerable development time.
  • Documentation & Testing: After building the APIs, developers must create comprehensive documentation and conduct testing to ensure the APIs meet functional and security standards.
  • Maintenance: Post-deployment, continuous monitoring and maintenance of both the ETL processes and the APIs are required to handle any issues like schema changes in the data source, updates in business logic, or security vulnerabilities.
  • Direct Integration: DreamFactory integrates directly with Snowflake, eliminating the need for ETL pipelines to move data. This direct access reduces the infrastructure overhead and streamlines data handling.
  • Auto-generated Documentation: DreamFactory automatically generates and updates OpenAPI docs for all created APIs as endpoints change, streamlining compliance and reducing manual effort.
  • Automated API Generation: Developers can generate REST APIs automatically by configuring Snowflake data sources in DreamFactory. This process takes just a few clicks and includes setting up secure endpoints with required permissions, significantly cutting down the development time.
  • Built-in Security & Maintenance: DreamFactory ensures that APIs are secure by default, requiring API keys and implementing robust access controls. It also manages ongoing API versioning and updates, reducing the maintenance burden on developers.

    Related read: Build A Snowflake REST API in Less Than 5 minutes
Dec 2020
DreamFactory initiated the development of a REST API connector for Snowflake
Feb 2021
Our Snowflake connector was publicly released
Jun 2022
Our first customer started deploying DreamFactory for Snowflake connector
2022 - 2023
We started seeing a surge in user interest & adoption for Snowflake connector
April 2024
DreamFactory officially became Snowflake's official integration partner
May 2024
DreamFactory joined Snowflake Startup program

“This collaboration with DreamFactory underscores our shared motivation to enable organizations to get the most out of their data. 

By bringing DreamFactory’s API generation capabilities to the Data Cloud, we’re making it easier for our customers to overcome barriers to innovation and accelerate their digital transformation journey.”

Tarik Dwiek, Head of Technology Alliances, Snowflake.

October 2024
DreamFactory platform is officially available on Snowflake Marketplace

"By integrating DreamFactory's expertise in API generation into the Snowflake Data Cloud, we're offering a seamless solution that accelerates the application development process.

Our joint customers can now more easily mobilize their data with near-unlimited scale and performance to unlock new possibilities for innovation and growth."

Terence Bennett, CEO at DreamFactory

Check out Snowflake Marketplace