LookML を使用した派生テーブルの作成 のレビュー

Shehbaz Mueed Okasha · 12ヶ月前にレビュー済み

best

SOHAIL ANGBEEN · 12ヶ月前にレビュー済み

Kumail Raza Marium · 12ヶ月前にレビュー済み

In Task 4, the data group trigger should be added to order_details view, as this is the view that was joined in the order_items explore, and is visible in the explore. The instructions say to add the datagroup trigger in the order_details_summary, which is not visible in the explore, and is inconsistent with description of resulting sql query, that replaces CTE with select statement.

Germanovich Ksenia · 12ヶ月前にレビュー済み

Sinha Rajnikant · 12ヶ月前にレビュー済み

David Kissinger P · 12ヶ月前にレビュー済み

Ali Ahsan · 12ヶ月前にレビュー済み

Ahmed Syed Umair · 12ヶ月前にレビュー済み

Zaheer Nimra · 12ヶ月前にレビュー済み

Horosko Laura · 12ヶ月前にレビュー済み

Saad Muhammad · 12ヶ月前にレビュー済み

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: order_details { type: left_outer sql_on: ${order_items.order_id} = ${order_details.order_id};; relationship: many_to_one } 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 } } 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 } }

Đỗ Tiến Dũng · 12ヶ月前にレビュー済み

Good

Luhur Khafi · 12ヶ月前にレビュー済み

Khalid Nauman · 12ヶ月前にレビュー済み

Riaz Jahanzeb · 12ヶ月前にレビュー済み

Khaliq Abdul · 12ヶ月前にレビュー済み

FIDEL MENDEZ JOSE EDUARDO · 12ヶ月前にレビュー済み

Sajid Hamza · 12ヶ月前にレビュー済み

Abbas Ali · 12ヶ月前にレビュー済み

Zafar Tahir · 12ヶ月前にレビュー済み

Akhtar Harris · 12ヶ月前にレビュー済み

Sheikh Hamza · 12ヶ月前にレビュー済み

Fomenko Alex · 12ヶ月前にレビュー済み

Jepson Thomas · 12ヶ月前にレビュー済み

Muhammad Shafee · 12ヶ月前にレビュー済み