Products
KDB-X
Next-gen kdb+ for real-time, historical, and AI apps, providing fast analytics across all data with q, Python, and SQL.
Explore → Documentation
KDB.AI
Vector database optimized for unstructured and time-series data.
Insights Enterprise
Low-code integrated, scalable data management & analytics.
Insights SDK
Developer toolkit for creating custom time series analytics applications.
Delta
Integrated platform for enterprise-scale, high-security data management and analytics.
Add-ons Overview
Dashboards
Custom interactive data visualization tool to query, transform, share and present live data insights.
VS Code Extension
Extension to create and edit q files, connect to multiple data processes, and execute queries.
Accelerators
Pre-built, customizable solutions for faster data projects.
https://learninghub.kx.com/forums/topic/exercise-3-6
I am unsure where I am wrong with my .z.pg
.z.pg:{[x] i: where .perm.users.user = .z.u; auth:.perm.users.api[first i]; $[auth ~ `all;value x;.perm.parseQuery[x] ~ auth; value x; `notAuthorized]}
when I define my .z.pg on the hdb, it breaks all the previous tests
You have a keyed table in .perm.users. Dot syntax (.perm.users.user) doesn’t work for indexing in this case.
From the error message, it seems to be complaining that .perm.users.user does not exist. Can you check if this is the case? The variable needs to be defined before the first invocation of .z.pg happens.
It looks like .perm.users and users both exist in my hdb