Question: is there a way to get the current catalog or database?

[NickCrews]

Hi! I'm working on the datafusion backend for ibis. Specifically, I'm working on PR ibis-project/ibis#11112. Most of the backends for ibis, such as postgres, duckdb, sqlite, etc all have a way of getting the current database (collection of tables) and/or current catalog (collection of databases) such as with SELECT current_database(). Does datafusion have a way of doing this? Either via SQL, or via a python API would work. Thank you!

[timsaucer]

Probably a duplicate for #1103

@NickCrews please let me know if that issue doesn’t answer your needs

[NickCrews]

I don't super understand #1103, but I think that is maybe the inverse: that issue is about allowing devs to provide datafusion with ways to access they custom databases/catalogs that exist elsewhere in python-land. I think my use case is much more simple, the other direction: given an existing datafusion context, get the name of the current database/catalog.

After looking around the docs a bit more, I think I actually found the solution

from datafusion import SessionContext

ctx = SessionContext()
sql = "select value from information_schema.df_settings where name='datafusion.catalog.default_catalog'"
ctx.sql(sql)
# 'datafusion'