portfolio.model.lkml

connection: "@{database}"

# include: "/views/*.view.lkml"                # include all views in the views/ folder in this project
include: "/**/*.view.lkml"                 # include all views in this project
include: "UDD/dashboards/*.dashboard.lookml"   # include a LookML dashboard called my_dashboard

explore: full_public_dataset {
  label: "Wallet Data"
}

explore: market_data {
  label: "Coin Data"
  join: history_with_date_crossjoin {
    relationship: one_to_many
    sql_on: ${market_data.id} = ${history_with_date_crossjoin.coin_id} ;;
  }
}

explore: stock_info {
  label: "Equity Information"
  join: stock_history_with_date_crossjoin {
    relationship: one_to_many
    sql_on: ${stock_info.id} = ${stock_history_with_date_crossjoin.id} ;;
  }
}

explore:  portfolio {
  label: "Current Holdings"
  join: portfolio_history {
    relationship: one_to_many
    sql_on: ${portfolio.id} = ${portfolio_history.id} ;;
  }
}

### EXPLORE FOR MATCHED PRODUCTS ONLY ###
explore: stock_info_semantic_search {
  join: stock_history_with_date_crossjoin {
    relationship: one_to_many
    sql_on: ${stock_info_semantic_search.matched_stock_id} = ${stock_history_with_date_crossjoin.id} ;;
  }
}



datagroup: history {
  max_cache_age: "24 hours"
  interval_trigger: "24 hours"
  label: "History PDT datagroup"
  description: "Datagroup for history with date crossjoin PDT"
}