On the fly transformations on DLT tables

[Mathias_Peters]

Hi, 

I am loading data from a kinesis data stream using DLT. 

CREATE STREAMING TABLE Consumers_kinesis_2
(
...,
unbase64(data) String,
...
)
AS
SELECT * FROM STREAM read_kinesis (...)

Is it possible to directly cast, unbase64, and/or transform the resulting attributes before writing them into the streaming table? I'd like to interpret the data aatribute of the kinesis stream which is binary but contains JSON.

best and thanks in advance,

Mathias