Build a fully interactive Route Optimization Simulator using the OpenRouteService Native App.

This quickstart deploys a demo application that simulates vehicle routing scenarios using real-world business locations from the Carto Overture Maps dataset. You'll explore routing functions through an interactive notebook and run a complete Streamlit simulator.

🚚 Route Optimization Simulator - A fully interactive Streamlit app that:

📓 AISQL Exploration Notebook - Learn how to:

Required:

Use Cortex Code to deploy the demo including Marketplace data, notebooks, and the Streamlit simulator.

In the Cortex Code CLI, type:

Cortex Code verifies that the Native App is installed and all four services are running before proceeding with the demo deployment.

The skill then uses interactive prompting to gather required information:

Cortex Code will automatically:

The demo skill creates the following Snowflake objects:

Marketplace Data

Demo Database & Infrastructure

Notebooks

Streamlit Application

Once deployment completes successfully, you'll see a summary with direct links to your resources:

Cortex Code confirms all demo components are installed and ready to use:

The AISQL notebook is an interactive exploration of all three routing functions. It uses Snowflake Cortex AI to generate realistic sample data - restaurants, delivery jobs, customer addresses - all customized for your configured region.

1. Navigate to Projects > Notebooks in Snowsight
2. Open ROUTING_FUNCTIONS_AISQL

What the Notebook Covers:

Navigate to the Simulator Streamlit app:

1. Go to Projects > Streamlits in Snowsight
2. Click on SIMULATOR

Open the sidebar to configure:

Choose from the list of nearby distributors sorted by distance from your search location.

Configure up to 3 vehicles with:

Set the order acceptance catchment time to generate an isochrone showing all reachable delivery locations.

See which jobs are assigned to which vehicles based on skills and time windows.

View the optimized routes on an interactive map with color-coded paths for each vehicle.

Each vehicle tab shows detailed turn-by-turn instructions for the entire journey.

You can customize the demo for different industries or regions using the customization skills:

Simply type a natural language command like:

Cortex Code automatically finds the relevant skill and guides you through the options:

You can add a new industry, modify an existing one, or replace one with something different. The skill updates the Streamlit simulator with your customized industry categories (product types, customer types, vehicle skills).

Once the wizard completes, the Streamlit app is automatically refreshed with your new industry:

Alternatively, you can use the full skill path:

Update the Simulator with region-specific coordinates.

Update the notebooks with city-specific AI prompts and POI data filters.

Cortex Code makes uninstallation simple with natural language commands.

To remove just the demo resources (notebooks, Streamlit simulator) while keeping the OpenRouteService Native App:

This will:

To remove both the demo AND the OpenRouteService Native App:

Cortex Code will run both uninstall skills in sequence, removing all resources from your Snowflake account.

For reference, here are the Cortex Code skills for the Route Optimization Demo:

For OpenRouteService Native App skills (installation, location/vehicle customization, uninstall), see the Install OpenRouteService Native App quickstart.

You've deployed a complete Route Optimization Simulator that demonstrates the power of combining: