1. To extract nested data from columns and arrays in a view or table creation, you can use JSONB data type for the nested array.

2. Update the source schema to use JSONB for the 'Fields' column:

CREATE SOURCE user_profile (
    data STRUCT <
        integration VARCHAR,
        crm STRUCT < EntityName VARCHAR, Fields JSONB[] >
    >
) WITH (
    connector = 'kafka',
    ..........

3. Use the JSONB data type to access the nested columns and arrays in your SELECT statement:

CREATE TABLE user_contact AS
SELECT
(data).crm.Fields[3]->>'Name' AS field_name,
(data).crm.Fields[3]->>'Value' AS field_value
FROM user_profile
WHERE (data).crm.EntityName = 'contact';