Firebase Wrapper: Failed to retrieve rows from table

[saidelimam]

Bug report

Describe the bug

Looks like this foreign table setting from Supabase doc is not correct:

create foreign table firebase_users (
uid text,
email text,
created_at timestamp,
attrs jsonb
)
server firebase_server
options (
object 'auth/users'
);

But the error message returns the right user data in the error message, in the format:

{
"kind": "identitytoolkit#DownloadAccountResponse",
"users": [...]
}

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

insert into vault.secrets (name, secret)
values (
  'firebase',
  '{
    ************************
  }'
)
returning key_id;

create server firebase_server
  foreign data wrapper firebase_wrapper
  options (
    sa_key_id '***************************', -- The Key ID from above.
    project_id 'xxxxxxxx'
);

create foreign table firebase_users (
  uid text,
  email text,
  created_at timestamp,
  attrs jsonb
)
  server firebase_server
  options (
    object 'auth/users'
  );

Expected behavior

Display user data in Rows or return them from a Select query on the foreign table

Screenshots

System information

• OS: [e.g. macOS, Windows] macOS
• Browser (if applies) [e.g. chrome, safari]: Chrome Version 120.0.6099.199
• Version of supabase-js: [e.g. 6.0.2]
• Version of Node.js: [e.g. 10.10.0]