@yuhuisg I hear you. A few things that sometimes help: Add a Batch_ID to WHEREReplace SELECT * withSELECT [field1], [field2], [field3], [field4] Keep your LIMITIf you know you have a long running query, use CTAS  Hope that helps a little.

@navink386520 Can you post some screenshots of the schemas? I still think this will have a challenge with Profile since even if this works from a relationship standpoint, my expectations are that Segmentation will have some challenges resolving this 1:M relationship due to zip code having multiple e...

@askApr2014 If you are referring to how should your SQL look in Query Service, this is how you get the first element in the array: SELECT identitymap['ECID '][0].ID FROM dataset

@navink386520 To be used on Profile, Time-Series is meant to define an event for an individual, i.e. you need to attach it to an identity of a Profile.  Thus, in the Time-Series you need a Person identity.  You have zipcode as the identity. So, if you want to capture and use weather and apply it to ...

@navink386520 I think the way you are trying to use Weather as an Event, while clever, isn't going to work.  You would need to either: Duplicate the Event to everyone in the zipcode, giving each profile their own event ... OR Use if you want to capture the weather for everybody, everyday Make Weathe...

@Prap I would suggest if the AAM devices Data is the dataset that is causing the issue that you consider disabling it for Profile. Here is more about the datasets from AAM and what they do.  I have even gone so far as disabling additional datasets in some cases. https://experienceleague.adobe.com/do...

@deepakkv Going back through older posts.  From what I can tell CJA does this automatically.  Maybe something new?  I checked my instance and verified it matched what is in the Schema.  

@user05602 It is a bit unfortunate that the descriptions on those datasets aren't better.   Profile-Snapshot-Export-xxx (This schedule populates a system generated dataset that exports a snapshot of the Profile at that point in time.  Very handy, you should explore it with QS)Segmentdefinition-Snaps...

@stefanf4441679 Might be worth posting to Ideas: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform-ideas/idb-p/adobe-experience-platform-ideas  

@bitunsen A few things to troubleshoot this: Check the Event is on the Profile (you said it is)Check the value of the Price on the Lookup (you said you did)The segment is probably batch so make sure you have enabled the scheduleCreate another Segment(s) that do things like "price exists" or sku = xy...