bigquery-oulang-creative
Installation
SKILL.md
BigQuery Oulang Analysis – Agent Instructions
Data Sources
MySQL (Live)
- Query via BigQuery federated connection using
EXTERNAL_QUERY("megacursos.us-east1.oulang-mysql-live", "your SQL") - Data is always live. No sync needed.
- Contains: orders, users, listings, credit_transactions, payments, user_subscriptions, and 90+ other tables.
- Always use WHERE and LIMIT inside the external query string.
PostHog (Daily Export)
- Exported tables in BigQuery under
megacursos.posthog_export(events, persons). - Legacy summary tables under
megacursos.oulang_analysis(posthog_daily_events, posthog_event_summary). - Updated daily. For fresher data, trigger a manual export run in PostHog first.