Spark Notebook to import data into Excel

CBull
New Contributor III

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?

Aviral-Bhardwaj
Esteemed Contributor III

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

AviralBhardwaj

this can be done via boto3 code also

AviralBhardwaj

Meghala
Valued Contributor II

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