[Epic] Capture more metadata: table count, field usage, last viewed/used_at

[luizarakaki]

Technical doc: https://www.notion.so/metabase/Accurate-fingerprint-729a720cdd4f41029a49d647fa9583b2?pvs=4
Related to https://www.notion.so/metabase/Capture-field-and-table-usage-metadata-990e99226d234d8b916478109162cd42?pvs=4

Milestone 1: Sync table row count (Postgres only)

Beta Give feedback

1. Homebrew getTables for postgres #39670
   .Team/BackendComponents no-backport +2
   
2. Postgres: Sync table row count #39494
   .Team/BackendComponents no-backport +2
   

Milestone 2: Count field usage

Beta Give feedback

1. Add new field_usage table
2. Record field usage during query execution #40494
   .Team/BackendComponents +1
   

Milestone 3: Capture last_viewed_at and last_used_at

Beta Give feedback

1. Capture card's last_used_at #41006
   .Team/BackendComponents no-backport +2
   
2. Track public and embedded card views, and collection views in the view log #41748
   .Team/BackendComponents no-backport +2
   

The use case for Milestone 3 is Auto cleanup collections
For this project, we need signal that an item (collection, question, model, dashboard) is irrelevant.
For dashboards, last_viewed_at is enough.
For questions and models, we need to know if it is used by other things (like nested questions, sandbox definition, custom field values, goals), so we are proposing a last_used_at property that registers everytime that item is used.

New technical design doc

Milestone 4: Capture view count for questions, models, and dashboards.

Beta Give feedback

1. Add view_count for cards and dashboards and populate it from view_log #41840
   .Team/BackendComponents no-backport +2
   
2. Add table view count column and increment it on views #41886
   .Team/BackendComponents +1
   
3. Increment view_count on card, dashboard, and table views #41882
   .Team/BackendComponents backport no-backport +3
   

The use case for Milestone 4 is TBD, but most likely this would be shown in collections to help users find relevant content or help rank search results.
Milestone 4 technical doc

[qnkhuat]

Technical doc https://www.notion.so/metabase/Accurate-fingerprint-729a720cdd4f41029a49d647fa9583b2?pvs=4