We are using debezium to get data from oracle to dremio

hello dremio team,
we are using debezium to get data from oracle to debezium iceberg to aws s3 within aws glue to dremio in which we are finding difficult to convert this struct datatype of value in dremio,
please find screenshots to understand properly.


Thank you,
Dhruv

@mevadadhruv Hover your mouse in one of the cells inside DEPARTMENT_ID (towards the right), you will see three dots, click on that and use extract. Dremio will extract the cell you need and you can see the SQL

For example if we need to extract accelerated column from the accelerationProfile struct you need to do profile_attempt_0.accelerationProfile.accelerated AS accelerated