New Argument Google.Cloud.Bigquery.Magics ``--export_to_csv``

[googleapis]

New Argument Google.Cloud.Bigquery.Magics ``--export_to_csv``

[plamut]

@julioyildo A quick update - directly implementing the export-to-csv functionality in cell magic is not planned, but there are plans to add a dedicated "export API" on the backend. That API can then be integrated in cell magic.

It's not something that can be expected in the very near future, though.

[plamut]

@julioyildo It's not planned AFAIK, but exporting data as CSV actually sounds as something that quite a few people might find useful (IMHO). I will bring up the proposal at the next meeting.

Also, thanks for the detailed specs and even a sample implementation!

[plamut]

@NI1993 I can ask if anything has changed in this regard, will post any updates under your feature request.

Edit: I see that the original feature request is about the Jupyter notebook cell magic, thus thanks for opening a new request.

[julioyildo]

Thank you @plamut ! :)

[NI1993]

@julioyildo A quick update - directly implementing the export-to-csv functionality in cell magic is not planned, but there are plans to add a dedicated "export API" on the backend. That API can then be integrated in cell magic.

It's not something that can be expected in the very near future, though.

@plamut Any updates that you know of regarding this feature?

It would be extremely helpful for me as well.

[NI1993]

@plamut Thanks, Highly appreciated!

[shollyman]

Revisiting this FR as it's languished for a bit.

I'm going to close this out, as this seems like a clear win for the EXPORT DATA statement to get query results quickly and easily to a CSV file in GCS.

https://cloud.google.com/bigquery/docs/exporting-data#sql for examples of using this, but the core idea is that you can run exports via the query language, rather than needing to accomplish this in two stages.