Pulsar IO JDBC Postgres Sink with datetimes

[wybrenoppedijk]

I am trying to sink messages from a topic to a PostgreSQL database. The messages have the following schema:

{
  "type": "record",
  "namespace": "dk.test",
  "name": "Measurement",
  "fields": [
    {
      "name": "sensor_id",
      "type": "string"
    },
    {
      "name": "tenant_id",
      "type": "string"
    },
    {
      "name": "timestamp",
      "type": {
        "type": "long",
        "logicalType": "timestamp-micros"
      }
    },
    {
      "name": "value",
      "type": "double"
    }
  ]
}

The messages should end up in a table that looks like this:

CREATE TABLE IF NOT EXISTS Measurement (
    timestamp TIMESTAMP NOT NULL,
    sensor_id UUID NOT NULL,
    value DOUBLE PRECISION NOT NULL,
    tenant_id UUID NOT NULL
);

Problem

The default Pulsar PostgreSQL sink deserializes the timestamp field to a BigInt, which results in an error when PostgreSQL expects a TIMESTAMP type.

Question

Can the timestamp field be mapped from the message schema to the TIMESTAMP type in PostgreSQL to avoid this deserialization issue? Or is the only way to use a BigInt type for timestamp in the PostgreSQL table?