I need to export data of a BigQuery table into CSV on Google Cloud Storage.
I used the following:
EXPORT DATA OPTIONS( uri=concat(path_file_output,'_*.csv'), format='CSV', overwrite=true, header=true, field_delimiter=';' ) AS SELECT * FROM my_bigquery_table
In my_bigquery_table there are string columns with the character '€' that are badly changed during the export for example: a field with '1234.56 €' is changed with '1234.56 â'.
On the documentation : https://cloud.google.com/bigquery/docs/reference/standard-sql/other-statements there aren't any other options for the export.
Exist a way to avoid this? Any suggestions?