Oliver Mannion
Oliver Mannion
I've not yet given this much thought and yes a PR would be great, thank you @mikavilpas !
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 nice project, thanks for sharing! Glad you found fakesnow useful. Coincidentally I've just started to build out a [server with a V1 API](https://github.com/tekumara/fakesnow/blob/main/fakesnow/server.py). It's not complete yet, like yours....
Hi @tharwan this might be possible ... could you share example SQL statements you'd like support for, both creating the stage and loading from it?
Thanks! From the above I gather you want support for CSV files. I think creating the stage would be needed for fakesnow to know where to find the files to...
If the use-case were just testing then I thought for the first iteration of this we could just support a local file via a file:// url. It would avoid the...
Yes good point - if we transform a COPY INTO into a INSERT INTO .. SELECT in duckdb, then we could support both a file:// and s3:// url via the...
The same approach to fix #40 should work here if you'd like to have a go?
Ah right.. so we probably also need a transformation from `seq1.nextval -> nextval(seq1)`. fakesnow has a bunch of [specialised transformations](https://github.com/tekumara/fakesnow/blob/main/fakesnow/transforms.py) that live outside sqlglot.
Ah right. I've found the sqlglot folks receptive to PRs that add more precise parsing.