Unable to query data from S3 Tables

[jibiabraham-rz]

Hello, I am trying out duckdb for talking to S3 Tables directly. I am able to list all the tables in the bucket, but am unable to query individual tables to get data out of them. Using duckdb=v1.4.1. Any help at all would be appreciated

_duckdb.CatalogException: Catalog Error: SET schema: No catalog + schema named "lakehouse" found.

What I have done until now

Code

import duckdb

with duckdb.connect() as connection:
    connection.execute(
        """
        CREATE OR REPLACE SECRET (
            TYPE s3,
            PROVIDER credential_chain,
            PROFILE 's3tables'
        );
        """
    )
    connection.execute(
        """
            INSTALL aws;
            INSTALL httpfs;
            INSTALL iceberg;
        """
    )
    connection.execute(
        """
            ATTACH OR REPLACE 'arn:aws:s3tables:eu-central-1:xxxxxxxxxxxx:bucket/lakehouse as lakehouse (
                TYPE iceberg,
                ENDPOINT_TYPE s3_tables
            );
        """
    )

    tables = connection.sql("SHOW ALL TABLES").fetchall()
    print([[x[1], x[2]] for x in tables[:10]])
    // [['ads', 'amazon_asin_daily'], ...]

    print(connection.execute("SELECT version()").fetchall())
    // [('v1.4.1',)]

    rows = connection.execute(
        "SELECT * FROM lakehouse.ads.amazon_asin_daily LIMIT 1;"
    ).fetchall()
    print([x[0] for x in rows])
/* 
Traceback (most recent call last):
  File "/Users/.../main.py", line 3, in <module>
    with duckdb.connect() as connection:
         ^^^^^^^^^^^^^^^^
  File "/Users/.../main.py", line 34, in <module>
    rows = connection.execute(
           ^^^^^^^^^^^^^^^^^^^
_duckdb.CatalogException: Catalog Error: Table with name amazon_asin_daily does not exist!
Did you mean "lakehouse.ads.amazon_asin_daily"?

LINE 1: SELECT * FROM lakehouse.ads.amazon_asin_daily LIMIT 1;
*/

[Tishj]

Thanks, I think an issue would have been better, but regardless

We are probably missing a DEFAULT_SCHEMA attach option to fix this

[jibiabraham-rz]

I can try it out if there's some documentation on how to set the default schema in this case