posthog icon indicating copy to clipboard operation
posthog copied to clipboard

chore(data-warehouse): Added tracking events to data warehouse

Open Gilbert09 opened this issue 1 year ago â€ĸ 3 comments

Changes

  • Added a bunch of tracking events for data warehouse usage
    • "source schema saved" - Saving an updated schema for a manual table
    • "source schema viewed" - Viewing the schema for any table
    • "source created" - Creating a new source (e.g. Stripe, Manual, Hubspot, etc) (has prop syncType)
    • "source deleted" - Deleting a source
    • "schema reloaded" - An early update of the table data
    • "schema resynced" - A full table refresh
    • "schema updated" - Update to the table, such as turning on/off syncing, or incrementality type (has props shouldSync and syncType)
    • "join created" - A join being created by the user
    • "join updated" - A join being deleted by the user
  • Updated "insight analyzed" and "insight viewed" to include prop has_data_warehouse_series

Does this work well for both Cloud and self-hosted?

Yep

How did you test this code?

👀

Gilbert09 avatar Jun 25 '24 11:06 Gilbert09

Size Change: +52 B (0%)

Total Size: 1.06 MB

â„šī¸ View Unchanged
Filename Size Change
frontend/dist/toolbar.js 1.06 MB +52 B (0%)

compressed-size-action

github-actions[bot] avatar Jun 25 '24 11:06 github-actions[bot]

Last bit that would be good is capturing hogql queries run with data warehouse data

@EDsCODE I think this may be a fair bit harder, we'd have to match the table name to all warehouse tables, meaning parsing the AST on the client etc. If we do the event from the backend, will it get assigned to the correct person etc?

Gilbert09 avatar Jun 25 '24 12:06 Gilbert09

📸 UI snapshots have been updated

2 snapshot changes in total. 0 added, 2 modified, 0 deleted:

  • chromium: 0 added, 2 modified, 0 deleted (diff for shard 2)
  • webkit: 0 added, 0 modified, 0 deleted

Triggered by this commit.

👉 Review this PR's diff of snapshots.

posthog-bot avatar Jun 27 '24 20:06 posthog-bot

📸 UI snapshots have been updated

2 snapshot changes in total. 0 added, 2 modified, 0 deleted:

  • chromium: 0 added, 2 modified, 0 deleted (diff for shard 2)
  • webkit: 0 added, 0 modified, 0 deleted

Triggered by this commit.

👉 Review this PR's diff of snapshots.

posthog-bot avatar Jul 01 '24 14:07 posthog-bot