← All work

Licensed drinkware & consumer products

NetSuite data warehouse foundation

The first layer of a reporting warehouse, with NetSuite customers synced hourly into Supabase/Postgres for analytics.

  1. NetSuite
  2. Edge function
  3. Postgres warehouse
Client
Top Cup ↗
Licensed drinkware & consumer products
Stack
Supabase, Postgres, pg_cron, Edge Functions (Deno), NetSuite REST, OAuth 2.0 M2M

What I built

  • An edge function that authenticates to NetSuite machine-to-machine and upserts the full customer list.
  • Scheduled hourly with pg_cron, protected by a shared secret, with credentials in Supabase Vault.
  • A base for more data. The pattern is ready for orders, items and inventory.