Spark Notebook to import data into Excel

[CBull]

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]

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

[Aviral-Bhardwaj]

this can be done via boto3 code also

[Meghala]

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