Can this be used with a managed Supabase instance?

[maninak]

Hello, I would like to know if this is only for on-premises Supabase instances or if it can be used with managed ones. If yes to the latter, please elaborate on how to do that, since the docs did not clarify that for me.

Thank you so much for the help!

[burmecia]

Hi @maninak , the answer is 2 yes 😄 . On both platforms, the steps are almost same, basically it is:

-- install wrappers extension
create extension if not exists wrappers;

-- create a FDW, such as Stripe FDW
create foreign data wrapper stripe_wrapper
  handler stripe_fdw_handler
  validator stripe_fdw_validator;

-- create a foreign server
create server stripe_server
   foreign data wrapper stripe_wrapper
   options (
     api_key 'sk_test_xxx'
   );

-- create foreign tables
create foreign table stripe.balance (
  balance_type text,
  amount bigint,
  currency text,
  attrs jsonb
)
  server stripe_server
  options (
    object 'balance'
  );

-- use the foreign table
select * from stripe.balance limit 100;

You can find more details in the wrappers documentation.