BigQuery table to csv and email

[ayushmaheshwari]

Hi,

I have done some transformations in Dataform and have BQ tables consisting of the transformed data. I have a data pipeline running through Airflow and all is ok

Now, I want another task in airflow to do the following:

1) Convert each table to csv

2) Attach in an email

3) Send email to xyz@soemthing.com (some email id)

I know about Airflow sendgrid but how do I do 1 and 2 and email as part of the pipeline run?

Can someone please help? Thank you so much

CC: @ms4446