We should have some tasks in the task library that interface with Snowflake using https://docs.snowflake.net/manuals/user-guide/python-connector.html
Opening this issue even thought I am unaware of the _exact_ tasks we want but we can track it here
cc @cicdw
joshmeek
All 5 comments
Hi. We have a use case for this internally. I'm happy to add the SnowflakeQuery and SnowflakeScript Tasks in tasks/database similar to the SQLite ones if there's interest in having it upstream
akravetz
on 8 Aug 2019
@akravetz There is definitely interest! It would be awesome if you would like to contribute to the task library. Let us know if you have any questions along the way!
joshmeek
on 8 Aug 2019
Yup! We have a few Cloud customers that are working with Snowflake so I'm confident if you get the ball rolling you'll have some help building those tasks out very quickly.
jlowin
on 8 Aug 2019
Pull request is open: https://github.com/PrefectHQ/prefect/pull/1343
akravetz
on 10 Aug 2019
Looks like this is done, closing.
lauralorenz
on 1 Apr 2020
Related issues
rej-jsa
路
4Comments
petermorrow
路
3Comments
ludwigm
路
3Comments
GZangl
路
3Comments
jameslamb
路
3Comments
Most helpful comment
Hi. We have a use case for this internally. I'm happy to add the
SnowflakeQueryandSnowflakeScriptTasks intasks/databasesimilar to the SQLite ones if there's interest in having it upstream