Hi everyone, I woul like to do the freshness and v...
# community-support
b
Hi everyone, I woul like to do the freshness and volume test on tables that don't have a timestamp field. Those table have instead three columns, day month and year. How can i concatenate the columns in the timestamp_column ?
Is this correct?
Copy code
timestamp_column: "year || '-' || month || '-' || day"
o
Hey @bebbo203, you would need to convert the values to timestamp in order for this to work, e.g - in snowflake you can use the to_timestamp function:
Copy code
timestamp_column: "to_timestamp(year || '-' || month || '-' || day)"