This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Adding Created & updated Timestamps columns in Data Fusion pipeline using wrangler

Posted on 06-14-2024 04:02 AM
Naveen_kumar
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hi GCP Community,

I'm currently working with Data Fusion and have set up a pipeline to transfer data from SQL server to BigQuery using Wrangler. I'm looking to add two columns, created_timestamp and updated_timestamp with the current timestamp in each row. I attempted to use JEXL in Wrangler with the following transformation: "set-column: created_timestamp now()".

However, this doesn't seem to work. Could anyone provide guidance or examples on how to achieve this?

Thanks in advance for you help!

Best regards,

Naveen.

4 3 904
Topic Labels
3 REPLIES 3
Top Solution Authors
View all