rstudio / rstudio/pointblank

Support for Databricks Pointers

Open
#607 0 comments 0 reactions 1 assignee View on GitHub

@rich-iannone is already working on this.

Since Mar 13, 2025.

Type: ★ Enhancement
Dominant language
R
Stars
1k
Forks
59
Avg merge
25m
Merged PRs (30d)
4

Description

Prework
Currently, the pointblank package does not support ODBC or cluster connections (via sparklyr) to Databricks warehouses. Given the recent advancements in other packages such as odbc, pins, and sparklyr regarding Databricks functionality, enhancing pointblank to support these connections would be highly beneficial for many analysts.

Proposal
I propose extending the functionality of pointblank to support Databricks connections through either of the following methods:

Extend the db_tbl() function to allow connections using a syntax like
db_tbl(table = "catalog.schema.table_name", dbtype = "databricks").

  • Enable connections via ODBC using the following approach:
con_db_odbc <- 
DBI::dbConnect(drv = odbc::databricks(), HTTPPath = Sys.getenv("HTTP_PATH"))
data <- tbl(con_db_odbc, I("catalog.schema.table_name"))
scan_data(data)

Implementing these features would streamline the workflow for analysts working with Databricks, allowing them to leverage pointblank for data validation and quality checks directly on their Databricks data sources.

Please let me know if further clarification or details are needed.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.