code: def get_projects(bq_service):
      
      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
docs: Given the BigQuery service, return data about all projects.