Had a bit of time to start looking into this, some findings:

• Feature collection fails because the input querys are empty
• Input queries are empty because query_clicks_ltr filters by session count, but all the session_id's are null
• The first partition that is missing session_id's is discovery.query_clicks_daily/year=2025/month=8/day=28
• Those partitions are generated by an hql query, the query and the airflow dag that issues it hasn't been changed since may 2025.

Not sure yet what changed, but we have a direction to look in. Not clear what we can do about all the missing session_id's at this point, likely they can't be reconstructed as we don't retain enough data.