catalog

Creates Denodo 9.5 virtual databases, folders, and VDP tags with verified VQL templates.

Updated Sep 4, 2026
One-click install
npx skills add https://github.com/kirivandubai/denodo_wipe_coading_skills --skill catalog-kirivandubai
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: catalog
Source: https://github.com/kirivandubai/denodo_wipe_coading_skills/tree/main/skills/catalog
Command: npx skills add https://github.com/kirivandubai/denodo_wipe_coading_skills --skill catalog-kirivandubai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Structuring a Denodo 9.5 catalog by hand means memorizing exact VQL syntax quirks — description placement in CREATE DATABASE, the = difference between folder and tag descriptions, parent-before-child folder ordering — and silent failures like tag assignments to nonexistent columns that report success. This Skill provides verified templates and read-back checks so databases, folders, and VDP tags are created correctly the first time. ## Core Features & Use Cases - Virtual databases: CREATE OR REPLACE DATABASE with description, CHARSET, and authentication guidance, including the rule that the description literal precedes CHARSET. - Folder trees: CREATE/ALTER/DROP FOLDER with parent-first ordering, rename/move semantics, and safe CASCADE drop procedures after listing contents with GET_ELEMENTS(). - VDP tags with assignments: CREATE OR REPLACE TAG with ADD_TO/REMOVE_FROM blocks, database-qualified targets, and mandatory GET_VIEW_TAGS() verification because missing targets are silently accepted. - Use Case: A user asks to "mark the email and phone columns of the customer view as PII" — the Skill reads the view first, writes an idempotent CREATE OR REPLACE TAG statement into a .vql file, applies it, and confirms the assignments via GET_VIEW_TAGS(). ## Quick Start Ask the agent to create a Denodo database named sales_analytics with the standard layer folders and a pii tag assigned to the customer view's email column.

Frequently Asked Questions about catalog

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

FAQPage Schema
How do I create a virtual database in Denodo 9.5 with VQL?

Use CREATE OR REPLACE DATABASE with the description literal first, then CHARSET: CREATE OR REPLACE DATABASE sales_analytics 'Sales data products' CHARSET DEFAULT. Putting CHARSET before the description causes a syntax error near the quote.

How do I assign a VDP tag to views and columns in Denodo?

Use CREATE OR REPLACE TAG with ADD_TO and REMOVE_FROM blocks, both present even when empty, and database-qualified targets like db.view.column. Always read GET_VIEW_TAGS() afterward because assignments to nonexistent targets are silently accepted.

What is the difference between VDP tags and Data Marketplace tags?

VDP tags are server-wide labels created with VQL and visible in Design Studio and LIST TAGS. Data Marketplace tags are managed through a separate REST server; the marketplace can import VDP tags as read-only copies.

Why does CREATE FOLDER fail with parent not found in Denodo?

A folder's parent path must exist before the child is created, so build trees top-down with one statement per level. Also run CONNECT DATABASE first, since folders are created inside the currently connected database.

Can I drop a Denodo folder or tag that still has contents?

Not without CASCADE: DROP FOLDER on a non-empty folder and DROP TAG on an assigned tag are both refused. List contents with GET_ELEMENTS() or GET_VIEW_TAGS() first, then use CASCADE only after human confirmation.