bigquery_hubspot_fields.json

[
  { "name": "contact_id", "type": "INTEGER", "mode": "REQUIRED" },
  { "name": "firstname", "type": "STRING" },
  { "name": "lastname", "type": "STRING" },
  { "name": "client_address", "type": "STRING" },
  { "name": "gender", "type": "STRING" },
  { "name": "level_of_dependence", "type": "STRING" },
  { "name": "cg_rank", "type": "STRING" },
  { "name": "update_date", "type": "INTEGER" },
  { "name": "special_request_free_text", "type": "STRING" },
  { "name": "mobility", "type": "STRING" },
  { "name": "area", "type": "STRING" },
  { "name": "medical_condition", "type": "STRING" },
  { "name": "status", "type": "STRING" },
  { "name": "phone", "type": "STRING" },
  { "name": "caregiver_gender", "type": "STRING" },
  { "name": "end_date", "type": "INTEGER" },
  { "name": "service", "type": "STRING" },
  { "name": "weight_group", "type": "STRING" },
  { "name": "relationship", "type": "STRING" },
  { "name": "language", "type": "STRING" },
  { "name": "source", "type": "STRING" },
  { "name": "email", "type": "STRING" },
  { "name": "clients_email", "type": "STRING" },
  { "name": "client_number", "type": "INTEGER" },
  { "name": "client_name", "type": "STRING" },
  { "name": "age_group", "type": "STRING" },
  { "name": "createdate", "type": "INTEGER" },
  { "name": "cd_termination_reason", "type": "STRING" }
 ]