Hello all, I am trying to load linkedin api data into the snowflake database. I have this type of json data, i want to create a table that has column present in elements and version means my columns will be

campaign_id.

and

versionTag

{
  "elements": {
    "campaign_id": 290954,
    "version": {
      "versionTag": "6"
    }
  }
}

I have created the json schema for it, this below schema created the columns

campaign_id

and

version

{
  "type": "object",
  "properties": {
    "campaign_id": {
      "type": "integer"
    },
    "version": {
      "type": "object",
      "properties": {
        "versionTag": {
          "type": "string"
        }
      }
    }
  }
}

how can i create the schema so it will create the columns

campaign_id

and

versionTag

OR is there any way to do so?