incoming_eventtable. This table has a number of columns that correspond to the built-in data Freshpaint collects and you will have access to an additional JSON column called
propswhere you will have access to any custom properties. The full schema of the
incoming_eventtable is described here.
incoming_eventtable. Your query should return either a single row or now rows. Any columns returned by your query will be attached to the event as custom properties. If your query returns zero rows, the event will filtered out and not sent to any destinations. As an example, the query:
example_propwith the value
10. If you return
NULLfor the value of a property, that property will instead be deleted.
event_name- When you return this from a query, the name of the event will become the provided value.
user_id- When you return this from a query, the user_id of the event will become the provided value.
SQL:. If the incoming event name is
Login, the transformed event will have the name
new_propertyan always sets it to the value
sensitive_identifierfrom the event. This is done by setting the value of the property to
incoming_eventtable has the following schema: