GCP: Bigquery для экспорта данных с CRLF в качестве завершения строки. ⇐ Python
-
Гость
GCP: Bigquery для экспорта данных с CRLF в качестве завершения строки.
I tried to export the data to CSV in BigQuery, by default it generate the export file with LF as line termination,
export data options(uri = 'gs:///.txt', format = 'CSV',overwrite = true, header = false, field_delimiter = '~') as select * from order by Is it possible to export the data with CRLF as line termination by providing some parameters in export data in BigQuery? Kindly share your thoughts
EDIT : requirement is to achieve the expected results through AIRFLOW, if any direct way to achieve this by adding any BQ EXPORT param, that would be great. if not, by using PYTHON Operator or BASH operator in Airflow, would be helpful
Источник: https://stackoverflow.com/questions/780 ... ermination
I tried to export the data to CSV in BigQuery, by default it generate the export file with LF as line termination,
export data options(uri = 'gs:///.txt', format = 'CSV',overwrite = true, header = false, field_delimiter = '~') as select * from order by Is it possible to export the data with CRLF as line termination by providing some parameters in export data in BigQuery? Kindly share your thoughts
EDIT : requirement is to achieve the expected results through AIRFLOW, if any direct way to achieve this by adding any BQ EXPORT param, that would be great. if not, by using PYTHON Operator or BASH operator in Airflow, would be helpful
Источник: https://stackoverflow.com/questions/780 ... ermination
