Flutter of snowplot cannot get data

For engineers
1

I posted a dialog_view The version is 1-0-0 and is used in flutter. Tables can be created in PostgreSQL, but I upgraded the version to 2-0-0. The tables cannot be created and there is no error message

1-0-0

{
    "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
    "description": "schema for dialog",
    "self": {
            "vendor": "com.latibac",
            "name": "dialog_view",
            "format": "jsonschema",
            "version": "1-0-0"
    },
    "type": "object",
    "properties": {
        "open_at": {
            "type": "string",
            "maxLength": 1024
        }, 
        "window_name": {
            "type": "string",
            "maxLength": 1024
        },
        "url": {
            "type": "string",
            "maxLength": 1024
        },
        "duration": {
            "type": "string",
            "maxLength": 1024
        } 
    },
    "required": ["open_at","window_name","url","duration"],
    "additionalProperties": false
    }

2-0-0

{
    "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
    "description": "schema for dialog",
    "self": {
            "vendor": "com.latibac",
            "name": "dialog_view",
            "format": "jsonschema",
            "version": "2-0-0"
    },
    "type": "object",
    "properties": {
        "open_at": {
            "type": "string",
            "format": "date-time"
        }, 
        "window_name": {
            "type": "string",
            "maxLength": 1024
        },
        "url": {
            "type": "string",
            "maxLength": 1024
        },
        "duration": {
            "type": "string",
            "maxLength": 1024
        } 
    },
    "required": ["open_at","window_name","url","duration"],
    "additionalProperties": false
    }

image

2

Is there an error for the table creation? The table creation logic should throw an error if the table cannot be created.

Have you sent an event into the pipeline for the 2-0-0 event?

3

I have entered the docker container of “pg-enrich” and read the log. There are no errors related to this table

I’m sure I sent a 2-0-0 event in the flitter.

4

In addition, I used function to print the record of topic in GCP pub sub

In “Sp-raw-topic”, I can find “dialog_view/2-0-0” in the JSON of context

but In the record of “SP-enriched-topic”, the data of “dialog_view/2-0-0” is missing

5

When we use it, if a new schema event is triggered for the first time, snowplot will create a table in PostgreSQL by itself

6

Do you have a record of dialog_view in the enriched good Pub Sub topic? The raw topic will contain almost all events as data in raw hasn’t been validated against any custom schemas yet.

7

Sorry, I re queried the output of enrich. There are records, but there is still no data in the database

{"schema":"iglu:com.snowplowanalytics.snowplow/contexts/jsonschema/1-0-1","data":[{"schema":"iglu:com.latibac/dialog_view/jsonschema/2-0-0","data":{"open_at":"2022-03-22T11:19:37.797635","duration":"1","window_name":"","url":"welcome"}}}

Sorry, I re queried the output of enrich. There are records, but there is still no data in the database