pgsync
pgsync copied to clipboard
pgsync does not support index.settings
I am trying to use settings in mapping but no settings in Elasticsearch Data present in Elastic. PostgreSQL: 16.1 ES: 8.12.2
{
"database": "crm",
"index": "leads",
"settings": {
"analysis": {
"normalizer": {
"customNormalizer": {
"type": "custom",
"char_filter": [],
"filter": [
"lowercase"
]
}
},
"analyzer": {
"customAnalyzer": {
"type": "custom",
"char_filter": [
"html_strip"
],
"tokenizer": "standard",
"filter": [
"lowercase",
"stop"
]
}
}
}
},
"plugins": [
"Leads"
],
"mapping": {
"id": {
"type": "keyword"
},
"name": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"phone_country_id": {
"type": "keyword"
},
"agent_id": {
"type": "keyword"
},
"updated_at": {
"type": "date",
"format": "strict_date_optional_time"
},
"activities": {
"properties": {
"comment": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword"
}
}
},
"id": {
"type": "keyword"
},
"lead_id": {
"type": "keyword"
}
}
},
"contacts": {
"properties": {
"email": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"phone": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"pipelines": {
"properties": {
"id": {
"type": "keyword"
},
"code": {
"type": "keyword"
}
}
},
"pipeline_stages": {
"properties": {
"id": {
"type": "keyword"
},
"code": {
"type": "keyword"
}
}
}
},
"nodes": {
"table": "leads",
"schema": "public",
"columns": [
"id",
"name",
"email",
"phone",
"phone_country_id",
"updated_at",
"assignee_id"
],
"transform": {
"rename": {
"assignee_id": "agent_id"
}
},
"children": [
{
"table": "activities",
"columns": [
"id",
"lead_id",
"comment"
],
"relationship": {
"variant": "object",
"type": "one_to_many",
"foreign_key": {
"child": [
"lead_id"
],
"parent": [
"id"
]
}
}
},
{
"table": "pipelines",
"columns": [
"id",
"code"
],
"relationship": {
"variant": "object",
"type": "one_to_one",
"foreign_key": {
"child": [
"id"
],
"parent": [
"pipeline_id"
]
}
}
}
]
}
}
Sorry for the delay. I believe it is setting and not settings. Here is the DDL in the documentation