SQL Traits Course

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

About this course

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. 

Curriculum

  • 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

About this course

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. 

Curriculum

  • 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