Five-Tool employee app for snowflake Product Documentation

The **Five-Tool Employee App** is a Snowflake Native Application that helps HR leaders, hiring managers, and business owners evaluate talent using the **5 Tool Employee Framework** – a behavioral model inspired by baseball’s “five-tool player” and adapted to modern work.

The app runs fully **inside Snowflake** as a **Streamlit Native App**, using Snowpark and Snowflake Cortex for AI-assisted analysis. It provides:

- An interactive UI to enter context and scores for a candidate or employee.

- AI-generated behavioral summaries, strengths, and risks.

- Radar chart visualizations of the “five tools”.

- Optional local profile storage for later review/export.

This page explains how to install, configure, and use the app, and describes what objects it creates.

---

2.1 Prerequisites

To use the app, you need:

- A Snowflake account in a supported region.

- A Snowflake **role** with permission to install Native Apps.

- A **warehouse** to run the app (e.g. `COMPUTE_WH` or another warehouse).

> Tip: Many teams create a small dedicated warehouse for apps (for example `APP_WH`) and scale it up/down as needed.

---

2.2 Install the App from Snowflake Marketplace

1. In Snowsight, go to **Marketplace**.

2. Search for **“Five-Tool Employee App”** and open the listing.

3. Click **Get** / **Install**.

4. Choose:

   - **Application name** (e.g. `FIVE_TOOL_EMPLOYEE_APP`)

   - **Application database** (e.g. `FIVE_TOOL_EMPLOYEE_APP_DB`)

5. Click **Install** and wait for the installation to complete.

During install, the app:

- Creates an internal schema `CORE`.

- Creates the Streamlit app object `CORE.FIVE_TOOL_EMPLOYEE`.

- Creates the application role `APP_PUBLIC`, which you’ll use to grant end-user access.

---

2.3 Grant Access to End Users

As an admin (e.g. `ACCOUNTADMIN`), grant the app’s application role to a Snowflake role that your HR / leadership users have:

```sql

GRANT APPLICATION ROLE APP_PUBLIC

  TO ROLE HR_ANALYST;

Replace HR_ANALYST with the role you want to use.

Any user with that role, and access to a warehouse, can launch the app.

2.4 Launch the App

In Snowsight, go to Apps → Installed Apps.

Click your installed Five-Tool Employee App.

Make sure the FIVE_TOOL_EMPLOYEE tab is selected in the app’s header.

Choose a warehouse (e.g. COMPUTE_WH) from the warehouse selector.

Click Start to launch the Streamlit UI.

2.5 First Evaluation: Step-by-Step

Once the UI loads:

Review the introduction

The top of the page explains the 5 Tool Employee Framework and how the baseball tools concept maps to behavior at work.

Enter role context

Use the notes/description area to describe:

The role and level.

Team environment and expectations.

Any relevant performance context.

Score the Five Tools (1–10)

Move the sliders for each tool (names may be phrased slightly differently in-app):

Tool 1 – Technical/functional excellence

Tool 2 – Problem solving & systems thinking

Tool 3 – Adaptability & continuous learning

Tool 4 – Communication & leadership behavior

Tool 5 – Strategic judgment & decision-making

Generate the profile

Click the main action button (e.g. Generate 5 Tool Employee). The app will:

Create a radar chart of the five scores.

Generate plain-language behavioral commentary.

Highlight strengths, risks, and “red flag” patterns.

Offer development / coaching suggestions based on the profile.

The app is designed so that HR and leadership users can learn and apply the framework without external consulting. 

Depending on the version you’re using, you will see some or all of the following:

• Framework Overview
  A narrative explanation of:
   
  • What the 5 tools represent.
     
  • How they interact under pressure.
     
  • Typical high-functioning vs. dysfunctional patterns.
     
• Advanced Concepts / Deep Dive
  Longer-form content that unpacks each tool:
   
  • Natural gifts associated with the tool.
     
  • Early warning signs when the tool is over- or under-used.
     
  • How the tool shows up in leadership and team settings.
     
• Template Discovery / Review Support
  Guided questions and examples to help managers:
   
  • Write clearer performance reviews.
     
  • Use concrete, behavior-based language.
     
  • Avoid vague or biased phrases.
     

All AI components run via Snowflake Cortex inside your Snowflake account.

The introduction section of the app links to:

• The Five-Tool Employee Framework book.
   
• A YouTube channel with modules on each tool and applied examples.

These resources are optional, but can help teams embed a common language around performance and potential.

This app is intentionally light-touch. It does not automatically read from or write to your existing tables. Instead, it uses:

• Application-internal objects (schema, Streamlit app, role).
   
• Optional text files in the app’s local repository.
   

ObjectTypeDescriptionCORESCHEMAInternal schema containing app objects.CORE.FIVE_TOOL_EMPLOYEESTREAMLITMain Streamlit application that hosts the UI and logic.APP_PUBLICAPP ROLEDefault application role end users receive to access the app. 

These objects live inside the Native Application; they are not ordinary database schemas you manage directly.

Item                                         Stored Where                                        Notes 

5 Tool Scores                          Streamlit session state                       Used during a session, not

                                                                                                                     persisted to your tables by 

                                                                                                                     default 

Context / notes text              Streamlit Session state                       Used for AI commentary and

                                                                                                                      optional repository output.

If you export profiles and load them into your own tables, they become part of your own data and are governed by your internal policies.

Q1. What decisions is this app meant to support?

The app is a decision-support tool for:

• Talent evaluation and promotion discussions.
   
• Leadership development planning.
   
• Performance review calibration.
   
• Succession planning and role fit analysis.
   

It helps you structure your thinking about behavior; it does not make hiring or promotion decisions on its own.

No. The app is a Snowflake Native Application. It runs inside your Snowflake environment and uses Snowflake Cortex for AI. The app:

• Does not connect to external databases or APIs for your HR data.
   
• Only uses information you type into the app.
   
• Stores optional profiles inside the app’s sandbox unless you export them.
   

Admins:

• A role that can install Native Apps and grant application roles (e.g. ACCOUNTADMIN).
   

End users:

• A Snowflake role that has been granted the application role (APP_PUBLIC).
   
• Access to at least one warehouse they can use when launching the app.
   

This version uses a fixed 1–10 scale for each of the five tools and a fixed set of labels. You are free to interpret that scale in your own internal language (e.g., mapping to “meets / exceeds expectations”), but the sliders themselves are not yet customizable.

Feedback from customers will inform future versions.

No. The app provides AI-assisted insight and language to support decision-making, but:

• It is not legal advice.
   
• It does not guarantee compliance with any employment law or bias-audit requirement.
   
• Final decisions about hiring, termination, promotion, and compensation remain with you and your organization.
   

Use the app in conjunction with your own HR, legal, and compliance frameworks.

The Five-Tool Employee App is developed and maintained by:

LC Innovation International Corp.
Business Strategy Consulting & Executive Leadership Development

For questions or support, please contact:
Email: support@lcinnovation.org
Website: https://lcinnovation.org