pgsync icon indicating copy to clipboard operation
pgsync copied to clipboard

pgsync does not support index.settings

Open oleg4646 opened this issue 11 months ago • 1 comments

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"
            ]
          }
        }
      }
    ]
  }
}

oleg4646 avatar Jan 27 '25 12:01 oleg4646

Sorry for the delay. I believe it is setting and not settings. Here is the DDL in the documentation

toluaina avatar May 25 '25 11:05 toluaina