pltr-cli: Palantir Foundry CLI
This skill helps you use the pltr-cli to interact with Palantir Foundry effectively.
Compatibility
- Skill version: 1.1.0
- pltr-cli version: 0.12.0+
- Python: 3.9, 3.10, 3.11, 3.12
- Dependencies: foundry-platform-sdk >= 1.69.0
Overview
pltr-cli is a comprehensive CLI with 100+ commands for:
- Dataset operations: Get info, list files, download files, manage branches and transactions
- SQL queries: Execute queries, export results, manage async queries
- Ontology: List ontologies, object types, objects, execute actions and queries
- Orchestration: Manage builds, jobs, and schedules
- Filesystem: Folders, spaces, projects, resources
- Admin: User, group, role management
- Connectivity: External connections and data imports
- MediaSets: Media file management
- Language Models: Interact with Anthropic Claude models and OpenAI embeddings
- Streams: Create and manage streaming datasets, publish real-time data
- Functions: Execute queries and inspect value types
- AIP Agents: Manage AI agents, sessions, and versions
- Models: ML model registry for model and version management
Critical Concepts
RID-Based API
The Foundry API is RID-based (Resource Identifier). Most commands require RIDs:
- Datasets:
ri.foundry.main.dataset.{uuid}
- Folders:
ri.compass.main.folder.{uuid} (root: ri.compass.main.folder.0)
- Builds:
ri.orchestration.main.build.{uuid}
- Schedules:
ri.orchestration.main.schedule.{uuid}
- Ontologies:
ri.ontology.main.ontology.{uuid}
Users must know RIDs in advance (from Foundry web UI or previous API calls).
Authentication
Before using any command, ensure authentication is configured:
# Configure interactively
pltr configure configure
# Or use environment variables
export FOUNDRY_TOKEN="your-token"
export FOUNDRY_HOST="foundry.company.com"
# Verify connection
pltr verify
Output Formats
All commands support multiple output formats:
pltr <command> --format table # Default: Rich table
pltr <command> --format json # JSON output
pltr <command> --format csv # CSV format
pltr <command> --output file.csv # Save to file
Profile Selection
Use --profile to switch between Foundry instances:
pltr <command> --profile production
pltr <command> --profile development
Reference Files
Load these files based on the user's task:
| Task Type |
Reference File |
| Setup, authentication, getting started |
reference/quick-start.md |
| Dataset operations (get, files, branches, transactions) |
reference/dataset-commands.md |
| SQL queries |
reference/sql-commands.md |
| Builds, jobs, schedules |
reference/orchestration-commands.md |
| Ontologies, objects, actions |
reference/ontology-commands.md |
| Users, groups, roles, orgs |
reference/admin-commands.md |
| Folders, spaces, projects, resources, permissions |
reference/filesystem-commands.md |
| Connections, imports |
reference/connectivity-commands.md |
| Media sets, media items |
reference/mediasets-commands.md |
| Anthropic Claude models, OpenAI embeddings |
reference/language-models-commands.md |
| Streaming datasets, real-time data publishing |
reference/streams-commands.md |
| Functions queries, value types |
reference/functions-commands.md |
| AIP Agents, sessions, versions |
reference/aip-agents-commands.md |
| ML model registry, model versions |
reference/models-commands.md |
Workflow Files
For common multi-step tasks:
| Workflow |
File |
| Data exploration, SQL analysis, ontology queries |
workflows/data-analysis.md |
| ETL pipelines, scheduled jobs, data quality |
workflows/data-pipeline.md |
| Setting up permissions, resource roles, access control |
workflows/permission-management.md |
Common Commands Quick Reference
# Verify setup
pltr verify
# Current user info
pltr admin user current
# Execute SQL query
pltr sql execute "SELECT * FROM my_table LIMIT 10"
# Get dataset info
pltr dataset get ri.foundry.main.dataset.abc123
# List files in dataset
pltr dataset files list ri.foundry.main.dataset.abc123
# Download file from dataset
pltr dataset files get ri.foundry.main.dataset.abc123 "/path/file.csv" "./local.csv"
# Copy dataset to another folder
pltr cp ri.foundry.main.dataset.abc123 ri.compass.main.folder.target456
# List folder contents
pltr folder list ri.compass.main.folder.0 # root folder
# Search builds
pltr orchestration builds search
# Interactive shell mode
pltr shell
# Send message to Claude model
pltr language-models anthropic messages ri.language-models.main.model.xxx \
--message "Explain this concept"
# Generate embeddings
pltr language-models openai embeddings ri.language-models.main.model.xxx \
--input "Sample text"
# Create streaming dataset
pltr streams dataset create my-stream \
--folder ri.compass.main.folder.xxx \
--schema '{"fieldSchemaList": [{"name": "value", "type": "STRING"}]}'
# Publish record to stream
pltr streams stream publish ri.foundry.main.dataset.xxx \
--branch master \
--record '{"value": "hello"}'
# Execute a function query
pltr functions query execute myQuery --parameters '{"limit": 10}'
# Get AIP Agent info
pltr aip-agents get ri.foundry.main.agent.abc123
# List agent sessions
pltr aip-agents sessions list ri.foundry.main.agent.abc123
# Get ML model info
pltr models model get ri.foundry.main.model.abc123
# List model versions
pltr models version list ri.foundry.main.model.abc123
Best Practices
- Always verify authentication first: Run
pltr verify before starting work
- Use appropriate output format: JSON for programmatic use, CSV for spreadsheets, table for readability
- Use async for large queries:
pltr sql submit + pltr sql wait for long-running queries
- Export results: Use
--output to save results for further analysis
- Use shell mode for exploration:
pltr shell provides tab completion and history
Getting Help
pltr --help # All commands
pltr <command> --help # Command help
pltr <command> <sub> --help # Subcommand help
1---2name: pltr-cli3description: pltr-cli: Palantir Foundry CLI4---56# pltr-cli: Palantir Foundry CLI78This skill helps you use the pltr-cli to interact with Palantir Foundry effectively.910## Compatibility1112- **Skill version**: 1.1.013- **pltr-cli version**: 0.12.0+14- **Python**: 3.9, 3.10, 3.11, 3.1215- **Dependencies**: foundry-platform-sdk >= 1.69.01617## Overview1819pltr-cli is a comprehensive CLI with 100+ commands for:20- **Dataset operations**: Get info, list files, download files, manage branches and transactions21- **SQL queries**: Execute queries, export results, manage async queries22- **Ontology**: List ontologies, object types, objects, execute actions and queries23- **Orchestration**: Manage builds, jobs, and schedules24- **Filesystem**: Folders, spaces, projects, resources25- **Admin**: User, group, role management26- **Connectivity**: External connections and data imports27- **MediaSets**: Media file management28- **Language Models**: Interact with Anthropic Claude models and OpenAI embeddings29- **Streams**: Create and manage streaming datasets, publish real-time data30- **Functions**: Execute queries and inspect value types31- **AIP Agents**: Manage AI agents, sessions, and versions32- **Models**: ML model registry for model and version management3334## Critical Concepts3536### RID-Based API37The Foundry API is **RID-based** (Resource Identifier). Most commands require RIDs:38- **Datasets**: `ri.foundry.main.dataset.{uuid}`39- **Folders**: `ri.compass.main.folder.{uuid}` (root: `ri.compass.main.folder.0`)40- **Builds**: `ri.orchestration.main.build.{uuid}`41- **Schedules**: `ri.orchestration.main.schedule.{uuid}`42- **Ontologies**: `ri.ontology.main.ontology.{uuid}`4344Users must know RIDs in advance (from Foundry web UI or previous API calls).4546### Authentication47Before using any command, ensure authentication is configured:48```bash49# Configure interactively50pltr configure configure5152# Or use environment variables53export FOUNDRY_TOKEN="your-token"54export FOUNDRY_HOST="foundry.company.com"5556# Verify connection57pltr verify58```5960### Output Formats61All commands support multiple output formats:62```bash63pltr <command> --format table # Default: Rich table64pltr <command> --format json # JSON output65pltr <command> --format csv # CSV format66pltr <command> --output file.csv # Save to file67```6869### Profile Selection70Use `--profile` to switch between Foundry instances:71```bash72pltr <command> --profile production73pltr <command> --profile development74```7576## Reference Files7778Load these files based on the user's task:7980| Task Type | Reference File |81|-----------|----------------|82| Setup, authentication, getting started | `reference/quick-start.md` |83| Dataset operations (get, files, branches, transactions) | `reference/dataset-commands.md` |84| SQL queries | `reference/sql-commands.md` |85| Builds, jobs, schedules | `reference/orchestration-commands.md` |86| Ontologies, objects, actions | `reference/ontology-commands.md` |87| Users, groups, roles, orgs | `reference/admin-commands.md` |88| Folders, spaces, projects, resources, permissions | `reference/filesystem-commands.md` |89| Connections, imports | `reference/connectivity-commands.md` |90| Media sets, media items | `reference/mediasets-commands.md` |91| Anthropic Claude models, OpenAI embeddings | `reference/language-models-commands.md` |92| Streaming datasets, real-time data publishing | `reference/streams-commands.md` |93| Functions queries, value types | `reference/functions-commands.md` |94| AIP Agents, sessions, versions | `reference/aip-agents-commands.md` |95| ML model registry, model versions | `reference/models-commands.md` |9697## Workflow Files9899For common multi-step tasks:100101| Workflow | File |102|----------|------|103| Data exploration, SQL analysis, ontology queries | `workflows/data-analysis.md` |104| ETL pipelines, scheduled jobs, data quality | `workflows/data-pipeline.md` |105| Setting up permissions, resource roles, access control | `workflows/permission-management.md` |106107## Common Commands Quick Reference108109```bash110# Verify setup111pltr verify112113# Current user info114pltr admin user current115116# Execute SQL query117pltr sql execute "SELECT * FROM my_table LIMIT 10"118119# Get dataset info120pltr dataset get ri.foundry.main.dataset.abc123121122# List files in dataset123pltr dataset files list ri.foundry.main.dataset.abc123124125# Download file from dataset126pltr dataset files get ri.foundry.main.dataset.abc123 "/path/file.csv" "./local.csv"127128# Copy dataset to another folder129pltr cp ri.foundry.main.dataset.abc123 ri.compass.main.folder.target456130131# List folder contents132pltr folder list ri.compass.main.folder.0 # root folder133134# Search builds135pltr orchestration builds search136137# Interactive shell mode138pltr shell139140# Send message to Claude model141pltr language-models anthropic messages ri.language-models.main.model.xxx \142 --message "Explain this concept"143144# Generate embeddings145pltr language-models openai embeddings ri.language-models.main.model.xxx \146 --input "Sample text"147148# Create streaming dataset149pltr streams dataset create my-stream \150 --folder ri.compass.main.folder.xxx \151 --schema '{"fieldSchemaList": [{"name": "value", "type": "STRING"}]}'152153# Publish record to stream154pltr streams stream publish ri.foundry.main.dataset.xxx \155 --branch master \156 --record '{"value": "hello"}'157158# Execute a function query159pltr functions query execute myQuery --parameters '{"limit": 10}'160161# Get AIP Agent info162pltr aip-agents get ri.foundry.main.agent.abc123163164# List agent sessions165pltr aip-agents sessions list ri.foundry.main.agent.abc123166167# Get ML model info168pltr models model get ri.foundry.main.model.abc123169170# List model versions171pltr models version list ri.foundry.main.model.abc123172```173174## Best Practices1751761. **Always verify authentication first**: Run `pltr verify` before starting work1772. **Use appropriate output format**: JSON for programmatic use, CSV for spreadsheets, table for readability1783. **Use async for large queries**: `pltr sql submit` + `pltr sql wait` for long-running queries1794. **Export results**: Use `--output` to save results for further analysis1805. **Use shell mode for exploration**: `pltr shell` provides tab completion and history181182## Getting Help183184```bash185pltr --help # All commands186pltr <command> --help # Command help187pltr <command> <sub> --help # Subcommand help188```