cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Gold table for Analyst

KennethKnewman
New Contributor II

Hi team,

we are running data pipeline from bronze to gold, and another team need to refer the gold table. however the team doesn't have technical skills to query, and they would like to use the data on spreadsheets. Do we have any good work around in this situation? we required get data from databricks then share it with the team manually.

1 ACCEPTED SOLUTION

Accepted Solutions

szymon_dybczak
Contributor III

Hi @KennethKnewman ,

You didn't specify the details, but there are several ways. You can connect excel to databricks using odbc driver: 

https://docs.databricks.com/en/integrations/excel.html

If you're using Google sheets you can use bricksheet add-on

https://workspace.google.com/marketplace/app/bricksheet/979793077657

Or you can read your gold table as a dataframe and save it as CSV. 

Or you can use spark-excel library and save dataframe directly to xslx format:

https://github.com/crealytics/spark-excel

As you can see, there are multiple ways to achieve that.

 

View solution in original post

3 REPLIES 3

szymon_dybczak
Contributor III

Hi @KennethKnewman ,

You didn't specify the details, but there are several ways. You can connect excel to databricks using odbc driver: 

https://docs.databricks.com/en/integrations/excel.html

If you're using Google sheets you can use bricksheet add-on

https://workspace.google.com/marketplace/app/bricksheet/979793077657

Or you can read your gold table as a dataframe and save it as CSV. 

Or you can use spark-excel library and save dataframe directly to xslx format:

https://github.com/crealytics/spark-excel

As you can see, there are multiple ways to achieve that.

 

KennethKnewman
New Contributor II

Hi @szymon_dybczak 

Thank you for your reply! I apologize for the missing information in my previous post. We are Google Workspace users and also use Google Sheets for our work. Bricksheet is actually the tool we were looking for. We tried it out, and the catalogs, schemas, and tables are automatically displayed on the user interface. totally best fit for Analyst team.we've decided to use Bricksheet!

Thank you again for your help. We really appreciate it!

 

KennethKnewman
New Contributor II

It was easy to install. I'm not sure if this information is useful, but I'd like to share it for those who might be in the same situation. https://bricksheet.amukin.com/export-data-from-databricks-to-google-sheet

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group