Select AI Concepts
Explores the concepts and terms related to Select AI.
- Actions
- AI Profile
- AI Provider
- Conversations
- Database Credentials
- Hallucination in LLM
- IAM
- Large Language Model (LLM)
- Metadata
- Metadata Clone
- Natural Language Prompts
- Network Access Control List (ACL)
- Retrieval Augmented Generation (RAG)
- Semantic Similarity Search
- Vector Distance
- Vector Index
- Vector Store
Actions
An action in Select AI is a keyword that instructs Select AI to perform different behavior when acting on the prompt. By specifying an action, users can instruct Select AI to process their natural language prompt to generate SQL code, to respond to a chat prompt, narrate the output, display the SQL statement, or explain the SQL code, leveraging the LLMs to efficiently interact with the data within their database environment.
The following are the supported actions for Select AI:
-
runsql
: Generates the SQL statement for a natural language prompt and runs the underlying SQL query to return a rowset. This is the default action and does not require specifying this parameter. -
showsql
: Displays the SQL statement for a natural language prompt. -
narrate
: Sends the result of the SQL query run by the database back to the LLM to generate a natural language description of that result.When a vector index is specified in the AI profile to enable RAG, the system uses the specified transformer model to create a vector embedding from the prompt for semantic similarity search against the vector store.. The system then adds the retrieved content from the vector store to the user prompt and sends it to the LLM to generate a response based on this information.
-
chat
: Passes the user prompt directly to the LLM to generate a response, which is provided to the user. -
explainsql
: Explains the generated SQL from the prompt into natural language. This option sends the generated SQL to the AI provider, which then produces a natural language explanation.
For more details on how you can use these actions, see Examples of Using Select AI.
Parent topic: Select AI Concepts
AI Profile
Parent topic: Select AI Concepts
AI Provider
An AI Provider in Select AI refers to the service provider that supplies the LLM or transformer or both for processing and generating responses to natural language prompts. These providers offer models that can interpret and convert natural language for the use cases highlighted under the LLM concept. See Select your AI Provider and LLMs for the supported providers.
Parent topic: Select AI Concepts
Conversations
Conversations in Select AI represent an interactive exchange between the user and the system, enabling users to query or interact with the database through a series of natural language prompts. Select AI incorporates up to 10 previous prompts into the current request, creating an augmented prompt sent to the LLM. See Enable Conversations to Enhance User Interaction.
Parent topic: Select AI Concepts
Database Credentials
Parent topic: Select AI Concepts
Hallucination in LLM
Parent topic: Select AI Concepts
IAM
Parent topic: Select AI Concepts
Large Language Model (LLM)
A Large Language Model (LLM) refers to an advanced type of artificial intelligence model that is trained on massive amounts of text data to support a range of use cases depending on their training data. This includes understanding and generating human-like language as well as software code and database queries. These models are capable of performing a wide range of natural language processing tasks, including text generation, translation, summarization, question answering, sentiment analysis, and more. LLMs are typically based on sophisticated deep learning neural network models that learn patterns, context, and semantics from the input data, enabling them to generate coherent and contextually relevant text.
Parent topic: Select AI Concepts
Metadata
Parent topic: Select AI Concepts
Metadata Clone
Parent topic: Select AI Concepts
Natural Language Prompts
Parent topic: Select AI Concepts
Network Access Control List (ACL)
Parent topic: Select AI Concepts
Retrieval Augmented Generation (RAG)
Most commonly, RAG involves vector search, but more generally, includes augmenting a prompt of database content (either manually or automatically) such as schema metadata for SQL generation or database content explicitly queried. Other forms of augmentation can involve technologies such as graph analytics and traditional machine learning.
Parent topic: Select AI Concepts
Semantic Similarity Search
Parent topic: Select AI Concepts
Vector Distance
Parent topic: Select AI Concepts
Vector Index
Parent topic: Select AI Concepts
Vector Store
Parent topic: Select AI Concepts