Exporting Data Google Professional Data Engineer GCP

• Export data from Cloud SQL to Cloud Storage and then, can download data from Cloud Storage to local environment.
• Can export to a CSV file / SQL dump file for MySQL / PostgreSQL.
• For SQL Server, export to BAK is supported
• Export can be done using console / gcloud / REST methods

Best practices when importing and exporting data:

• Don’t use Requester Pays buckets
• Use the correct flags when you create a SQL dump file
• Compress data to reduce cost
• Use InnoDB for MySQL