Hi, I’m trying to read data from Snowflake, and have tested both the transferwise and the meltanolabs variants of tap-snowflake. From what I have been able to discern, there are two issues: - Although the transferwise tap accepts a

role

config, it seems this isn’t passed to the snowflake connector upon discovery (the code seems to pass it correctly on the actual sync), and I get an error that I don’t have access to the database. If I set a default role for the user, the tap works. - The meltanolabs version (which I know is still very much in development) seems to fail when it tries to show tables in a schema without prefixing with the database name or run

use database

beforehand. Has anyone overcome any of these issues? Our IaC setup makes it difficult to assign default roles, so I hope I won’t have to.

@pat_nadolny ? @taylor?