Using different target database schema for different set of events

For engineers Collectors
1

Hi Team,

I wanted to use different target database schema for events that are generated by 2 different applications using same snowplow pipeline(aws).

for eg:
App A → snowplowdb.App_A_events
App B → snowplowdb.App_B_events

Currently by default all the events are going into snowplowdb.atomic schema.

Just wanted to know if we can create a separate database schema like this and if there is a way to specify to which table the events should be loaded?
And is there way to use custom names for tables generated by self describing events?

2

Hi @Nidhish,

Currently, the answer is “no” to both questions, I’m afraid. However, you can create views within your desired schemas and with your designed naming. Of course, there is the downside that the view would need to be updated when you introduce new event types.

1 Like