Skip to content

Instantly share code, notes, and snippets.

@konstantint
Created December 2, 2018 02:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save konstantint/b0e7d3af4943d8b472b70f18e77de97c to your computer and use it in GitHub Desktop.
Save konstantint/b0e7d3af4943d8b472b70f18e77de97c to your computer and use it in GitHub Desktop.
The Data Science Workflow post, snippet 2
select
s.Key
v1.AverageTimeSpent,
v1.NumberOfClicks,
v2.Country
v3.Purchase as Target
from vw_TrainSample s
left join vw_BehaviourFeatures v1 on v1.Key = s.Key
left join vw_ProfileFeatures v2 on v2.Key = s.Key
left join vw_TargetFeatures v3 on v3.Key = s.Key
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment