Self-describing events table creation

For engineers
1

Hi Team,
I deployed Snowplow locally and wanted to start different tests.
Using given Schemas from Snowplow it works well. But I wanted to test a self describing event, which I pushed to iglu and works so far till the data is copied to Redshift. The upload fails due tu “Cannot COPY into nonexistent table”. I thought, that the first time we send data for a new Schema, the Table is created? Is this not the case? Should we create the table manually each time?
If I look into the logs, the table creation process is started and completed with sucess.

table_created
table_created1286×203 31.7 KB

But some logs later we have this:
image
image1180×93 4.02 KB

2

I suspect maybe you have hit an issue where camelCasing in your vendor name has created a discrepancy between your schema name and your table name as camelCasing in the schema is converted to snake_case.

Can you try and use something like com.sevdesk/test2/jsonschema/1-0-0 as your schema name without any camelCasing?

3

@ebnermic Could you tell me which version you are using ?

4

I will test this, thanks for the idea!!

5

I guess you mean the version of the rs-loader? It is 0.1.4

6

Thanks @mike the camelCasing was in fact the issue!!