Re: [I] Question: is there a way to get the current catalog or database? [datafusion-python]

2025-04-13 Thread via GitHub


NickCrews commented on issue #1106:
URL: 
https://github.com/apache/datafusion-python/issues/1106#issuecomment-2800092336

   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
   
   ```python
   from datafusion import SessionContext
   
   ctx = SessionContext()
   sql = "select value from information_schema.df_settings where 
name='datafusion.catalog.default_catalog'"
   ctx.sql(sql)
   # 'datafusion'
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org



Re: [I] Question: is there a way to get the current catalog or database? [datafusion-python]

2025-04-13 Thread via GitHub


NickCrews closed issue #1106: Question: is there a way to get the current 
catalog or database?
URL: https://github.com/apache/datafusion-python/issues/1106


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org



Re: [I] Question: is there a way to get the current catalog or database? [datafusion-python]

2025-04-13 Thread via GitHub


timsaucer commented on issue #1106:
URL: 
https://github.com/apache/datafusion-python/issues/1106#issuecomment-2800014421

   Probably a duplicate for 
https://github.com/apache/datafusion-python/issues/1103
   
   @NickCrews please let me know if that issue doesn’t answer your needs


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org



[I] Question: is there a way to get the current catalog or database? [datafusion-python]

2025-04-13 Thread via GitHub


NickCrews opened a new issue, #1106:
URL: https://github.com/apache/datafusion-python/issues/1106

   Hi! I'm working on the datafusion backend for ibis. Specifically, I'm 
working on PR https://github.com/ibis-project/ibis/pull/2. 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!
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org