Events do not load to Postgres

For engineers
1

Hello,

I am using Snowplow Open Source Quick Start and I successfully deployed everything on AWS.

After sending the test event and some other oage_view events, I can see the event in S3 bucket but the postgresDB still empty!

Any help please!

Thank you

2

Hi @AbdelilahJb ,

Welcome to Snowplow community !

The fact that you can see files on S3 means that enrich is working, so the issue probably comes from Postgres loader. Could you check its logs to see if it contains any error please ?

3

Hello @BenB

Thank you for your reply, where can I find the Postgres loader logs?

Thank you

4

UPDATE:
I found this logs, maybe thet are the cause:

image
image1833×553 138 KB

5

It looks like your Iglu URI for your webpage schema is missing a protocol (i.e., a trailing http:// or https:// depending on your load balancer).

4 Likes