def get_projects(bq_service):
    """Given the BigQuery service, return data about all projects."""
    projects_request = bq_service.projects().list().execute()
    projects = []
    for project in projects_request.get('projects', []):
        project_data = {'id': project['id'], 'name': project['friendlyName']}
        projects.append(project_data)
    return projects
