Sorry for back to back troubleshooting posts. Hitting a hard to debug error using the meltano variant of the snowflake loader. Error message is

AttributeError: 'SnowflakeDialect' object has no attribute 'driver'

. I've traced this issue back to the snowflake-sqlalchemy repo here. It should be fixed based on the version of snowflake-sqlalchemy that's running in my virtual env. Any guidance or places to look would be much appreciated.

hey @daniel_luftspring did you have any luck fixing this? I’m facing the same issue.

Unfortunately no the issue is still persisting and im running out of ideas aside from switching the snowflake target variant and raising an issue on the source repo

Ok too bad I also could not get it to work this afternoon, I’ll move to the transferwise variant then 😅 Thanks for letting me know

Hi folks, got the same issue and @daniel_luftspring inspired me to tweak existing loader we use

<https://gitlab.com/meltano/target-snowflake>

and fork it. Here is the working repo: https://gitlab.com/gitlab-data/edcast-target-snowflake This version is working fine now as we update

snowflake-sqlalchemy

lib to the latest one

1.3.3

(released a couple of days ago) and working fine for our use case. Hope this helps.

Thanks @radovan_bacovic your fix solved the problem. Did you raise a PR against the meltano snowflake target?

Actually yes @daniel_luftspring raised and closed

MR

, but in our project - this was a show stopper for us as impacted existing loads. Also, the

target-snowflake

we are using is obsolete and our plan is to upgrade from more things (ie

pyhton-connector

) and make it official so people can use it.