Cant unload the matillion table data in the form of a tsv file

Matillion ETL
1

Me and my team are working to unload data to GCS in the form of a tsv file and as per documentation present here: https://documentation.matillion.com/docs/2748978#bigquery-properties, adding "/t" in the delimiter field should work but it gave us this error:

Exception: Field delimiter must be a single character, found:"/t".

 

2

We tried putting in tab in a lot of ways by doing different wrapping arround it like '/t' or "/t" and a couple of other solution but nothing worked. Finally we did this:

  1. Got into a previously created table component.
  2. Got into the table metadata field.
  3. Checked the box with Text mode present in the pop up of metadata field.
  4. Copied the tab between two entities.
  5. Pasted the same tab value in the delimiter field in the unload component. It worked!!

 

3

Hi @manoj.more​

It's awesome that you were able to figure it out. You are even more awesome for sharing your process with the Community!

Warmly,

Chika