How to export data from GCP Postgres sql to a csv file in GCS through AIRFLOW?

0
votes

We are using GCP with Postgres sql. Need to export one table from postgres to a csv file in google cloud storage bucket but only through AIRFLOW. Not sure whether API call / Operator can be used. Please advise if possible with sample code.

Thanks Raj.

1
postgresqlgoogle-cloud-platformairflow
There's a specific operator for that [CloudSqlInstanceExportOperator, airflow.apache.org/docs/stable/howto/operator/gcp/…. it allows you to export from Cloud SQL to Google Storage - Albert Albesa

1 Answers

1
votes

What you're looking to do should be feasible with the PostgresToGCSOperator. Here you can find a usage example.