Troubleshooting Missing Table Usage Statistics in BigQuery

troubleshoot
1

Original Slack Thread

Hello,

I used to be able to see table usage and now realized it’s missing from all our assets. Nothing has changed with the recipe and confirmed the SA still has as the required roles. This is for BigQuery.

Any ideas?

    type: bigquery
    config:
        include_table_lineage: true
        include_tables: true
        include_views: true
        convert_urns_to_lowercase: true
        include_usage_statistics: true
        profiling:
            enabled: true
            profile_table_level_only: true
        stateful_ingestion:
            enabled: true
        credential:```
2

Hey there! :wave: Make sure your message includes the following information if relevant, so we can help more effectively!

  1. Which DataHub version are you using? (e.g. 0.12.0)
  2. Please post any relevant error logs on the thread!
3

v0.13.0

Logs show usage was ingested I think?

        "*: Usage Extraction Operational Stats at 2024-05-16 19:36:53.270865+00:00": 0.04,
        "*: Usage Extraction Usage Aggregation at 2024-05-16 19:36:53.308066+00:00": 29.83
      },
      "events_produced": 7481,```