How to convert Time data type in Data Fusion?

[murali2]

Hi everyone,

I'm trying to load a CSV file from a GCS bucket to BigQuery while performing some transformations using Cloud Data Fusion. I have a column named "BILL_TIME" that contains time details in HH:mm format. I want to load this column into a BigQuery table with the TIME data type. Unfortunately, I haven't found a way to convert the string data type of the BILL_TIME column to the TIME data type.

Here are the details:

• Current Data: The BILL_TIME column in my raw data is in the format "HH:mm" (e.g., 14:30).
• Expected Data Type in BigQuery: TIME

I would appreciate any guidance on how to achieve this conversion. Below are screenshots of my raw data and the expected data type in BigQuery for reference.

Thanks in advance!

Best regards,
Murali