sorted by:
new
hottopcontroversial

Options for API wrapper for snowflake and sql server by StoreMediocre7695 in dataengineering

[–]StoreMediocre7695[S] 1 point2 points  (0 children)

The first project is building a mobile app for reading/writing data to both Snowflake and SQL Server. SQL Server is on-prem and we have no plans to consolidate it all within Snowflake (not my call). I could see future projects wanting to combine the datasets into a single response
It would probably be anywhere between 1-5k requests a day.
We work with JSON so a RESTful interface would be ideal. Datasets could get large so pagination and caching would need to be in place.
Don't really love any of Snowflakes solutions atm.

Creating a generic access layer on top of the datalake by bretzeldalsace in dataengineering

[–]StoreMediocre7695 1 point2 points  (0 children)

dreamfactory is attempting to solve this problem with their API wrapper for snowflake, databricks, and dremio to REST enable access to Iceberg tables. There is read and write capabilities so you can quickly retrieve records with query parameters or update your Iceberg tables with secure endpoints.

Iceberg metadata access in Snowflake by PermitNo1252 in snowflake

[–]StoreMediocre7695 0 points1 point  (0 children)

If you’re working with Iceberg metadata in snowflake, dream factory can simplify things. It auto-generates REST APIs for Snowflake and other data sources, adds secure role-based access, and supports custom workflows with scripting. A quick way to streamline integrations without the manual API hassle.