Hello - Im very new to DataHub. We are trying to ingest metadata from our Snowflake instance. When we test the connection it runs successfully, but when we try to run the actual ingestion we are getting these types of errors [2023-03-22 195814,603] INFO {datahub.cli.ingest_cli:120} - Starting metadata ingestion [2023-03-22 195815,429] INFO {datahub.ingestion.source.snowflake.snowflake_v2:1388} - Checking current version [2023-03-22 195815,551] ERROR {datahub.ingestion.source.snowflake.snowflake_v2:224} - version => Error: 'CURRENT_VERSION()' [2023-03-22 195815,551] INFO {datahub.ingestion.source.snowflake.snowflake_v2:1394} - Checking current role [2023-03-22 195815,645] ERROR {datahub.ingestion.source.snowflake.snowflake_v2:224} - version => Error: 'CURRENT_ROLE()' [2023-03-22 195815,645] INFO {datahub.ingestion.source.snowflake.snowflake_v2:1400} - Checking current warehouse [2023-03-22 195815,744] ERROR {datahub.ingestion.source.snowflake.snowflake_v2:224} - current_warehouse => Error: 'CURRENT_WAREHOUSE()' [2023-03-22 195815,744] INFO {datahub.ingestion.source.snowflake.snowflake_v2:1407} - Checking current edition [2023-03-22 195816,368] WARNING {datahub.ingestion.source.snowflake.snowflake_v2:185} - snowsight url => unable to get snowsight base url due to an error -> 'CURRENT_ACCOUNT()' [2023-03-22 195816,368] ERROR {datahub.ingestion.source.snowflake.snowflake_v2:224} - permission-error => Current role does not have permissions to use warehouse WH_NMHS_XS. Please update permissions. We are on a Tenant of Snowflake, not sure if that has anything to do with this or not. Any help would be much appreciated. Thanks!!

Hi, please see the Snowflake quickstart guide on configuring the ingestion user role: https://datahubproject.io/docs/quick-ingestion-guides/snowflake/setup

Hi - thanks for your reply.  We used the setup guide and created the datahub_user and granted the permissions and got the errors.  We also tried using our tenant admin user as well in the snowflake ingestion config and got the errors.  Any other ideas?

Hi, could you elaborate on the “tenant” aspect of this- is your snowflake hosted outside of the normal address? I would also double check the recipe for spelling etc,

We are using snowflake through Cerner. So we do not have full admin access, it’s called tenant admin access. We were able to run the grants fine that were in the guide and when I put in the info to ingest I hit the test button and everything came back with a green check mark. I have also logged into Snowflake with the user I am using for ingestion and was able to run the select statements fine.

huh, extremely odd- what version of DH are you using?