Creating a Looker Modeled Query and Working with Quick Start || GSP984

Login to looker using lab credentials

Enable "Development Mode" from bottom left of screen

Navigate Develop> qwiklabs-ecommerce

Select models> training_ecommerce.model and paste below code

connection: "bigquery_public_data_looker"

# include all the views
include: "/views/*.view"
include: "/z_tests/*.lkml"
include: "/**/*.dashboard"

datagroup: training_ecommerce_default_datagroup {
  # sql_trigger: SELECT MAX(id) FROM etl_log;;
  max_cache_age: "1 hour"
}

persist_with: training_ecommerce_default_datagroup

label: "E-Commerce Training"

explore: order_items {
  join: users {
    type: left_outer
    sql_on: ${order_items.user_id} = ${users.id} ;;
    relationship: many_to_one
  }

  join: inventory_items {
    type: left_outer
    sql_on: ${order_items.inventory_item_id} = ${inventory_items.id} ;;
    relationship: many_to_one
  }

  join: products {
    type: left_outer
    sql_on: ${inventory_items.product_id} = ${products.id} ;;
    relationship: many_to_one
  }

  join: distribution_centers {
    type: left_outer
    sql_on: ${products.distribution_center_id} = ${distribution_centers.id} ;;
    relationship: many_to_one
  }
}

# Place in `training_ecommerce` model
explore: +order_items {
  query: start_from_here{
      dimensions: [products.department, users.state]
      measures: [order_count, users.count]
      filters: [users.country: "USA"]
    }
}


explore: events {
  join: event_session_facts {
    type: left_outer
    sql_on: ${events.session_id} = ${event_session_facts.session_id} ;;
    relationship: many_to_one
  }
  join: event_session_funnel {
    type: left_outer
    sql_on: ${events.session_id} = ${event_session_funnel.session_id} ;;
    relationship: many_to_one
  }
  join: users {
    type: left_outer
    sql_on: ${events.user_id} = ${users.id} ;;
    relationship: many_to_one
  }
}

Save Changes> Validate LookerML> Commit Changes & Pust

Enter "Alins Tutorial" in meassage box and click on commit> Deploy to Production

Navigate Explore> Order items

Click on table named "Start from here"

Select 'Bar Graph' icon on visualization

Click on edit, select 'Stacked' option

Click on gear icon on data section

Select Pivot

Run> Save> Save as Looker

Shared folder>Title: Order Items Count per State