403 Error when querying DuckDB view in Metabase UI

[vineetdpnd]

Pre-checks:

• Using the latest version of Metabase (0.50.10) with the DuckDB Driver (metabase_duckdb_driver).
• DuckDB is configured and installed on the same server as Metabase.
• Permanent Secrets for S3 connection are configured.
• A view has been created using the read_parquet query for S3.
• Verified via DuckDB CLI that querying the S3 view returns the expected results.
• The view schema is correctly displayed under Admin Settings - Table Metadata in the Metabase Admin section.

Issue:

• When attempting to query the view in the Metabase UI (e.g., SELECT * FROM "View_Name" LIMIT 10), a 403 error is encountered.
• It appears that this error may be coming from S3 (though it shouldn't), but we are not certain.

Additional Information:

This is our first time using DuckDB to query S3 data with Metabase.

[hrl20]

do you mind sharing how View_Name is defined?
FWIW, we would usually see the s3 path in the error message like

 HTTP GET error on 'https://{bucket_name}.s3.amazonaws.com/{path}'

[vineetdpnd]

@hrl20 The View is defined as below:

CREATE VIEW demo_duck AS (
    FROM read_parquet('s3://{bucket_name}/institutes/1/*/*/*/*/data.parquet')
);

[vineetdpnd]

@hrl20 We figured out that by mistake, our Permanent Secret was created using the Root Account. Apologies for wasting your time.