Work with AI Prompts

use this guide to draft high quality prompts to assist ai tools in using the {{ocient}} documentation and sql dialect with greater accuracy the guide explains why drafting ai prompts for the ocient documentation helps produce better results these reasons include large models often default to generic sql or other vendor syntax additional guidance helps scrapers navigate documentation libraries the llms txt index page provides the cleanest and ai friendly entry point to the documentation key ai prompt recommendations follow these key recommendations for working with the ocient documentation include ocient documentation urls start prompts with one or more links to anchor the model on authoritative content in prompts, specify the ai index page https //docs ocient com/llms txt to provide full documentation reference for models if relevant, include the exact topic url (e g , sql reference, machine learning, data pipelines) explicitly require ocient sql in your prompt, specifically dictate to the ai model to use ocient sql, such as use ocient sql syntax or do not use non‑ocient sql variants such text is particularly helpful to avoid generic responses for prompts that involve complex data types or ocient specific syntax for {{timekey}} , secondary indexes, or ddl statements ai prompt templates use these templates and fill in your question and context setting information in the < > sections, while keeping the rest of the text intact general questions this template is suitable for general questions for ocient system usage use this context setting text prior to asking your question you are answering using the official ocient documentation start from https //docs ocient com/llms txt and reference the linked pages there use only ocient sql syntax in examples and explanations do not include sql features or syntax from other databases question \<your question here> create an ocient sql query this ai prompt helps ensure an ai tool adheres to ocient sql in the response the performance of the generated sql query depends on the specifics of your data edit the resulting sql query to meet your needs you are answering using the official ocient documentation start at https //docs ocient com/llms txt and reference the linked pages there use ocient sql syntax only; do not use postgres/mysql/spark sql or other variants if uncertain about any detail, cite the exact ocient page used task draft an ocient sql query to achieve \<describe the goal clearly, including relevant tables or columns and any filters or joins > context (optional but helpful) \ schema snippets, table snippets, or column types \ performance or indexing considerations \ any assumptions or edge cases output format 1\) a single ocient sql query 2\) a brief explanation (2–3 sentences) 3\) citations to the specific ocient documentation pages used reference pages (if applicable to the task) \<point to any relevant reference pages > ai prompts for specific use cases for more accurate responses, use your prompt to point to the relevant page url in the documentation each page in this table provides high level usage information for the specified topic topic url loading https //docs ocient com/load data installation https //docs ocient com/install an ocient system machine learning https //docs ocient com/machine learning model functions geospatial https //docs ocient com/geospatial functions data types https //docs ocient com/data types ddl statements https //docs ocient com/data definition language ddl statement reference errors and warnings https //docs ocient com/errors and warnings troubleshooting low‑quality r esponses if the responses from your ai prompts are inaccurate, try modifying them with these suggestions for generic responses, add the use ocient sql only text and also the sql reminders in docid\ vhtf8wrbv ros9gltnlp0 for functions that appear incorrect, ask the ai tool to navigate to https //docs ocient com/llms txt and cite the specific page it referenced for incorrect structure, provide a minimal schema snippet and restate data types (such as complex types of arrays, tuples, or matrixes) if navigation or footer text appears, restate start from llms txt, ignore navigation and footer content if the ai tool continues to have issues accessing the documentation, download the pdf of the ocient documentation and upload it into the ai prompt related links https //platform openai com/docs/guides/prompt engineering/six strategies for getting better results docid 8e3zm zk6zrgdkuo08kza docid\ s0dywbqubbanzcnc4z9fx