Skip to main content
Solved

Mapping event data from Snowflake into amplitude (Preserving device info)

  • November 16, 2022
  • 1 reply
  • 333 views
A

Hey there!

 

I’m attempting to pull in historical event data previously captured with segment into a new amplitude project so that we can analyze usage on web vs. mobile.

 

I’ve successfully connected snowflake into amplitude, but I am unsure how to structure the query as as to preserve and correctly pass in the user agent data.

 

I have a field called context_user_agent in snowflake which contains the raw data passed in from segment data formatted as such: 

 

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36

 

What field should I map this to in amplitude to be able to use the amplitude functional of segmenting on “platform” for instance?

Best answer by Saish Redkar

Hey @alalpert 

From what I know, the Snowflake import doc doesn’t directly mention this field except for the mandatory fields required for importing data.

From my conversations with the Snowflake Ingest team, I think that their snowflake ingest pipeline leverages their batch event upload API internally ( I could be wrong here ).

So the best bet would be to parse your user agent string to the appropriate platform values ( iOS, Web,etc ) and try setting that as the ‘platform’ property / column in your snowflake import query.

You can take cues from this event load.

Let me know if this works out.

 

 

 

View original
Satya Akkinapragada
1 person likes this
  • Satya Akkinapragada
    Satya Akkinapragada
Did this topic help you find an answer to your question?

1 reply

Saish Redkar
Expert
Forum|alt.badge.img+10
  • Saish Redkar
  • Expert
  • 1377 replies
  • Answer
  • November 16, 2022

Hey @alalpert 

From what I know, the Snowflake import doc doesn’t directly mention this field except for the mandatory fields required for importing data.

From my conversations with the Snowflake Ingest team, I think that their snowflake ingest pipeline leverages their batch event upload API internally ( I could be wrong here ).

So the best bet would be to parse your user agent string to the appropriate platform values ( iOS, Web,etc ) and try setting that as the ‘platform’ property / column in your snowflake import query.

You can take cues from this event load.

Let me know if this works out.

 

 

 

Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills
jarren.patao
Jeremie Gluckman
2 people like this
  • jarren.patao
    jarren.patao
  • Jeremie Gluckman
    Jeremie Gluckman

Reply


Helpful Members this Week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings