Populating Flex table Materialized columns from current data in __raw__
The documentation for Flex tables includes information to "promote virtual columns to materialized (real) columns":
The example given adds the promoted column and then loads data to populate it. However, we have a large amount of data already loaded into a Flex/hybrid table and wish to add the column and populate the materialized column from the data already loaded.
This sounds like it should be possible, but I have not found a way to do this. i.e. add the column and then populate it from the data already contained in the raw column. Any tips?