ATTRIBUTION ( ON { table | view | (query) } [ AS InputTable1 ] PARTITION BY user_id ORDER BY times_column [ ON { table | view | (query) } [ AS InputTable2 ] PARTITION BY user_id ORDER BY time_column [,...] ] ON conversion_event_table AS ConversionEventTable DIMENSION [ ON excluding_event_table AS ExcludedEventTable DIMENSION ] [ ON optional_event_table AS OptionalEventTable DIMENSION ] ON model1_table AS FirstModelTable DIMENSION [ ON model2_table AS SecondModelTable DIMENSION ] USING EventColumn ('event_column') TimeColumn ('time_column') WindowSize ({'rows:K' | 'seconds:K' | 'rows:K&seconds:K2'}) ) ORDER BY user_id,time_stamp;
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement