Solved

How to see segment information in data warehouse?

  • 10 February 2023
  • 2 replies
  • 26 views

Userlevel 2
Badge

We would like to see segment information in our data warehouse.

 

Is there already a field for this?

  • If so, which table would it be in?
  • If not, is there a way to get that information into our warehouse?

 

Thanks in advance,

Chase the Heapster

icon

Best answer by jonathan 11 February 2023, 00:59

View original

2 replies

Userlevel 5
Badge +3

Hey @Chase Sommer Loves Heap omg (baller handle btw 😂):

As of Jan 24, 2023, Heap supports segment exports for Redshift and Snowflake only. In both cases the segments will be materialized as views within the schema or database that the export creates. 

Segments must be enabled for export, and you can toggle the sync on and off just like you do with events, via the Definitions section of the app, or via the Integrations console by looking up the relevant warehouse destination.

If you are a BigQuery user, this use case is not currently supported but is on the roadmap. In the meantime, most segments can be trivially recreated in SQL, though some behavioral segments can be more complex. YMMV.

Userlevel 2
Badge

Yo Jonathan - thanks for the reply 😎

Luckily, my company uses Snowflake, so it looks like we can take advantage of this new feature.

 

 

Reply