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

niall_woodward

08/24/2021, 9:04 AM
Hey team - I'm currently developing a tap using the SDK (which is superb), using pipelinewise-target-snowflake as the target. I'm wondering how I can define the tap schema where a field has no strict schema. To be more specific, I'm building a stream for this resource which has a property 'value', for example:
Copy code
[
  {
    "id":250616,
    "field_id":337,
    "list_entry_id":null,
    "entity_id":38706,
    "value":{
      "city":"San Francisco",
      "state":"California",
      "country":"United States",
      "continent":null,
      "street_address":null
    }
  },
  {
    "id":250615,
    "field_id":1284,
    "list_entry_id":null,
    "entity_id":38706,
    "value":"Computer Software"
  },
  {
    "id":32760,
    "field_id":198,
    "list_entry_id":null,
    "entity_id":38706,
    "value":38659
  },
  {
    "id":177634,
    "field_id":751,
    "list_entry_id":605,
    "entity_id":38706,
    "value":{
      "id":71,
      "text":"Low",
      "rank":1,
      "color":4
    }
  },
  ...
]
where
value
can be an integer, string or object. Is this possible?