SD_DATA_ROUTING

The data routing product is used to route event data from Simon into your Snowflake instance. There is one “pipe” per data source (i.e. Simon Signal and Data Feeds).

During general Simon onboarding, we create one file format: NLJSON (new line delimited JSON).

When onboarding each data source, we create the following:

• One pipe per source: _DATA_ROUTING_<INTEGRATION>_EVENTS_PIPE
• One stage per source: _DATA_ROUTING_<INTEGRATION>_EVENTS_STAGE
• One table per source: _DATA_ROUTING_<INTEGRATION>_EVENTS

For each event type in the data that gets routed to Snowflake, we create one view that’s filtered to the specific event type: _DATA_ROUTING_VIEW_<INTEGRATION>_<EVENT_TYPE>_EVENTS