topic Re: Spark Notebook to import data into Excel in Data Engineering

Spark Notebook to import data into Excel

CBull — Thu, 17 Mar 2022 18:38:31 GMT

Is there a way to create a notebook that will take the SQL that I want to put into the Notebook and populate Excel daily and send it to a particular person?

Re: Spark Notebook to import data into Excel

Aviral-Bhardwaj — Sat, 10 Dec 2022 14:34:50 GMT

yes this feature is available in the SQL analytics, you don't need a notebook here

you simply write the query and use the auto stop feature in the SQL warehouse .

you can refresh query there and set up for alerts to specific team or person

Re: Spark Notebook to import data into Excel

Aviral-Bhardwaj — Sat, 10 Dec 2022 14:36:01 GMT

this can be done via boto3 code also

Re: Spark Notebook to import data into Excel

Meghala — Mon, 26 Dec 2022 16:32:00 GMT

@Aviral Bhardwaj thanks for this, I was needed this info