https://community.databricks.com/t5/data-engineering/on-the-fly-transformations-on-dlt-tables/m-p/67441#M33341 <P>Hi,&nbsp;</P><P>I am loading data from a kinesis data stream using DLT.&nbsp;</P><LI-CODE lang="markup">CREATE STREAMING TABLE Consumers_kinesis_2 ( ..., unbase64(data) String, ... ) AS SELECT * FROM STREAM read_kinesis (...)</LI-CODE><DIV><DIV>&nbsp;</DIV><DIV>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.</DIV><DIV>&nbsp;</DIV><DIV>best and thanks in advance,</DIV><DIV>Mathias&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Fri, 26 Apr 2024 19:54:15 GMT Mathias_Peters 2024-04-26T19:54:15Z https://community.databricks.com/t5/data-engineering/on-the-fly-transformations-on-dlt-tables/m-p/67441#M33341 <P>Hi,&nbsp;</P><P>I am loading data from a kinesis data stream using DLT.&nbsp;</P><LI-CODE lang="markup">CREATE STREAMING TABLE Consumers_kinesis_2 ( ..., unbase64(data) String, ... ) AS SELECT * FROM STREAM read_kinesis (...)</LI-CODE><DIV><DIV>&nbsp;</DIV><DIV>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.</DIV><DIV>&nbsp;</DIV><DIV>best and thanks in advance,</DIV><DIV>Mathias&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Fri, 26 Apr 2024 19:54:15 GMT https://community.databricks.com/t5/data-engineering/on-the-fly-transformations-on-dlt-tables/m-p/67441#M33341 Mathias_Peters 2024-04-26T19:54:15Z