dt-dql-essentials
Core DQL syntax, pitfalls, query patterns, and query optimization. Load to write, build, fix, or OPTIMIZE a DQL query — prevents syntax errors and makes queries faster, more efficient, and cheaper (less data scanned = lower query consumption/cost per run). Covers fetch commands, data models, field namespaces, time alignment, entity/smartscape patterns, metric discovery, and performance/cost optimization (filter early, bucket filters, short time ranges, field selection, sampling, cardinality). Trigger: "write/build/fix a DQL query", "DQL syntax", "query logs/spans/metrics", "create a timeseries", "optimize my DQL", "make my query faster/cheaper", "reduce DQL cost/consumption/scanned data", "keep DQL cost under control". Do NOT use to explain an existing query or answer product questions. For MONITORING a tenant's ACTUAL query consumption/billing (how much queries cost, who scanned most, cost trends) use dt-platform-costs — this tunes the query text, not billing data.
- License
- Apache-2.0
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/dt-dql-essentials/SKILL.md
- skills/dt-dql-essentials/LICENSE
- skills/dt-dql-essentials/references/discovery.md
- skills/dt-dql-essentials/references/dql/dql-commands.md
- skills/dt-dql-essentials/references/dql/dql-data-types.md
- skills/dt-dql-essentials/references/dql/dql-functions-aggregation.md
- skills/dt-dql-essentials/references/dql/dql-functions-array.md
- skills/dt-dql-essentials/references/dql/dql-functions-bitwise.md
- skills/dt-dql-essentials/references/dql/dql-functions-boolean.md
- skills/dt-dql-essentials/references/dql/dql-functions-cast.md
- skills/dt-dql-essentials/references/dql/dql-functions-constant.md
- skills/dt-dql-essentials/references/dql/dql-functions-conversion.md
- skills/dt-dql-essentials/references/dql/dql-functions-create.md
- skills/dt-dql-essentials/references/dql/dql-functions-cryptographic.md
- skills/dt-dql-essentials/references/dql/dql-functions-entities.md
- skills/dt-dql-essentials/references/dql/dql-functions-expression-timeseries.md
- skills/dt-dql-essentials/references/dql/dql-functions-flow.md
- skills/dt-dql-essentials/references/dql/dql-functions-general.md
- skills/dt-dql-essentials/references/dql/dql-functions-get.md
- skills/dt-dql-essentials/references/dql/dql-functions-iterative.md
- skills/dt-dql-essentials/references/dql/dql-functions-mathematical.md
- skills/dt-dql-essentials/references/dql/dql-functions-network.md
- skills/dt-dql-essentials/references/dql/dql-functions-smartscape.md
- skills/dt-dql-essentials/references/dql/dql-functions-string.md
- skills/dt-dql-essentials/references/dql/dql-functions-time.md
- skills/dt-dql-essentials/references/dql/dql-functions-timeseries.md
- skills/dt-dql-essentials/references/dql/dql-parameter-value-types.md
- skills/dt-dql-essentials/references/iterative-expressions.md
- skills/dt-dql-essentials/references/operators.md
- skills/dt-dql-essentials/references/optimization.md
- skills/dt-dql-essentials/references/semantic-dictionary.md
- skills/dt-dql-essentials/references/smartscape-topology-navigation.md
- skills/dt-dql-essentials/references/string-matching.md
- skills/dt-dql-essentials/references/summarization.md
- skills/dt-dql-essentials/references/useful-expressions.md
Every link opens the file at its source, pinned to the revision this page describes.