Auth0 FDW API Key

[shaked-hadas]

Hi
I’m trying to configure Supabase’s Auth0 FDW as outlined in the documentation.

According to the guide, the extension requires an “Auth0 API Key or PAT”. However, Auth0 doesn't supports creating Personal Access Tokens (PATs), and to interact with the Management API, a valid access token must be obtained through a client credentials flow — meaning the wrapper itself needs to request the token using the appropriate client ID, secret, and audience.

Has anyone successfully configured this FDW under these constraints?

If the wrapper currently lacks support for programmatic token retrieval, are there any recommended workarounds?

Thanks!

[burmecia]

Auth0 FDW doesn't support OAuth at the moment, so it cannot request programmatic token. You can try Auth0 management API token instead, it can be found in the Applications -> APIs -> Auth0 Management API -> API explorer.

[shaked-hadas]

Thank you for your answer!
I tried it, and I received this error when querying the table

Also, given the token expiration (as defined in the attached image) and the 1-month maximum lifespan, do I need to manually replace the token monthly? This seems impractical.

[burmecia]

I've tested on my account and it works fine. Can you confirm used correct url and api_key option when creating the foreign server? You can run the SQL in SQL Editor, rather than using GUI. The foreign table DDL should be like below:

create server auth0_server
  foreign data wrapper auth0_wrapper
  options (
    url 'https://dev-xxx.au.auth0.com/api/v2/users',
    api_key_id '<secret id in Vault>'
  );

[shaked-hadas]

Configuring it using SQL instead of the GUI indeed made it work! thanks!
What about the token expiration? Is there any way to maintain it better than manually replacing it every month?

[burmecia]

Currently there is no automatic way to handle token expiration, so we have to replace it every month. We will do some evaluation and research to see if possible to add OAuth support in Wrappers, hopefully in the next several months.

[shaked-hadas]

Ok, thank you very much for your responses