Skip to content

Instantly share code, notes, and snippets.

@konstantint

konstantint/dsw-3.sql

Created December 2, 2018 02:52
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/e560bfab8eca7fa0a9a3815ef5e5d7f9 to your computer and use it in GitHub Desktop.
Save konstantint/e560bfab8eca7fa0a9a3815ef5e5d7f9 to your computer and use it in GitHub Desktop.
Download ZIP
The Data Science Workflow blogpost, snippet 3
Raw
dsw-3.sql
with _BehaviourFeatures as (
... inline the view definition ...
),
_ProfileFeatures as (
... inline the view definition ...
),
_ModelInputs as (
... concatenate the feature columns ...
)
select
Key,
1/(1.0 + exp(-1.2 + 2.1*Feature1 - 0.2*Feature3)) as Prob
from _ModelInputs
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment