# HG changeset patch
# User Charles Julian Knight <julian@fixdapp.com>
# Date 1617846311 14400
#      Wed Apr 07 21:45:11 2021 -0400
# Node ID 1877b318c67a8058f296211dfd34b1de28e693e8
# Parent  b4d81daa2515ad7ab9e0def1dd2894f235e7b667
Support for snowflake connect parameters

For the snowflake database, I ended up needing to configure the role option.

This change passes all query options to 'snowflake.connector', allowing you
to set any of the parameters snowflake supports. The full list is available
here:

https://docs.snowflake.com/en/user-guide/python-connector-api.html#connect

Julian

diff -r b4d81daa2515 -r 1877b318c67a yoyo/backends.py
--- a/yoyo/backends.py	Tue Apr 06 12:39:58 2021 +0000
+++ b/yoyo/backends.py	Wed Apr 07 21:45:11 2021 -0400
@@ -791,7 +791,7 @@
             account=dburi.hostname,
             database=database,
             schema=schema,
-            warehouse=dburi.args["warehouse"],
+            **dburi.args,
         )
 
     def savepoint(self, id):

On 07/04/2021, Charles Julian Knight wrote:
># HG changeset patch
># User Charles Julian Knight <julian@fixdapp.com>
># Date 1617846311 14400
>#      Wed Apr 07 21:45:11 2021 -0400
># Node ID 1877b318c67a8058f296211dfd34b1de28e693e8
># Parent  b4d81daa2515ad7ab9e0def1dd2894f235e7b667
>Support for snowflake connect parameters
>
>For the snowflake database, I ended up needing to configure the role option.
>
>This change passes all query options to 'snowflake.connector', allowing you
>to set any of the parameters snowflake supports. The full list is available
>here:
>
Looks good, I just merged this. Thanks!

Olly.