Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen
Last active August 29, 2015 14:06
Show Gist options
  • Save PMeinshausen/f5db870c53700d8217a1 to your computer and use it in GitHub Desktop.
Save PMeinshausen/f5db870c53700d8217a1 to your computer and use it in GitHub Desktop.
--Syntax (Single Input function version 1.0)
SELECT * FROM attribution
(
ON {input_table | view | query}
PARTITION BY expression [, ...]
ORDER BY order_by_columns
EVENT_COLUMN_NAME('event_column')
CONVERSION_EVENT_TYPE_VALUE('click1', 'click2', ...)
[EXCLUDING_EVENT_TYPE_VALUE('email')]
[OPTIONAL_EVENT_TYPE_VALUE('optional1', 'optional2')]
TIMESTAMP_COLUMN_NAME('timestamp_column')
WINDOW('rows:K | seconds:K | rows:K&seconds:K')
MODEL1('TYPE', 'K|EVENT:WEIGHT:MODEL:PARAMETERS', ...)
[MODEL2('TYPE', 'K|EVENT:WEIGHT:MODEL:PARAMETERS', ...)]
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment