On the fly transformations on DLT tables
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-26-2024 12:54 PM
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
