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

How to add _FILE_NAME pseudo column in Table Input component?

I'm using BigQuery external table as Table Input, how can I include the _FILE_NAME pseudo column? I tried using the Calculator component but it does not recognize the _FILE_NAME expression.

I need to store the filename because it contains some information that I need to parse.

Thank you.

Kind regards,

-R-

1 Community Answers

Matillion Agent  

Paul Johnson —

Hi Rangga,

You do this by using the SQL component.

An example query is
SELECT _FILE_NAME as fn FROM `project`.`dataset`.`table`

Regards,
Paul

Post Your Community Answer

To add an answer please login