- 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
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.
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.
Join Exponam.Connect at the Data+AI World Tour in New York on November 8th. We’re proud to be a Gold Sponsor of this event. Come by and see how easy we make it to empower your organization with your Databricks data. No special tools. Nothing but Excel — exactly what the business wants.
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.