{"action":"created","issue":{"url":"https://api.github.com/repos/snowplow/snowplow/issues/1522","labels_url":"https://api.github.com/repos/snowplow/snowplow/issues/1522/labels{/name}","comments_url":"https://api.github.com/repos/snowplow/snowplow/issues/1522/comments","events_url":"https://api.github.com/repos/snowplow/snowplow/issues/1522/events","html_url":"https://github.com/snowplow/snowplow/issues/1522","id":62455673,"number":1522,"title":"Simplify LookML model and make it consistent with Redshift data models","user":{"login":"yalisassoon","id":201147,"avatar_url":"https://avatars.githubusercontent.com/u/201147?v=3","gravatar_id":"","url":"https://api.github.com/users/yalisassoon","html_url":"https://github.com/yalisassoon","followers_url":"https://api.github.com/users/yalisassoon/followers","following_url":"https://api.github.com/users/yalisassoon/following{/other_user}","gists_url":"https://api.github.com/users/yalisassoon/gists{/gist_id}","starred_url":"https://api.github.com/users/yalisassoon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yalisassoon/subscriptions","organizations_url":"https://api.github.com/users/yalisassoon/orgs","repos_url":"https://api.github.com/users/yalisassoon/repos","events_url":"https://api.github.com/users/yalisassoon/events{/privacy}","received_events_url":"https://api.github.com/users/yalisassoon/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/snowplow/snowplow/labels/5.%20Analytics","name":"5. Analytics","color":"d99694"}],"state":"open","locked":false,"assignee":{"login":"bogaert","id":1975872,"avatar_url":"https://avatars.githubusercontent.com/u/1975872?v=3","gravatar_id":"","url":"https://api.github.com/users/bogaert","html_url":"https://github.com/bogaert","followers_url":"https://api.github.com/users/bogaert/followers","following_url":"https://api.github.com/users/bogaert/following{/other_user}","gists_url":"https://api.github.com/users/bogaert/gists{/gist_id}","starred_url":"https://api.github.com/users/bogaert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bogaert/subscriptions","organizations_url":"https://api.github.com/users/bogaert/orgs","repos_url":"https://api.github.com/users/bogaert/repos","events_url":"https://api.github.com/users/bogaert/events{/privacy}","received_events_url":"https://api.github.com/users/bogaert/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/snowplow/snowplow/milestones/77","html_url":"https://github.com/snowplow/snowplow/milestones/Release%2064%20Palila","labels_url":"https://api.github.com/repos/snowplow/snowplow/milestones/77/labels","id":971446,"number":77,"title":"Release 64 Palila","description":"Our first release focused on data modeling","creator":{"login":"alexanderdean","id":200511,"avatar_url":"https://avatars.githubusercontent.com/u/200511?v=3","gravatar_id":"","url":"https://api.github.com/users/alexanderdean","html_url":"https://github.com/alexanderdean","followers_url":"https://api.github.com/users/alexanderdean/followers","following_url":"https://api.github.com/users/alexanderdean/following{/other_user}","gists_url":"https://api.github.com/users/alexanderdean/gists{/gist_id}","starred_url":"https://api.github.com/users/alexanderdean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alexanderdean/subscriptions","organizations_url":"https://api.github.com/users/alexanderdean/orgs","repos_url":"https://api.github.com/users/alexanderdean/repos","events_url":"https://api.github.com/users/alexanderdean/events{/privacy}","received_events_url":"https://api.github.com/users/alexanderdean/received_events","type":"User","site_admin":false},"open_issues":19,"closed_issues":5,"state":"open","created_at":"2015-02-09T09:58:35Z","updated_at":"2015-04-16T12:22:30Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-03-17T16:48:12Z","updated_at":"2015-04-16T12:22:30Z","closed_at":null,"body":"There may be opportunities to simplify and clarify the LookML [here](https://github.com/snowplow/snowplow/tree/feature/update_lookml).\r\n\r\nThis LookML has been tested with a lot of clients - so I'd only update it if you think there's scope to improve it significantly. (Particularly around the efficiency of the SQL tables.)\r\n\r\nI recommend:\r\n\r\n1. Creating a new 'looker' user for snplow1 in Redshift with read permissions on the atomic schemas and ownership of a looker_scratch schema\r\n2. Create a new connection in our Looker account\r\n3. Testing and developing the updated model there"},"comment":{"url":"https://api.github.com/repos/snowplow/snowplow/issues/comments/93720637","html_url":"https://github.com/snowplow/snowplow/issues/1522#issuecomment-93720637","issue_url":"https://api.github.com/repos/snowplow/snowplow/issues/1522","id":93720637,"user":{"login":"alexanderdean","id":200511,"avatar_url":"https://avatars.githubusercontent.com/u/200511?v=3","gravatar_id":"","url":"https://api.github.com/users/alexanderdean","html_url":"https://github.com/alexanderdean","followers_url":"https://api.github.com/users/alexanderdean/followers","following_url":"https://api.github.com/users/alexanderdean/following{/other_user}","gists_url":"https://api.github.com/users/alexanderdean/gists{/gist_id}","starred_url":"https://api.github.com/users/alexanderdean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alexanderdean/subscriptions","organizations_url":"https://api.github.com/users/alexanderdean/orgs","repos_url":"https://api.github.com/users/alexanderdean/repos","events_url":"https://api.github.com/users/alexanderdean/events{/privacy}","received_events_url":"https://api.github.com/users/alexanderdean/received_events","type":"User","site_admin":false},"created_at":"2015-04-16T12:22:30Z","updated_at":"2015-04-16T12:22:30Z","body":"Reopening till merge to master"}}