merca
Valued Contributor II

Do I understand you correctly:

You want to run a notebook or sql query that will generate some data in form of table and you need to "send" somehow this data to someone (or somebody needs this data at some point)?

If this is correct assumption, you have many options to achieve this. But the essential is that you run a job on schedule that prepares this data, either to an csv file in storage or table in databricks metastore.

As I don't know what you are comfortable with I will give the simplest way:

If you store data as scv file in storage - Excel can connect directly to this csv.

If you store the table in databricks metastore - Excel can connect to databricks sql endpoint via Simba ODBC driver and pull table directly to Excel.

If you give me more information - I can give you more options how to resolve this 😁