I have looker report, say

report_a

This report uses a dbt model

model_a

. How do I add this looker report as an asset to my pipeline?

Think I may have requested this functionality the other day.

cc @owen

hi @Qwame! is this report currently rebuilt / otherwise updated using dagster? we don't provide any built-in looker integration, but if you wanted to implement this for yourself, this would look something like:

@asset(non_argument_deps={AssetKey(<asset key for model_a>)})
def my_looker_report():
    # ... update looker report

Then, you could just add this

my_looker_report

asset to your asset group and dagster would place it downstream of model_a

Hi @owen this looker report has already been built. I'd say all that I'll need to update the report is to refresh the data used to build the report. So if that data changes, say new columns added etc. then I'll need to be alerted.

hm so it sounds like maybe you don't need the looker report tracked as an asset by Dagster (because it will automatically update itself), and instead would want to have some alerting mechanism to tell you when anything significant changes w/ model_a, is that right?

Yes, that's what I was initially looking at but this conversation makes me want to update looker using Dagster so if there is a failure, the report will not break

gotcha, makes sense 🙂 anything I can do to point you in that direction? to be honest, I'm not super familiar with what functions the looker API supports, but if it's possible to have it only update after a dby model successfully completes then I think that would be a reasonable way to structure things.