A complete solution for open data platforms, enterprise data catalogs, data lakes and data management. Open source, mature, fully-featured and production ready.

DataHub

trying to ingest snowflake metadata using the UI based approach. Getting the following error but not sure why: snowflake.connector.network:920} - 000403: HTTP 403: Forbidden. Created a user and role within Snowflake and using that in the recipe as shown on the DataHub doc.

hey Wailur! so yeah obviously it looks like a permissions issue. Are you using secrets for username and password or posting it as plain text in the recipe? and could you post a fuller stack trace here?

```source:
    type: snowflake
    config:
        ignore_start_time_lineage: true
        account_id: XXXXXXX
        warehouse: YYYYYY
        username: '${SNOWFLAKE_DATAHUB_USER}'
        password: '${SNOWFLAKE_DATAHUB_PASS}'
        role: datahub_role
        schema_pattern:
            deny:
                - 'information_schema.*'
        profiling:
            enabled: true
        profile_pattern:
            deny:
                - '.*information_schema.*'
sink:
    type: datahub-rest
    config:
        token: ey...........
        server: '<https://abc.xyz.io/api/gms>'```


This is what I am using in the recipe. Created the datahub_role from within Snowflake using sample command found in the DataHub documentation.

Untitled.txt

shoot this totally slipped by me. will get back to you in a sec!

did you set the username and password as secrets in the UI then?

the same user and password I use to log into Snowflake which has admin access

okay gotcha. Yeah so it's having an issue connecting to snowflake for some reason it looks like. Would you mind trying again with your username and password in your recipe as text instead of using a secret? just want to limit variables here. also ensuring your account id and warehouse fields are correct

Hello <@U038C9DLV17> I am facing the same issue could you let me how did you overcome the issue