Warehouse destinations are the main way of getting direct access to the underlying Freshpaint data. Once you've set up a data warehouse, you can run SQL over the raw Freshpaint data.
identifycalls will go to the new warehouse automatically. To send events, you'll need to opt-in each event you want to send to the new warehouse destination.
Once configured, Freshpaint will sync data to your data warehouse every six hours.
For every event you send to a warehouse, Freshpaint will create a corresponding table. For example, if you send an event,
View Homepageto your warehouse, Freshpaint will create a table,
view_homepage, and load all the
View Homepageevents into it.
Event tables have a column for each custom property you send in your events. When a new custom property is added to an event, a new column will be added to the table for that property.
All event tables also have the following additional columns:
In addition to any event tables you create, Freshpaint will also create an
identifiestable with all the identify calls you made.
The table will also contain any user properties you send in your identify calls.
Freshpaint supports sending data to the following warehouses: