https://linen.dev logo
#singer-tap-development
Title
# singer-tap-development
m

monika_rajput

03/21/2023, 10:19 AM
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
Copy code
{
  "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
Copy code
{
  "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?