Initial run for media_stats does not work on databricks

[drphrozen]

The following line dosen't yield any results when the table is empty in databricks.

dbt-snowplow-media-player/models/web/snowplow_media_player_media_stats.sql

Line 48 in a1b859a

and p.start_tstamp > ( select max(last_base_tstamp) from {{ this }} )

[rlh1994]

Hi @drphrozen , that line is within an is_incremental block so it won't be that line running on the initial run anyway. Are you saying that when an initial run results in the table being empty that then subsequent runs do not populate because of this, or is your issue around the initial run not having any data in that table?

[drphrozen]

The table was never populated, either by the initial or subsequent. Solved our issue by adding a dummy row with a old timestamp and some random media id.

I did not deep dive into the issue.. just ran the compiled section for this SQL and found that this part of the where statement was the issue.

[rlh1994]

Okay that's helpful thanks, I wasn't sure if a date is always greater than null or if it returns null but it looks like it returns null. We're currently in the middle of a big update to the package so we'll make sure it's caught in there. cc @matus-tomlein