{"action":"created","issue":{"url":"https://api.github.com/repos/DoSomething/quasar/issues/374","repository_url":"https://api.github.com/repos/DoSomething/quasar","labels_url":"https://api.github.com/repos/DoSomething/quasar/issues/374/labels{/name}","comments_url":"https://api.github.com/repos/DoSomething/quasar/issues/374/comments","events_url":"https://api.github.com/repos/DoSomething/quasar/issues/374/events","html_url":"https://github.com/DoSomething/quasar/issues/374","id":238957307,"number":374,"title":"Backfill Historical Northstar Records to Update Last_Accessed / Logged_in","user":{"login":"jamjensen","id":19572934,"avatar_url":"https://avatars0.githubusercontent.com/u/19572934?v=3","gravatar_id":"","url":"https://api.github.com/users/jamjensen","html_url":"https://github.com/jamjensen","followers_url":"https://api.github.com/users/jamjensen/followers","following_url":"https://api.github.com/users/jamjensen/following{/other_user}","gists_url":"https://api.github.com/users/jamjensen/gists{/gist_id}","starred_url":"https://api.github.com/users/jamjensen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jamjensen/subscriptions","organizations_url":"https://api.github.com/users/jamjensen/orgs","repos_url":"https://api.github.com/users/jamjensen/repos","events_url":"https://api.github.com/users/jamjensen/events{/privacy}","received_events_url":"https://api.github.com/users/jamjensen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"sheyd","id":4562565,"avatar_url":"https://avatars3.githubusercontent.com/u/4562565?v=3","gravatar_id":"","url":"https://api.github.com/users/sheyd","html_url":"https://github.com/sheyd","followers_url":"https://api.github.com/users/sheyd/followers","following_url":"https://api.github.com/users/sheyd/following{/other_user}","gists_url":"https://api.github.com/users/sheyd/gists{/gist_id}","starred_url":"https://api.github.com/users/sheyd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sheyd/subscriptions","organizations_url":"https://api.github.com/users/sheyd/orgs","repos_url":"https://api.github.com/users/sheyd/repos","events_url":"https://api.github.com/users/sheyd/events{/privacy}","received_events_url":"https://api.github.com/users/sheyd/received_events","type":"User","site_admin":false},"assignees":[{"login":"sheyd","id":4562565,"avatar_url":"https://avatars3.githubusercontent.com/u/4562565?v=3","gravatar_id":"","url":"https://api.github.com/users/sheyd","html_url":"https://github.com/sheyd","followers_url":"https://api.github.com/users/sheyd/followers","following_url":"https://api.github.com/users/sheyd/following{/other_user}","gists_url":"https://api.github.com/users/sheyd/gists{/gist_id}","starred_url":"https://api.github.com/users/sheyd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sheyd/subscriptions","organizations_url":"https://api.github.com/users/sheyd/orgs","repos_url":"https://api.github.com/users/sheyd/repos","events_url":"https://api.github.com/users/sheyd/events{/privacy}","received_events_url":"https://api.github.com/users/sheyd/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2017-06-27T19:29:45Z","updated_at":"2017-06-27T23:09:47Z","closed_at":null,"body":"_TASK_\r\n-------------------\r\n#### Description\r\nAs a Data Analyst I want all updated records from Northstar in the Quasar.Users table so that I can see the most up-to-date user info and the most recent time all users have accessed the site. \r\n\r\n#### Why This is Important\r\nBackfilling all Northstar records is necessary so that we have the most up-to-date user information for all user in Quasar.\r\n\r\n#### Definition of Done\r\n**Given** Sena completes the backfill of Northstar historical records\r\n**When** James queries the quasar users table \r\n**Then**  He should see updated records from early April 2017, when we started to collect data in Northstar. \r\n\r\n#### Additional Information\r\n- Currently, we ingest user information when a user creates an account. However, we do not ingest user information from Northstar when they update their profile. To be fixed in #373. \r\n\r\n- Ask Dave if we did a bulk migration of last_accessed info from phoenix db into Northstar. \r\n"},"comment":{"url":"https://api.github.com/repos/DoSomething/quasar/issues/comments/311511190","html_url":"https://github.com/DoSomething/quasar/issues/374#issuecomment-311511190","issue_url":"https://api.github.com/repos/DoSomething/quasar/issues/374","id":311511190,"user":{"login":"jamjensen","id":19572934,"avatar_url":"https://avatars0.githubusercontent.com/u/19572934?v=3","gravatar_id":"","url":"https://api.github.com/users/jamjensen","html_url":"https://github.com/jamjensen","followers_url":"https://api.github.com/users/jamjensen/followers","following_url":"https://api.github.com/users/jamjensen/following{/other_user}","gists_url":"https://api.github.com/users/jamjensen/gists{/gist_id}","starred_url":"https://api.github.com/users/jamjensen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jamjensen/subscriptions","organizations_url":"https://api.github.com/users/jamjensen/orgs","repos_url":"https://api.github.com/users/jamjensen/repos","events_url":"https://api.github.com/users/jamjensen/events{/privacy}","received_events_url":"https://api.github.com/users/jamjensen/received_events","type":"User","site_admin":false},"created_at":"2017-06-27T23:09:47Z","updated_at":"2017-06-27T23:09:47Z","body":"@sheyd can you include a link to the backfill? I can't find in among the Jenkins jobs. \r\n\r\nI've also noticed that there are 300k (and counting) fewer users with `customer_io_subscription_status` as subscribed since I last checked this morning. Can you please see if the backfill is overwriting subscriptions statuses, and if so, pause it? "}}
{"actor":{"display_login":"jamjensen"}}