Snowflake not listed in py4web docs

[will...@gmail.com]

I see the Snowflake Adapter was added a few years ago  (Big thanks to kell...) , but it hasn't made it yet to the docs.

Is it now a recognised and supported Adapter in pydal ? 

Thanks

Andrew

[Massimo DiPierro]

Honestly I do not know. I never tested myself and never got an independent verification that it works.

Would be great if you could help test it.

[will...@gmail.com]

Thanks Massimo.

OK, I am attempting to test now.  

It would be helpful to see an example of the DAL in action.   I'm stuck on connecting right now.

[will...@gmail.com]

It's working, and I've created my first table via pydal.    

I'll do more testing, and I'll plan on updating the docs as well.

Here is a snippet from my models.py:

# Establish the connection

SNOWFLAKE_ACCOUNT = 'xxxxxx'
SNOWFLAKE_USER = 'yyyyyy'
SNOWFLAKE_PASSWORD = '######'
SNOWFLAKE_DATABASE = 'xxx'
SNOWFLAKE_SCHEMA = 'xxx'
SNOWFLAKE_WAREHOUSE = 'xxx'
SNOWFLAKE_ROLE = 'xxx'

# Construct the Snowflake connection URI for pyDAL
db_uri = "snowflake://%s:%s:%s:%s:%s@%s/%s" % (SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_ROLE, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_ACCOUNT, SNOWFLAKE_SCHEMA, SNOWFLAKE_DATABASE)

# Initialize the pyDAL instance
dbSF = DAL(db_uri)

(P.S.  I wrote the Teradata adapter at least 10 years ago). 

[Massimo DiPierro]

This is fantastic. Thanks for letting us know.

--
You received this message because you are subscribed to the Google Groups "py4web" group.
To unsubscribe from this group and stop receiving emails from it, send an email to py4web+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/py4web/8f594983-e9f8-4970-9751-fb1686827f1dn%40googlegroups.com.

[Kevin Keller]

Never got around documenting this . 

It’s solid for crud operations but might have minor bugs in complex queries . 

Thanks for sharing your experience!

To view this discussion visit https://groups.google.com/d/msgid/py4web/CAJYrZrnszy2tENuQhfrUm1pkCZ4XD1gxqaazJqbByO7EKaAw8A%40mail.gmail.com.