starlake-ai/freshness
.agents/skills/freshness/SKILL.md
Check data freshness and last update timestamps
$ install --global
skillsauthnpx skillsauth add starlake-ai/starlake-skills freshnessInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 16, 2026, 3:36 AM13.5s1 file scanned
SKILL.md
- name:
- freshness
- description:
- Check data freshness and last update timestamps
Freshness Skill
Checks the freshness of your data tables by querying the last update timestamps. Results are stored in the SL_LAST_EXPORT audit table for monitoring and alerting.
Usage
starlake freshness [options]
Options
--connection <value>: Connection reference fromapplication.sl.yml--database <value>: Database / GCP Project ID--tables <value>: Comma-separated list ofdataset.tablepairs to check--external: Include external datasets defined in_config.sl.yml--write <value>: Write mode:OVERWRITE,APPEND--accessToken <value>: Access token for authentication--persist <value>: Persist results to audit tables (true/false)--reportFormat <value>: Report output format:console,json, orhtml
Configuration Context
Freshness thresholds can be defined at the domain or table level:
# In _config.sl.yml or table.sl.yml
load:
metadata:
freshness:
warn: "24h" # Warn if data is older than 24 hours
error: "48h" # Error if data is older than 48 hours
Examples
Check Freshness for Specific Tables
starlake freshness --tables starbake.orders,starbake.customers --persist true
Check Freshness for All Tables
starlake freshness --database my-gcp-project --persist true
Check Freshness with Connection
starlake freshness --connection duckdb --tables starbake.orders
Related Skills
- bq-info - Get BigQuery table information
- metrics - Compute statistical metrics on tables
- validate - Validate project configuration
Related Skills
starlake-ai/starflow-transform-design
development
VerifiedTrustedCommunity
Design SQL transformations for data pipelines with quality checks and dependency management. Use when the user says "design transforms" or "create SQL transformations".
1SKILL.mdUpdated Apr 16, 2026
starlake-ai/starflow-sprint-planning
devops
VerifiedTrustedCommunity
Plan and track sprint progress for data pipeline implementation. Use when the user says "sprint planning" or "plan data sprint".
1SKILL.mdUpdated Apr 16, 2026
starlake-ai/starflow-source-analysis
testing
VerifiedTrustedCommunity
Analyze data sources in depth: schema, quality, volume, and extraction strategy. Use when the user says "analyze data source" or "profile this data source".
1SKILL.mdUpdated Apr 16, 2026
starlake-ai/starflow-schema-design
data-ai
VerifiedTrustedCommunity
Design Starlake-compatible table schemas with types, constraints, privacy, and expectations. Use when the user says "design schema" or "create table definition".
1SKILL.mdUpdated Apr 16, 2026