Troubleshooting Missing Table Usage Statistics in BigQuery

Original Slack Thread


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
        include_table_lineage: true
        include_tables: true
        include_views: true
        convert_urns_to_lowercase: true
        include_usage_statistics: true
            enabled: true
            profile_table_level_only: true
            enabled: true

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!


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,```