Data is garbled when importing CSV to SQL instance

[Airflow Ex]

Hello,

    I have been trying to import a CSV file to GCP SQL Instance, PFA a screenshot of the part of the SQL File. Import is showing as successful, I tried both using the UI and gcp sql import command but same result for both. PFA SELECT * command from the table.

    Please let me know what I am doing wrong, and if you need any more information.

Thanks and Regards,

Shashanka

[perezsanchez]

SQL Server and Cloud SQL do not support CSV files. As already indicated, SQL Server presently supports importing databases using BAK and SQL files in Cloud SQL.

The Cloud SQL versions for MySQL and PostgreSQL somehow support it.

One of the following options is possible:

Alternatively, switch to MySQL or PostgreSQL as the database engine (where CSV files are supported).

You can utilize your CSV file to create a SQL file that you may use to import into Cloud SQL, SQL Server, if the data on it comes from an on-premises SQL Server DB table.