The user's distinct_id. If you are sending Events to Mixpanel in addition to Profiles, this property value should be identical to the distinct_id property attached to events so that you can connect events to profiles. Tell me more about distinct_id.

Properties contain information about the profile. For example, for a user profile, properties can be things like an email address, where they came from, or their age. These properties allow you to drill down to very specific segments of users/customers and learn more.

Properties are sent as key-value pairs where the key is the property name and the value is the property value. Tell me more about properties.

Certain property keys are special/reserved. For example, if you include the $email property, you can start sending targeted email notifications using Mixpanel's Notifications product. Other examples of special properties are $name, $phone and $unsubscribed. Learn more about Special/Reserved properties .

Only trigger for query jobs that reference the selected table. Leave blank for all query job results.

The column to match against the value in the WHERE clause. The where clause will be WHERE column = value

The value to match against the column in the WHERE clause. The where clause will be WHERE column = value

A name for this Event. For example, 'Brand Mentioned in Tweet' or 'Payment Made'. Tell me more about Events.

A way to uniquely identify your users (or more generally, profiles). If you are sending Profiles to Mixpanel in addition to events, this property value should be identical to the Distinct ID property attached to the Profile so that you can connect events to people records. Tell me more about distinct_id.

Event Properties are bits of extra information that you send along with your Events describing the details of that action. They are usually specific to the Event they’re describing and don’t apply universally to other Events. Leveraging Event Properties allows you to conduct deeper analysis to better understand user behavior for a specific action. For example, a 'Song Added to Playlist' event could have 'Artist' and 'Playlist' as the properties. Properties are sent as key-value pairs where the key is the property name and the value is the property value. Tell me more about properties.

Use the + sign to add properties to this event.

Only columns that are type integer, bytes, int64, float, timestamp, date, datetime, numeric, bignumeric are returned. The column will be sorted in descending order. The latest row will be returned.

The unique column is used to determine if a row is new. For example if the unique column is id and the latest row has an id of 1, then the next time the trigger runs, if the latest row has an id of 2, then the trigger will return the row with an id of 2.

The column to match against the value in the WHERE clause. The where clause will be WHERE column = value

The value to match against the column in the WHERE clause. The where clause will be WHERE column = value

Rows must be an array of objects. Example [{'id': '1', 'name': 'Test'}, {'id': '2', 'name': 'Test2'}]

Insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist.