- Getting started with SQL Traits
-
What are SQL Traits?
-
When should SQL Traits be used?
-
Connecting your database to Personas
-
Writing the SQL for a SQL Trait
-
Connecting a Destination to a SQL Trait
- Under the hood
-
How is SQL Trait data sent to Destinations?
-
How to inspect SQL Trait data
-
Which fields are included in events fired from a SQL Trait?
-
SQL Trait Compute Time
- Tips, tricks and gotchas
-
Avoid SQL traits that update every row every time
-
Avoid complex or long running queries
-
Delete or disable SQL Traits you no longer need
-
Limited number of SQL Traits
-
Usage events cannot be imported via SQL Traits
- Advanced topics
-
Sending track() calls to Destinations from SQL Traits
-
Sending group() calls to Destinations from SQL Traits
Consulting Partner - SQL Traits Course
Learn how to pull user and account profile data from your database into Segment, and then forward that data on to other Destinations
SQL Traits is a capability that enables user and account profile data stored in a database to be synced into Segment on a regular basis. The traits can then be used as inputs into Computed Traits or Audiences, or they can be forwarded downstream to connected Destinations.
In this Course you'll learn what a SQL Trait is, when they should be used, how to configure them, and how to route the data to Destinations.