Extraction Pipeline

The extraction has three stages with the following API calls and data that is extracted:

1. Extract Dashboards

   1. /api/3.1/dashboards
   2. /api/3.1/dashboards/{{dashboard_id}}

   # Dashboard
   id,title,description,space.id,space.name,created_at,last_accessed_at,view_count
   

2. Extract "Tables" (LookML Explores)

   1. /api/3.1/lookml_models
   2. /api/3.1/lookml_models/{{model_name}}
   3. /api/3.1/lookml_models/{{model_name}}/explores/{{explore_name}}?fields=fields(dimensions(name,type,description))

   # Model
   name,project_name,description
   
   # Explores
   name
   
   # Explore Fields
   name,type,description
   

3. Extract "Charts" (Looks)

   1. /api/3.1/dashboards?fields=id,title,description,space(id,name)
   2. /api/3.1/dashboards/{{dashboard_id}}/dashboard_elements?fields=title,type,result_maker(query(id,view,model))
   3. /api/3.1/lookml_models/{{model_name}}?fields=project_name

   # Look
   id,title,result_maker.query.id,result_maker.query.view,result_maker.query.model