skills.rest
kameshsampath
kameshsampathCOMMUNITY
Explore all skills by this author →
Website𝕏@kamesh_sampathGitHub

hirc-duckdb-demo

Query Snowflake Iceberg data via Horizon Catalog using DuckDB.

Updated Feb 6, 2026
Search Tags:#rbac#demo#duckdb#iceberg#snowflake#horizon-catalog
One-click install
npx skills add https://github.com/kameshsampath/kamesh-demo-skills --skill hirc-duckdb-demo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: hirc-duckdb-demo
Source: https://github.com/kameshsampath/kamesh-demo-skills/tree/main/hirc-duckdb-demo
Command: npx skills add https://github.com/kameshsampath/kamesh-demo-skills --skill hirc-duckdb-demo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables users to query Snowflake Iceberg data through the Horizon Catalog using DuckDB, reducing the complexity of setting up credentials, catalogs, and external storage for data exploration.

Core Features & Use Cases

  • Interactive Demo Orchestration: Sets up a demo environment with external volumes, RBAC, and a shareable manifest for replay.
  • Horizon Catalog Integration: Enables DuckDB to query Iceberg tables via the Horizon Catalog REST API.
  • RBAC Learning & Troubleshooting: Demonstrates permission gaps and fixes through guided steps, including granting SELECT on Iceberg tables.
  • Manifest-driven Replay: Tracks resources and allows replay or sharing of the demo configuration.

Quick Start

Use the hirc-duckdb-demo skill to bootstrap a Horizon Iceberg DuckDB demo by following the prompts to supply admin role, demo database name, and external volume, then run through setup, data loading, and RBAC steps. Provide commands by prompting within Cortex Code to proceed.

Frequently Asked Questions about hirc-duckdb-demo

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Snowflake Iceberg tables using DuckDB?▼

Querying Snowflake Iceberg data via DuckDB requires connecting to the Horizon Catalog using a REST API. You need a Snowflake connection, an external volume, and a service account PAT to set up credentials and access the tables.

What do I need to set up to access Iceberg data through Horizon Catalog?▼

To access Iceberg data through Horizon Catalog, you need a Snowflake connection, an SA PAT, an external volume, and the Horizon Catalog URL in org-account format. An admin_role stored in the manifest is also required for setup and data operations.

How does RBAC access control work for Iceberg tables in DuckDB?▼

RBAC access control for Iceberg tables in DuckDB works by demonstrating permission gaps and applying fixes through guided steps, including explicitly granting SELECT permissions on the Iceberg tables to the appropriate roles.

Can I share and replay a DuckDB Iceberg demo configuration?▼

Yes, you can share and replay a DuckDB Iceberg demo configuration using a shareable manifest. The manifest tracks all created resources, allowing you to replay or share the exact demo setup including external volumes and RBAC settings.

Why am I getting permission errors when querying Iceberg data with DuckDB?▼

Permission errors when querying Iceberg data with DuckDB often stem from RBAC misconfigurations. You can resolve these by following guided troubleshooting steps to identify permission gaps and grant SELECT access on the Iceberg tables.

Related Skills

Explore More Data & Analytics Skills→
julianobarbosajulianobarbosa
7

grafana-http-api

Manage Grafana resources via HTTP API with service account token authentication.

Community
Advanced
lazygopherslazygophers
4

office-xlsx-skills

Read, write, analyze, and convert Excel, CSV, and JSON files.

Official
Advanced
jwmossmozjwmossmoz
3

azure-cost-duckdb

Download Azure Cost Management exports and query them locally with DuckDB.

Community
Advanced
JingyiWngJingyiWng

databricks-iceberg

Create and manage Apache Iceberg tables on Databricks with REST Catalog.

Community
Advanced