hey! I wonder if there is a standard (or recommended) way of getting the properties of our events directly as a JSON column (in my case,

variant

since I’m using Snowflake) in the

tracks

table. This would be extremely helpful since we have tons of events and is a huge pain to try and join all different properties from different tables in a single one. I found this old discussion but I wonder if we have any new developments on this in the past 6 months?

Hi @famous-tiger-19427, thanks for starting this discussion. You can use user transformations here. Is there any issue with that approach? Do you have any suggestions for a new solution?

@gentle-petabyte-80785 could you elaborate on the above solution

I'm assuming that you have doubt about json column support for snowflake, is that so? Yes, JSON column is supported and here's a complete guide how to use them https://www.rudderstack.com/docs/destinations/warehouse-destinations/json-column-support/ If you have questions about transformations, here's a guide on how to use them https://www.rudderstack.com/docs/features/transformations/