Hi! I want to Query SQL server table and store the results in csv format in GS. What component should I use? The Query Database component have a staging area in GS - if I do not use the "auto clean" is it possible to decide the format of the staged file? What format is per default? Cheers, Cris
2 Community Answers
Kalyan Arangam —
By GS, i assume you mean Google Cloud Storage?
The files created in GCS are JSON and you should be able to open them in a text editor. Unfortunately, its not possible to change or choose the format of these files.
Once data is in BigQuery, you are able to use the Cloud-Storage-Unload component which then allows you to choose between CSV, AVRO and JSON.
Does that help with your use case?