The questdb sink is not working

[Ahmadmsbelbeisi]

Hello, thank you for the amazing work, however , I can't manage to see data in the questdb , both moving average and getdata.py are working but the data are not getting into questdb.

Any suggestions ? does it work for you ?

how to make it work ?

[Yitaek]

Hi @Ahmadmsbelbeisi you can check out this blogpost with more detailed instructions: https://redpanda.com/blog/real-time-crypto-tracker-questdb-redpanda .

[Ahmadmsbelbeisi]

I checked it, still does not work, I think the tutorial is missing something, because I can't see any table in questdb, the producer and consumer are both working correctly. However, there is no sink to the database.

[Yitaek]

You can try manually creating the tables on QuestDB before configuring the sinks. Perhaps the newer versions of QuestDB/Debezium doesn't auto-create tables for you

[qualitativeanalyst]

Hi guys! Maybe I experience a similar error.
@Ahmadmsbelbeisi have you checked the connector's status after running getdata.py?
In my case
curl http://localhost:8083/connectors/postgres-sink-link/status
returns a lengthy error message, but as far as I see, the point
Caused by: org.apache.kafka.connect.errors.DataException: Unknown schema type: timestamp
is crucial.
Have you solved the issue in the meantime?

[ahmadbelb]

From My experience, I tried to solve this issue for over a week and then I gave up and moved to something else.
Unfortunately, the tutorial and documentation are extremely not clear and leave you questioning things most of the time
If you happen to find a answer please post it here and maybe the author should include it in the tutorial or docs

Best