Hey all :wave::skin-tone-3:, having issues seeing ...
# troubleshoot
n
Hey all ๐Ÿ‘‹๐Ÿผ, having issues seeing column lineage flow from Snowflake through to Looker. We can see lineage for tables contained within Snowflake and lineage for Looker views/explores for things contained within Looker; however, no connection between the two. For the LookML ingestion, weโ€™re using the UI and have a user account created with admin privileges. Is there anything else that could be impacting the full lineage connection from showing? All of our current ingestions are successfully running (Snowflake, Looker, and LookML). (
b
hey Brandon! if you look at your yaml recipe for Looker and LookML, do you see the field
extract_column_level_lineage: true
?
n
Hey @bulky-soccer-26729๐Ÿ‘‹๐Ÿผ, Iโ€™m not seeing that anywhere within the Looker or LookML yaml recipe. Can I just add that anywhere within the config block?
b
yup! let's give that a try. then try running ingestion again and let's see what we have. if that doesn't fix it I'll bring in some more heaver hitter that work on ingestion more than me haha
n
Got it, so I added those pieces into each recipe and re-ran, but still not seeing full lineage through to Snowflake.
Let us know if there is anything else we could potentially try on our end @bulky-soccer-26729.
b
okay gotcha.. would you mind posting this question in #ingestion as I think they'll be able to help you out better then myself!
a
CC: @hundreds-photographer-13496
n
Thanks @bulky-soccer-26729 ๐Ÿ‘๐Ÿผ, I actually already posted in #ingestion as well and have been talking with @hundreds-photographer-13496about potential next steps. https://datahubspace.slack.com/archives/CUMUWQU66/p1675200850205449