Contents

• • Orb_fdw
    • Pre-requisistes
    • Customers table
    • Subscriptions Table
    • Invoices Table

Orb_fdw

This is a simple open-source data wrapper that bridges the gap between your Postgres database and Orb a leading usage-based billing solution.

Pre-requisistes

• have the v0.0.3 of orb_fdw extension enabled in your instance

Create the foreign data wrapper:

sql create foreign data wrapper orb_wrapper handler orb_fdw_handler validator orb_fdw_validator;

Connect to clerk using your credentials:

sql create server my_orb_server foreign data wrapper orb_wrapper options ( api_key '<orb secret Key>')

Create Foreign Table:

Customers table

This table will store information about the users.

sql create foreign table orb_customers ( user_id text, organization_id text, first_name text, email text, stripe_id text, created_at text ) server my_orb_server options ( object 'customers' );

Subscriptions Table

This table will store information about the subscriptions.

sql create foreign table orb_subscriptions ( subscription_id text, organization_id text, status text, plan text, started_date text, end_date text ) server my_orb_server options ( object 'subscriptions' );

Invoices Table

This table will store information about the subscriptions.

sql create foreign table orb_invoices ( customer_id text, subscription_id text, organization_id text, status text, due_date text, amount text ) server my_orb_server options ( object 'invoices' );