Refreshable query for plugin variant analytics

[aaronsteers]

@pnadolny13 - Can I get a copy of the query used to generate the below? I considered asking for a data refresh but the "teach to fish" metaphore came to mind and it's something I don't mind pulling/refreshing if I have the underlying logic.

https://docs.google.com/spreadsheets/d/1PdM1Mp-PMF6V1r1gbI7d1qcJzGPtbqgmCOMjbdj4drI/edit#gid=0

Alternatively, you could save this query as a report table in dbt. A prefix of rpt_ is something I've used the the past for 'report outputs' at other companies.

[pnadolny13]

@aaronsteers that export is a "select *" output (potentially excluding a few columns but no special logic) from this model https://github.com/meltano/squared/blob/main/data/transform/models/publish/meltano_hub/fact_variant_hub_metrics.sql. You can access it directly in Snowflake at PROD.MELTANO_HUB.FACT_VARIANT_HUB_METRICS, I also exposed it as a table chart in the daily dashboard in superset.