SELECT source_column:elements[0].name::STRING AS first_name
FROM your_table;
```_

SELECT source_column:elements[0].name::STRING AS first_name
FROM your_table;
```_