How can I apply a function to entire table?

Hello everybody!

I’ve started working with Dremio a few days ago and I am actually testing it. My question is: how can I apply a function to entire table? I am reading a Parquet file and it has some columns base64 encrypted so I need to convert it to UTF8. I got success to convert one column to UTF8 (by select the calculated field option and use the CONVERT_FROM function) but not in the entire table.

Thank you.


When you say not entire table, do you mean not all rows. Best is to apply the function and save as a VDS. Once you save as VDS , you have to choose run instead of preview. Then on the UI job screen if you see that results were truncated then use JDBC client