Short Term Memory & Long Term Memory

prasuanu1222
New Contributor II
I am building an Agentic Application on Databricks using LangGraph (Classic Compute — Serverless cant be used so Agent Brickscant be used ).
I want my agent to have two types of memory:
  1. Short-term memory → Remember the current conversation and tool outputs so the next tool/step has full context.
  2. Long-term memory → Remember user preferences and behavior across sessions, so the next time the user logs in, the agent already knows them.

What I Need Help With

  1. Recommended Delta table design for long-term memory (preferences, facts, summaries)? - how to design it 
  2. How to move data from short-term → long-term (when and what to save)?
  3. How to load long-term memory back into the agent when the user logs in again?
  4. Any reference examples or notebooks from Databricks for this pattern?