source_looker = LookerApi(host=my_host, token=my_token, secret=my_secret)
### ------- GET THE SOURCE LOOK -------
look_body = source_looker.get_look_info(source_look_id,
'query_id, query, title')
print "---- Source Look Body ----"
pp(look_body)
print "---- Source query ----"
query_body = source_looker.get_query(look_body['query_id'])
pp(query_body)
### ------- BUILD THE TARGET LOOK -------
print "---- New query ----"
new_query = dest_looker.create_query(query_body, 'id')
new_query_id = str(new_query['id'])
print new_query_id + " is the new query id"
new_look = {}
new_look['space_id'] = destination_space_id
new_look['query_id'] = new_query_id
new_look['title'] = look_body['title'] + "from teach"
dest_looker.create_look(new_look)
### ------- DONE -------
print "Done"
"dashboard.id", "dashboard.user_id", "dashboard.space_id",
"look.id", "look.user_id", "look.space_id"
]
}
}
content_usage_query = looker.create_query(query_body=content_usage_query_body)
print('Query Created: ' + str(content_usage_query['id']))
new_look = {}
new_look['space_id'] = space_id
new_look['query_id'] = content_usage_query['id']
new_look['title'] = "Unused Content"
look = looker.create_look(new_look)
print('Look Saved: ' + str(look['id']))
### ------- GET USER EMAILS FROM USER_IDs -------
data = looker.run_query(query_id=content_usage_query['id'])
user_ids = {row['user_id'] for row in data}
print('Users with unused content: ' + str(user_ids))
me = looker.get_current_user()
user_list = looker.get_all_users()
emails = {}
for u in user_list:
if u['id'] in user_ids: