home/categories/sql-databases/ecnu-icalk-autoskill-skillbank-convskill-english-gpt4-8-glm4-7-generate-sql-unpivot-queries-for-metric-tables-skill-md
sql-databasesdatabases

generate-sql-unpivot-queries-for-metric-tables

Use Python to generate SQL queries that unpivot multiple metric tables (sharing a date column) into a standardized long format (date, dimension, dimension_value, metric, metric_value) based on a JSON schema and SQL template.

ECNU-ICALK
maintainer
ECNU-ICALK
์—…๋ฐ์ดํŠธ๋จ 2026. 3. 13.
์Šคํƒ€
304
ํฌํฌ
34
quick start

Installation and usage

Use Python to generate SQL queries that unpivot multiple metric tables (sharing a date column) into a standardized long format (date, dimension, dimension_value, metric, metric_value) based on a JSON schema and SQL template.

์„ค์น˜
$ install --globalskills.sh
์‚ฌ์šฉ๋ฒ•

์„ค์น˜ ํ›„ ํ„ฐ๋ฏธ๋„์—์„œ ๋‹ค์Œ ๋ช…๋ น์„ ์‹คํ–‰ํ•˜์—ฌ ์ด ์Šคํ‚ฌ์„ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค:

skills use generate-sql-unpivot-queries-for-metric-tables