- You can now change the order of columns in preview and during import to Excel.
- The preview screen includes a new option to view only select columns.
- A new search field lets you quickly find columns you want to include
New, Easier Excel Filtering in Exponam.Connect
Databricks partner Exponam now enables the easiest filtering of Databricks Data in Excel.
Right-click and you’re done! Contextual filtering means filtering is now one step in Exponam.Connect Pro Excel Add-in for Databricks. Of course, you can still filter by clicking the filter icon and setting your desired filter — but that is soooo 2020.
Databricks to Excel: Exponam.Connect or ODBC?
Recently, we evaluated the new Databricks ODBC driver. We have compared and contrasted using ODBC vs Delta Sharing & Exponam.Connect for pulling data into Excel.
What we found was that Exponam.Connect is the ideal choice for business and technical users to pull data from Databricks into Excel. ODBC requires more technical expertise, has poorer performance, and lacks the UI and power features demanded in many business use cases.
We compared the two approaches across numerous dimensions – from usability to cost. Read the comprehensive comparison here.
Delta Sharing Technical Deep Dive at DAIS
If you didn’t get to Roger Dunn’s Session at DAIS 2023 on Delta Sharing, watch the recording now.
All the hints and tricks you need to know for developing an application against the Delta Sharing REST API.
Exponam.Connect Video Series: 3 – Importing Data
Exponam.Connect Video Series: 2 – Filtering Data
Exponam.Connect Video Series: 1 – Add a Delta Sharing Server
Exponam Launches Delta Sharing Excel Add-in
For Immediate Release
Date: November 28, 2022
Location: AWS re:Invent 2022, Las Vegas
Exponam announced today the limited release of the Exponam.ConnectTM Excel Add-in, an easy-to-use Excel Application which brings Delta data from Databricks (and Spark) directly to end users in Excel.
Exponam.Connect empowers business users with frictionless, no-code access to data for which they are permissioned via Delta Sharing Server(s). Users easily add data sets from company data repositories, from partner companies, and from data sellers and marketplaces.
Delta data is instantly previewable with easy controls to:
- Filter and select what data to import into Excel
- Save filters for easy repeated actions (e.g. pulling daily, weekly or monthly sales data)
- Write data straight to csv or .BIG files
Roger Dunn, Co-founder and CTO of Exponam, said: “Since 2017, Exponam’s mission has been to make modern data sets accessible to everyone. Reporting and analytics tools are great, but business users want to work with data in a spreadsheet. By partnering with Databricks, our Exponam.Connect product brings data from the world’s leading Lakehouse platform directly to non-technical business users in Excel.”
Herman Weintraub, Co-founder and CEO of Exponam, said: “For the world’s 50 million developers, cloud data and distributed compute platforms like Spark have made data more accessible and better governed than ever. But for the world’s billions of Excel users, access to data has never been more of a challenge. Exponam.Connect, opens cloud data to the world. And with our .BIGTM format, we make modern data easy to securely share, distribute, store and access.”
About Exponam
Exponam evangelizes “Empowerment through Data.” We create better ways to share, move, store, and explore data. Organizations can use Exponam.Connect and .BIG file technologies with their existing systems to make large and sensitive data easier to access, faster to share, and cheaper to store.