--- title: "A tour of LumiCode" slug: "a-tour-of-lumicode" tags: ["LumiCode", "tour"] updated: 2026-10-26T13:35:33Z published: 2026-10-26T13:35:33Z canonical: "support.lusid.com/a-tour-of-lumicode" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.lusid.com/llms.txt > Use this file to discover all available pages before exploring further. # A tour of LumiCode This tour shows LumiCode's main features, one screen at a time: writing SQL, exploring and charting results, working with Candela, browsing the catalog, searching your history and diagnosing failed queries. To try LumiCode yourself step by step, start with [Getting started with LumiCode](/v1/docs/getting-started-with-lumicode). ## Navigating your options Every command, as well as the SQL editor, supports command completion. So seeing a list of commands is as simple as typing `/` + **Tab**. For example typing `/help `+ **Tab** gives you this: ![Command completion after typing /help and pressing Tab](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-JMKS1VOY.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=%2B4HJrA5F9Rnm86H8huS81ikAsY51s%2BWZOnLFeW9fnOE%3D) ## Writing SQL Writing SQL works the way you'd expect: just start typing, press **Tab** if you are stuck and code completion will help you finish writing it or ask Candela to help out. You will see functions, providers, their fields and parameters, and code completion shows the documentation for each. You can run more than one SQL statement at a time by putting a `\` on its own line between them. ![SQL code completion suggesting providers, fields and parameters](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-5SIEAVGL.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=6mTb%2F7csP5c%2BV8YOJRiGGf6YBT%2FncTWfbg1Xz7aPTbs%3D) Links to reference documentation are likewise available: ![Code completion with a link to reference documentation](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-Y7HHO4BH.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=nAkoxsLgG6Al9x%2FZmqQlcDrW1gfXoy3qB%2BAG%2FaXshZQ%3D) ![Reference documentation opened from code completion](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-B48XABEE.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=ioPtLvmF1Kz%2Fp8z4HAFs5%2FfNLOc8abG2ez1pQpIeR0M%3D) You can always see what sort of SQL can follow beyond where your cursor lies ("code completion"). ![Code completion showing what SQL can follow the cursor (1 of 2)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-YDEIX1ZC.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=lyCVbmIDeFZmwDNOk8dWCOOWU%2FkCsX%2FDBadt9u%2BC3n4%3D) ![Code completion showing what SQL can follow the cursor (2 of 2)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-PXLCDC2X.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=jgioJ%2BAoKPDT7nJE7c9qmK6TVFwecYe5LozqLgTU%2BLk%3D) LumiCode shows progress as your query runs: ![Progress shown while a query runs](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-T9CAF5VP.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=z5hu24L5knD9Uo%2BSNDnvnz79ka2Kl7xU4wrRJtbP5ss%3D) And you can get the full log into the transcript with `/feedback`. ### Multi-queries A multi-query is a set of named queries that you write in the editor, where each query can read the results of the ones above it. LumiCode runs independent queries at the same time, and you can save the whole set, and all its results, in one go. ![Running a multi-query in LumiCode](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-NJDWHODX.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=IenDChleT3eV%2FdQmGx3MM22RV1yhJ382HmPjJqJQIRU%3D) To write and run one, see [How do I run several queries together as a multi-query?](/v1/docs/how-do-i-run-several-queries-together-as-a-multi-query) ## Data rendered in tables, grouped tables and charts LumiCode writes a summary of the results to the transcript: ![Summary of query results in the transcript](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-8OSL92HL.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=OLiRJyG%2BWFXvQ9h4PKxxgQLR3d3zjyXf7UZ1ZMn5kyk%3D) Wherever you see data, if a provider (or a view you create!) supports links, LumiCode adds links that open other websites. This could open into LUSID, showing dialogs (Drive, LUSID-Instruments, Scheduler logs, Configuration Service entries, etc.) or any other site, such as Google Maps or your own internal systems. ![Query results with links that open other websites](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-FKFZ0G81.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=yC5v9PW5V%2B%2FQhtO7Z7s4zAJl19CumEOQZXTmrWycz1I%3D) ### /rows `/rows` lets you explore all rows, further filter, choose columns, sort, and show detail cards (a panel showing every field of one row). ![Exploring rows with /rows (1 of 2)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-07AOQPVP.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=7gFeAE1bplgpwboAg0m0qFXBBfrS4BB4fKL7WKuJhYk%3D) ![Exploring rows with /rows (2 of 2)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-TT5JCZT2.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=QEUUfEZbD1eX2stjRyICdfwXVcq1DIZKiH6RFlO38Uc%3D) ### /group Lets you group by any number of columns, expand them, apply group-aggregations, etc. ![Grouping results with /group](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-9DPZI7P6.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=6UvWz159p5Kmx%2F2Rl4cU7fv6kKncqfPzbV%2BHLP6B2sk%3D) ### /chart You can render the data as many types of chart, including into the transcript: ![A chart drawn with /chart](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-GIS1TJX2.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=HAEhHXAZoEIK%2Bt%2FGPKLbiM5Udnk8oynPVtJDn6rN2OA%3D) `/chart gallery` will show you examples of the full set, here's a small sample: ![Sample charts from /chart gallery](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-SD0IDI3K.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=NzM3IMvva6%2FtZin95O01Pe462S24i62kexpguTFjaTw%3D) ## Using the built-in Candela AI LumiCode natively uses [Candela](/v1/docs/candela-ai), FINBOURNE's AI agent. You can use it to ask about providers in your catalog, optimise queries, explain lineage of the data you are seeing and more. ![Working with Candela AI in LumiCode (1 of 6)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-IZRREXBG.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=6ZuapXFTpCtbXaOtxJ2%2FkD3vNQyvjPJUuT6E5HHuGL8%3D) ![Working with Candela AI in LumiCode (2 of 6)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-9JD48XGC.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=1agc%2BOVnwSlX9v%2BfNdIWRO%2BWOX2cKRU%2BWuA45lNRp44%3D) ![Working with Candela AI in LumiCode (3 of 6)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-N6RO1DKO.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=myCquvcv%2B9DVrMxCAPDL0FPCZOf39xF0JbLvi1XjF1w%3D) ![Working with Candela AI in LumiCode (4 of 6)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-PHY6L5YP.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=Tb3tij73keJY2DDfz62goWrlWBP7NKdwqzBqA403xMg%3D) ![Working with Candela AI in LumiCode (5 of 6)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-43FT3AQG.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=crNUVq0iHo36t72OVkH2fxe%2BVT3%2BDP9xY2qU49aTB3M%3D) ![Working with Candela AI in LumiCode (6 of 6)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-ZHJP0UMW.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=31UM6AQImzrcsCjrFemOOrDKkdgmvhIrv1h1Z7rZMYs%3D) ## Catalog browsing `/catalog` gives you an interactive, searchable tree, including detail cards of providers/views, links to documentation, lineage, dependencies, uses of providers, etc. ![Searchable provider tree in /catalog](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-X872NQJM.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=xDs3ebX4v3Y87DWtKY7AHcNQihdvbvoXylqFWr7S%2Fwk%3D) ### Detail view ![Catalog detail card for a provider (1 of 2)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-LQ4YGOXO.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=pHSeH3cMkkldzoUBhggUACNLu42z5GmO45LnUbHb7bA%3D) ![Catalog detail card for a provider (2 of 2)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-I8QLJYAY.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=YoivJka85QZ5iHLO9YwY9XxJ%2BMkcaE8S0acP0jrk19U%3D) ### Lineage You can see everything that depends on a provider / view: ![Lineage: everything that depends on a provider or view](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-V33ZNXI1.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=fKw2DV69Mpc4wzsrpLg0wBHEXtTNDoW8%2BwVI8G%2Bz%2BtI%3D) ... and everything that a view depends on: ![Lineage: everything a view depends on](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-6VTAFGHI.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=zaJ3ibd1b1a%2BhG7CE%2BRUHFt%2BixzJoGlD3wQa3JWU1Kw%3D) ### View details You can see many other view details, such as their definitions, the query that created them (so you can easily update them), etc. ![View details in the catalog (1 of 2)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-1QCJYYFG.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=DBei%2F%2FiVxKxrFO%2BatjvntEy5XlBVVddEO7oZw1vq2Mg%3D) ![View details in the catalog (2 of 2)](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-R7YN9M38.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=3zyeOHHo9h2VMZ2Sx053xcqyX2VfsVIlu%2FUJAh1xq10%3D) ## History Many forms of "user action history" are available in LumiCode. You can query all of these through providers, but LumiCode also has simple commands with directed user interfaces to view this information. They all start with a time range first, so searches stay fast. ### Query history With `/history` you can search for queries with various SQL in them and limit to only failed ones. By default you see only your own queries. Users granted the `GlobalMetadataVisibility` activity on the `Sys.Logs.HcQuery` provider see queries from everyone in their domain (their organisation's LUSID environment). ![Searching query history with /history](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-Z5NELQ0Z.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=A6ehr4tp1kWQSNkIeku2zmMNf8XGNT25C225Qt4JYEc%3D) To get a past query back, or its results, see [How do I find and re-run a past query?](/v1/docs/how-do-i-find-and-re-run-a-past-query) To have a query run by itself on a timetable, see [How do I schedule a query from LumiCode?](/v1/docs/how-do-i-schedule-a-query-from-lumicode) ### API call history With `/api-history` you can search for API calls for any FINBOURNE application in a given time range, limit to only failed ones (and filter by error message also). By default you see only your own calls; users granted the `GlobalMetadataVisibility` activity on the `Lusid.Logs.AppRequest` provider see calls from everyone in their domain. ![Searching API call history with /api-history](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-YTEEVE94.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=Q%2B2%2FF1slBwrvuQcx%2FIOfXaDer5CmAMlzqgJAsOpJv8E%3D) ### Access check history With `/access-history` you can search for access checks made by any application (or all of them). By default you see only your own access checks; users granted the Insights `accesslogs-view-all` permission see everyone's in their domain. ![Searching access check history with /access-history](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-U7VWWWID.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=d%2FiKiGC7mrPyxLYAs0VMnjdEoGjVkfhq8HK1NbUTjaI%3D) ## Failure diagnosis `/diagnose` gathers everything the platform recorded about one query run into a single report: the provider call that actually failed, even inside a view, every execution and provider call with its timings, and the full feedback log. You can save the report as Markdown for FINBOURNE Support or an AI assistant. ![Investigating a query run with /diagnose](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-FS3BKLYN.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A34%3A46Z&se=2026-11-18T20%3A34%3A46Z&sr=b&sp=r&sig=0KbqqQOcFdB29sYmrnAznwP5h9ZnoWsiub5gkN1pwzI%3D) To use it, see [How do I diagnose a failed query?](/v1/docs/how-do-i-diagnose-a-failed-query)