Talk:Analytics/Data Lake/Edits/MediaWiki history

Schema as table

@Milimetric:: The first time I added the schema as a table, I did a bunch of regex replacing to convert the separating tabs to appropriate wiki-markup. This time, I figured out something easier: I pasted the describe output into a text editor, saved it as a .tsv, and dragged the file into the visual editor, which automatically converted it to a pretty table :) —Neil P. Quinn-WMF (talk) 18:20, 11 October 2017 (UTC)

event_type = user: difference between "event_user_something" and "user_something" fields

@Milimetric:: Question: when event_type = "user", what is the difference between using "event_user_something" and "user_something" fields? For example, one wants to have a look at the registration history at some wiki while filtering out bots and anonymous users. Where does one impose filters in that context: filtering out by "event_user_is_bot" or by "user_is_bot"? Thanks. --GoranSMilovanovic (talk) 17:15, 16 October 2018 (UTC)