Hi everyone! I have some trouble with my PG <> Snowflake connection.

I share the log  --> Schema 'PUBLIC' already exists, but current role has no privileges on it. If this is unexpected and you cannot resolve this problem, contact your system administrator. ACCOUNTADMIN role may be required to manage the privileges on the object.

I set up a different schema but Airbyte insist on write in public. Btw, the role has privileges to public. Any ideas? Best, Ignacio.

does your snowflake user have permission to the new database and schema? If not, it will default to public. I would log into snowflake as your airbyte users and confirm you are able to create a table in the desired schema along with the desired warehouse

The user is the owner of the database and schema. I try creating the schema manually and using the Airbyte connector. In both cases the connector try to write in public. So, I dont understand this behavior if the user have all the grants. Please, help us! 😞 Thanks! Best, Ignacio.

Hello Ignacio Alasia, it's been a while without an update from us. Are you still having problems or did you find a solution?