Gold table for Analyst

[KennethKnewman]

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.

[szymon_dybczak · Accepted solution]

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]

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]

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