Skip to content

Instantly share code, notes, and snippets.

@konstantint

konstantint/dsw-2.sql

Created December 2, 2018 02:50
Show Gist options
  • Save konstantint/b0e7d3af4943d8b472b70f18e77de97c to your computer and use it in GitHub Desktop.
Save konstantint/b0e7d3af4943d8b472b70f18e77de97c to your computer and use it in GitHub Desktop.
Download ZIP
The Data Science Workflow post, snippet 2
Raw
dsw-2.sql
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