We currently save the timestamp of when a record is created in postgres in a column called @timestamp which is not ideal because we have to add extra quotes in queries to handle the special character. This also causes other issues when trying to define constraints in DBT using yml files. Given that we are no longer using Logstash there is no reason why we should continue using this column name.
njuguna-n
commented
4 months ago
We currently save the timestamp of when a record is created in postgres in a column called
@timestampwhich is not ideal because we have to add extra quotes in queries to handle the special character. This also causes other issues when trying to define constraints in DBT usingymlfiles. Given that we are no longer using Logstash there is no reason why we should continue using this column name.