Easing the pain of connecting to databases

on YouTube ↗17m

" summary

New odbc helpers reduce ten required connection args to one by providing sensible defaults and automatic driver lookup on Linux and Mac, plus automatic Mac INI fixes so Databricks connects without manual edits. odbc::databricks() and odbc::snowflake() detect auth method from env vars or Workbench SSO, let users override any field, and work with SQL warehouses. The IDE builds a connections pane in Positron that previews the first 1000 rows with inline stats and catalogs SQLAlchemy engines created from Python code.

AI-written summary · about

" chapters (5)

1. 0:00Introduction
2. 2:32Simplified Databricks ODBC
3. 7:17Snowflake sensible defaults
4. 9:08Positron database connections
5. 14:30Q&A

" related talks

• 17mUsing R with Databricks ConnectEdgar Ruiz · posit::conf(2023)
• 16mdbcooper: Turn any database into an R or Python packageDavid Robinson · rstudio::conf 2019
• 31mODBC takes an Arrow to the knee: ADBCMatthew Topol · Øredev 2024
• 16mdbcooper: Turn any database into an R or Python packageDavid Robinson · rstudio::conf(2022)
• 19mDatabases using R The latestEdgar Ruiz · rstudio::conf 2019
• 41mFaster SQL with pandas and Apache ArrowWill Ayd · PyData NYC 2023
• 33mturbodbc: Turbocharged Database Access for Data ScientistsMichael König · PyCon.DE 2017
• 01h 04mWhere We’re Going, We Don’t Need Rows: Columnar Data Connectivity with Apache Arrow ADBCIan Cook · Future Data Systems Seminar Series (Fall 2025)