Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Component to create file on GS?

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

Matillion Agent  

Kalyan Arangam —

Hi Cris,

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?

Best
Kalyan


Cristian Ivanoff —

Hi Kalyan,
Yes I meant Google Cloud Storage.

Thanks for your answer.
cheers,
Cris

Post Your Community Answer

To add an answer please login