Looker

# sales.model.lkml
connection: "bigquery_connection"

include: "/views/*.view.lkml"

datagroup: sales_default_datagroup {
  sql_trigger: SELECT MAX(updated_at) FROM sales_orders;;
  max_cache_age: "1 hour"
}

explore: sales_orders {
  join: customers {
    type: left_outer
    sql_on: ${sales_orders.customer_id} = ${customers.id} ;;
    relationship: many_to_one
  }
  
  join: products {
    type: left_outer
    sql_on: ${sales_orders.product_id} = ${products.id} ;;
    relationship: many_to_one
  }
}

# sales_orders.view.lkml
view: sales_orders {
  sql_table_name: `project.dataset.sales_orders` ;;
  
  dimension: id {
    primary_key: yes
    type: number
    sql: ${TABLE}.id ;;
  }
  
  dimension_group: order {
    type: time
    timeframes: [raw, date, week, month, quarter, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.order_date ;;
  }
  
  dimension: customer_id {
    type: number
    sql: ${TABLE}.customer_id ;;
  }
  
  dimension: product_id {
    type: number
    sql: ${TABLE}.product_id ;;
  }
  
  measure: total_sales {
    type: sum
    sql: ${TABLE}.amount ;;
    value_format_name: usd
  }
  
  measure: average_order_value {
    type: average
    sql: ${TABLE}.amount ;;
    value_format_name: usd
  }
  
  measure: order_count {
    type: count
    drill_fields: [id, order_date, customers.name, products.name]
  }
}

# sales_dashboard.dashboard.lookml
- dashboard: sales_performance
  title: Sales Performance Dashboard
  layout: newspaper
  preferred_viewer: dashboards-next
  
  elements:
  - title: Total Sales
    name: total_sales
    model: sales
    explore: sales_orders
    type: single_value
    fields: [sales_orders.total_sales]
    limit: 500
    
  - title: Sales by Month
    name: sales_by_month
    model: sales
    explore: sales_orders
    type: looker_line
    fields: [sales_orders.order_month, sales_orders.total_sales]
    sorts: [sales_orders.order_month desc]
    limit: 12
    
  - title: Top Products
    name: top_products
    model: sales
    explore: sales_orders
    type: looker_bar
    fields: [products.name, sales_orders.total_sales]
    sorts: [sales_orders.total_sales desc]
    limit: 10

# Python SDK Example
import looker_sdk

# Inicializar SDK
sdk = looker_sdk.init40()

# Executar query
query = {
    "model": "sales",
    "explore": "sales_orders",
    "fields": ["sales_orders.order_date", "sales_orders.total_sales"],
    "filters": {"sales_orders.order_date": "30 days"},
    "sorts": ["sales_orders.order_date desc"]
}

result = sdk.run_inline_query("json", query)

# Criar dashboard
dashboard = {
    "title": "API Created Dashboard",
    "dashboard_elements": [
        {
            "title": "Sales Chart",
            "type": "looker_line",
            "query": query
        }
    ]
}

new_dashboard = sdk.create_dashboard(dashboard)

# Agendar relatório
schedule = {
    "name": "Weekly Sales Report",
    "dashboard_id": new_dashboard.id,
    "scheduled_plan_destination": [
        {
            "type": "email",
            "address": "team@company.com"
        }
    ],
    "crontab": "0 9 * * 1"  # Segunda-feira às 9h
}

sdk.create_scheduled_plan(schedule)

import { LookerEmbedSDK } from '@looker/embed-sdk';

function SalesDashboard({ customerId }) {
  useEffect(() => {
    LookerEmbedSDK.createDashboardWithId(123)
      .appendTo('#dashboard')
      .withFilters({
        'sales_orders.customer_id': customerId
      })
      .build();
  }, [customerId]);
  
  return 
;
}