Redirecting Queries from a Third-Party Service to 'fakesnow': Is it Possible?

[megetron3]

I am currently utilizing a third-party service that generates queries for Snowflake. I'm interested in redirecting these queries to the 'fakesnow' project. Specifically, I want to proxy all the Snowflake requests to 'fakesnow'.

The purpose of this operation is to enable end-to-end tests of the aforementioned service to run locally, rather than on AWS. Could you provide any guidance or steps on how to accomplish this?

[tekumara]

Fakesnow doesn’t yet provide an HTTP API which, without knowing anything about this third-party service, I would guess is what you want. It’s on the roadmap though.

[buremba]

@tekumara Thanks for creating this library! I was using this library but needed something similar so I built a proxy of V1 API by reverse engineering the Snowflake clients. I use Fakesnow for transpilation as well: https://github.com/buremba/universql

[tekumara]

@buremba nice project, thanks for sharing! Glad you found fakesnow useful.

Coincidentally I've just started to build out a server with a V1 API. It's not complete yet, like yours. Looks like we are both taking a similar approach 🙂

PS: localhostcomputing.com is a nice touch!