Hi, have a quick question. For the metadata ingest...
# troubleshoot
b
Hi, have a quick question. For the metadata ingestion for snowflake, should the user have any specific role. I have full access on the schema but it is throwing login error, which is working absolutely fine when used with other applications
s
I've created a role only for datahub as the website indicates: https://datahubproject.io/docs/generated/ingestion/sources/snowflake/#prerequisites Try to create a datahub_role and grant it to your user.
b
@salmon-angle-92685, I have full grants on a schema only in a database. Does it require to have the grants on database ?
s
@bland-easter-53873 I think you can adapt the SQL given on the docs to grant privileges to the datahub_role only over the schema which you have access.
b
Thanks @salmon-angle-92685, let me try to check. Since the admin of the snowflake is managed by another team, figuring that specific grant was important for me.
@salmon-angle-92685, i am using the similar role but there is connection issue
and my hunch is probably proxy issue
datahub ingest -c <filename> is failing with connect retries