Hello Luca,
Currently with the API you would need to specify the column names when exporting, when as you mentioned you are not aware of the name(s) or number of columns it can be difficult.
There is an existing public feature request to have the table headers included in the export which can be viewed here[1]. There is no ETA nor a guarantee this feature request will be implemented in the future.
I suggest you to up vote the feature request (click on the plus 1 button), this will help the engineering team to know that there are more users interested in this feature request. You can also star the feature request in order to receive any updates should there be any posts.
[1] https://issuetracker.google.com/111342008
On Tuesday, May 26, 2020 at 12:53:43 PM UTC-4, Luca Vlad wrote:
Hello, I am using the REST API for exporting the data from a SQL Cloud db into a csv on a bucket. Documentation for the API is : Cloud SQL to CSV. A further explanation of the request body parameters is found here: REST API request. Because my data contains ',' I want to change the default deliminator into '|' . Also I want my csv file to include a header line (table columns names). Do you guys know anything that can help?Thank you very much!
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9ae408da-7722-4b61-8ef9-89b5bf62e47b%40googlegroups.com.
No comments:
Post a Comment