hi everyone, I am trying to extract tap-pokeapi. but don't know how we can manage array json

"abilities": [
    {
      "ability": {
        "name": "limber",
        "url": "<https://pokeapi.co/api/v2/ability/7/>"
      },
      "is_hidden": false,
      "slot": 1
    },
    {
      "ability": {
        "name": "imposter",
        "url": "<https://pokeapi.co/api/v2/ability/150/>"
      },
      "is_hidden": true,
      "slot": 3
    }
  ]

I want to get the names from each array

@vishwas_saini I think usually this would be a use case for something like dbt. You'd replicate your data to your destination is close to raw format then use dbt to parse it whatever way you'd like, in your case pulling out the names. I know with snowflake this is easy to do with the semi structured query options https://docs.snowflake.com/en/user-guide/querying-semistructured