I'm encountering an issue when using bq extract command or just exporting table data into a Cloud storage bucket. I need to export all the fields surrounded by double quotes (")but I didn't find a way to do this.
When I manually put double quotes in data source ("field value") and export it using bq extract command, it surrounds data by 3 double quotes ("""field value"""), which is not what I need. Is there any way to do that ?
I'm encountering an issue when using
bq extract
command or just exporting table data into a Cloud storage bucket. I need to export all the fields surrounded by double quotes ("
)but I didn't find a way to do this. When I manually put double quotes in data source ("field value"
) and export it using bq extract command, it surrounds data by 3 double quotes ("""field value"""
), which is not what I need. Is there any way to do that ?