Add secret for iceberg

[ivanboldyrevv]

Hello, everyone! Please help! I need to add a secret for a REST catalog using 'CREATE SERVER'.

I tried this:

CREATE SERVER iceberg_catalog
TYPE 'iceberg'
FOREIGN DATA WRAPPER duckdb
OPTIONS (
    type 'iceberg',
    OAUTH2_SERVER_URI 'http://rest:8181/v1/oauth/tokens',
    CLIENT_ID 'admin',
    CLIENT_SECRET 'password'
);

But when I use this, I get an error:

SQL Error [XX000]: ERROR: Options 'client_secret', 'client_id' cannot be used in the SERVER's OPTIONS, please move them to the USER MAPPING

Then I tried this:

CREATE SERVER iceberg_catalog
TYPE 'iceberg'
FOREIGN DATA WRAPPER duckdb
OPTIONS (
    OAUTH2_SERVER_URI 'http://rest:8181/v1/oauth/tokens',
);

But I get this error:

SQL Error [XX000]: ERROR: Missing required parameter 'client_secret' for authorization_type 'oauth2'

Also, I have another question. I'm performing INSERT operations by running raw_query. Is this the right approach? If not, what is the recommended way to do inserts when working with pg_duckdb?

ps
Sorry if this is the wrong place to ask. I wasn't sure where to put this question.