> ## Documentation Index
> Fetch the complete documentation index at: https://docs.maia.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Maia glossary

export const s_runner = "Streaming runner";

export const designer = "Designer";

export const maia_agents = "Maia AI Agents";

export const maia = "Maia";

A reference guide to key terms and concepts in {maia}, based on official documentation.

***

## A

**[Account regions](/docs/administration/account-regions):** The geographic region selected when creating a {maia} account, which determines where data and resources are stored and processed and cannot be changed after account creation.

**[Account roles](/docs/administration/account-roles):** Roles assigned at the account level that determine what a user can do across their entire {maia} account.

**[ActiveCampaign](/docs/components/activecampaign):** A Flex connector that loads data from ActiveCampaign into your data warehouse.

**[Add Partition](/docs/components/add-partition):** An orchestration component (Amazon Redshift only) that defines the Amazon S3 directory structure for partitioned external table data by attributing values to each partition.

**[Agent](/docs/guides/runner-overview):** A lightweight service installed within your infrastructure that executes pipeline tasks and securely connects {maia} to your data sources and warehouses.

**[Agent logs](/docs/guides/runner-logs):** Records of events and errors generated by agents during pipeline execution, used for monitoring and troubleshooting.

**[Agent versions](/docs/guides/runner-updates):** Different releases of the agent software with specific features and capabilities.

**[Aggregate](/docs/components/aggregate):** A transformation component that groups data and applies summary functions (SUM, COUNT, AVG, MIN, MAX) to produce calculated results.

**[AI Analyze Sentiment](/docs/components/databricks-ai-analyze-sentiment):** An AI component (Databricks only) that uses the Databricks `ai_analyze_sentiment()` function to perform sentiment analysis on input text.

**[AI Classify](/docs/components/databricks-ai-classify):** An AI component (Databricks only) that uses the Databricks `ai_classify()` function to classify input text according to labels you provide.

**[AI Extract](/docs/components/databricks-ai-extract):** An AI component (Databricks only) that uses the Databricks `ai_extract()` function to extract entities from a given text input according to labels you provide.

**[AI Fix Grammar](/docs/components/databricks-ai-fix-grammar):** An AI component (Databricks only) that uses the Databricks `ai_fix_grammar()` function to correct grammatical errors in text in your input table.

**[AI Mask](/docs/components/databricks-ai-mask):** An AI component (Databricks only) that uses the Databricks `ai_mask()` function to identify and mask specified entities in unstructured text.

**[AI Note](/docs/guides/ai-note):** A feature that enables {maia} to automatically annotate pipeline components with contextual notes using Markdown, making collaboration clearer and easier.

**[AI Query](/docs/components/databricks-ai-query):** An AI component (Databricks only) that uses the Databricks `ai_query()` function to obtain answers to natural-language questions from a chat model endpoint.

**[AI Similarity](/docs/components/databricks-ai-similarity):** An AI component (Databricks only) that uses the Databricks `ai_similarity()` function to compute the semantic similarity score between two strings.

**[AI Summarize](/docs/components/databricks-ai-summarize):** An AI component (Databricks only) that uses the Databricks `ai_summarize()` function to generate a summary of a given input text.

**[AI Translate](/docs/components/databricks-ai-translate):** An AI component (Databricks only) that uses the Databricks `ai_translate()` function to translate text to a specified target language.

**[Alter table](/docs/components/alter-table):** An orchestration component that modifies the structure of an existing table in the data warehouse.

**[Alter Warehouse](/docs/components/alter-warehouse):** An orchestration component (Snowflake only) that modifies the configuration of an existing Snowflake warehouse from within {designer}.

**[Amazon Bedrock Prompt](/docs/components/amazon-bedrock-prompt):** An AI component that uses a large language model (LLM) via Amazon Bedrock to provide responses to user-composed prompts by combining inputs from a source table with configured prompts.

**[Amazon OpenSearch Upsert](/docs/components/amazon-opensearch-upsert):** A Modular connector that inserts or updates documents in Amazon OpenSearch Service.

**[Amazon Redshift Load](/docs/components/amazon-redshift-load):** A Modular connector that loads data into Amazon Redshift.

**[Amazon S3 streaming destination](/docs/streaming/amazon-s3-streaming-destination):** A streaming pipeline destination that writes captured change events directly to Amazon S3 for storage.

**[Amazon Textract Input](/docs/components/amazon-textract-input):** A Modular connector that extracts text and structured data from documents using Amazon Textract.

**[Amazon Transcribe Input](/docs/components/amazon-transcribe-input):** A Modular connector that transcribes audio to text using Amazon Transcribe.

**[Amplitude](/docs/components/amplitude):** A Flex connector that loads data from Amplitude into your data warehouse.

**[Analyze Tables](/docs/components/analyze-tables):** An orchestration component (Amazon Redshift only) that runs the Amazon Redshift ANALYZE command on a list of tables to rebuild statistical metadata for optimized query performance.

**[Anaplan](/docs/components/anaplan):** A Modular connector that loads data from Anaplan into your data warehouse.

**[And](/docs/components/and):** An orchestration component that waits for all of its input components to complete before continuing the pipeline.

**[API](/docs/api-reference/maia-api-overview):** Programmatic interfaces that allow external systems to interact with {maia}, including running pipelines, and managing projects, and retrieving execution status.

**[Append to Grid](/docs/components/append-to-grid):** An orchestration component that appends or prepends rows to an existing grid variable.

**[Artifacts](/docs/guides/artifacts):** Deployable packages containing pipelines and configurations that can be scheduled and executed via the API.

**[Asana](/docs/components/asana):** A Flex connector that loads data from Asana into your data warehouse.

**[Assert External Table](/docs/components/assert-external-table):** An orchestration component that validates that an external table has been created with the correct metadata, and asserts a row count using comparison operators.

**[Assert Scalar Variables](/docs/components/assert-scalar-variables):** An orchestration component that validates variable values against expected conditions during pipeline execution.

**[Assert Table](/docs/components/assert-table):** An orchestration component that validates a table exists, and optionally checks its structure.

**[Assert Table Values](/docs/components/assert-table-values):** An orchestration component that verifies data in a specified table matches a fixed set of expected values defined in the component, writing any differences to another table.

**[Assert View](/docs/components/assert-view):** A transformation component that verifies a dataset meets specified conditions, including metadata, values, and row count.

**[Attio](/docs/components/attio):** A Flex connector that loads data from Attio into your data warehouse.

**[Audit Service](/docs/guides/audit-service):** A service that records user actions and system events for security monitoring and compliance.

**[Authentication](/docs/guides/authentication):** The process of setting up and authorizing API credentials for accessing the {maia} REST API.

**[AVRO Load](/docs/components/avro-load):** An orchestration component that loads data into a table from one or more AVRO files, automatically inferring the schema and creating the corresponding table.

**[AWS IAM roles](/docs/guides/aws-iam-roles):** AWS Identity and Access Management roles required for agent deployment and operation on AWS.

**[AWS PrivateLink](/docs/guides/aws-privatelink):** A network configuration for secure, private connectivity between {maia} and AWS services.

**[Azure Blob Storage Load](/docs/components/azure-blob-storage-load):** An orchestration component that loads data into an existing table from objects stored in Azure Blob Storage.

**[Azure Blob Storage streaming destination](/docs/streaming/azure-blob-storage-streaming-destination):** A streaming pipeline destination that writes captured change events directly to Azure Blob Storage for storage.

**[Azure Blob Storage Unload](/docs/components/azure-blob-storage-unload):** An orchestration component that creates files on a specified Azure Blob Storage account and populates them by copying data from a designated table or view.

**[Azure Cosmos DB for NoSQL](/docs/components/azure-cosmos-db-for-nosql):** A Flex connector that loads data from Azure Cosmos DB for NoSQL into your data warehouse.

**[Azure Document Intelligence](/docs/components/azure-document-intelligence):** A Modular connector that extracts text and structured data from documents using Azure Document Intelligence.

**[Azure OpenAI Prompt](/docs/components/azure-openai-prompt):** An AI component that uses a large language model (LLM) via Azure OpenAI to provide responses to user-composed prompts by combining inputs from a source table with configured prompts.

**[Azure Queue Storage Message](/docs/components/azure-queue-storage-message):** An orchestration component that posts a message to Azure Queue Storage for processing by other applications.

**[Azure Speech Transcribe](/docs/components/azure-speech-transcribe):** A Modular connector that transcribes audio to text using Azure Speech Services.

**[Azure SQL](/docs/components/azure-sql):** A Modular connector that loads data from Azure SQL Database into your data warehouse.

***

## B

**[Bash Pushdown](/docs/components/bash-pushdown):** An orchestration component that uses SSH connections to run Bash scripts on your own instances, displaying script output in task messages.

**[Begin](/docs/components/begin):** An orchestration component that starts a new transaction within the database.

**[Bing Ads Query](/docs/components/bing-ads-query):** A query connector that loads data from Bing Ads into your data warehouse.

**[Box](/docs/components/box):** A Flex connector that loads data from Box into your data warehouse.

**[Branches](/docs/guides/branches):** Parallel versions of your project that allow you to develop and test changes independently before merging into the main codebase.

**[Braze](/docs/components/braze):** A Flex connector that loads data from Braze into your data warehouse.

**[Brevo](/docs/components/brevo):** A Flex connector that loads data from Brevo into your data warehouse.

**[Bugcrowd](/docs/components/bugcrowd):** A Flex connector that loads data from Bugcrowd into your data warehouse.

**[Buildkite](/docs/components/buildkite):** A Flex connector that loads data from Buildkite into your data warehouse.

***

## C

**[Calculator](/docs/components/calculator):** A transformation component that creates new columns using SQL expressions and calculations.

**[Chargebee](/docs/components/chargebee):** A Flex connector that loads data from Chargebee into your data warehouse.

**[Chunk Text](/docs/components/chunk-text):** An orchestration component that splits text or Markdown data into smaller chunks using a Python UDF in Snowflake, for use in AI pipelines.

**[CircleCI](/docs/components/circleci):** A Flex connector that loads data from CircleCI into your data warehouse.

**[ClickUp](/docs/components/clickup):** A Flex connector that loads data from ClickUp into your data warehouse.

**[Cloud Pub/Sub](/docs/components/pubsub):** An orchestration component that publishes messages to a topic on Google Cloud Platform for other applications to receive via subscriptions.

**[CloudWatch Publish](/docs/components/cloudwatch-publish):** An orchestration component that publishes metrics to Amazon CloudWatch, enabling you to attach alarms and alerts for metric values.

**[Coalesce](/docs/components/coalesce):** A Flex connector that loads data from the Coalesce data platform into your data warehouse.

**[Code Editor](/docs/guides/code-editor):** An editor in {designer} for viewing and editing file types such as SQL and Python scripts, which can then be linked to [SQL Script](/docs/components/sql-script) and [Python Pushdown](/docs/components/python-pushdown) components.

**[Commit](/docs/components/commit):** An orchestration component that ends a database transaction and makes all changes visible to other database users.

**[Commit changes (Git action)](/docs/guides/git-commit):** Saving your pipeline changes to the Git repository with a descriptive message.

**[Compare changes (Git action)](/docs/guides/git-compare):** Viewing differences between branches or commits in your project.

**[Compare Table Values](/docs/components/compare-table-values):** An orchestration component that compares the data in a specified table against another table and writes any differences to a separate table.

**[Components](/docs/guides/components-overview):** The fundamental building blocks of pipelines—configurable units that perform specific operations.

**[Concord](/docs/components/concord):** A Flex connector that loads data from Concord into your data warehouse.

**[Confluence](/docs/components/confluence):** A Flex connector that loads data from Confluence into your data warehouse.

**[Construct Variant](/docs/components/construct-variant):** A transformation component (Snowflake only) that converts rows of data into key:value pair arrays, outputting them as variant-type data for storing semi-structured formats such as JSON.

**[Context Files](/docs/guides/maia-context-files):** Custom files that provide Maia with project-specific context and instructions.

**[Contributor (environment role)](/docs/administration/environment-roles#contributor-role-permissions):** An environment role that allows users to validate, sample, run, and publish pipelines, view executions and lineage, and manage schedules within an environment.

**[Contributor (project role)](/docs/administration/project-roles#contributor-role-permissions):** A project role that allows users to create and manage pipelines, branches, secrets, and OAuth connections, and perform Git operations, but cannot manage project settings or users.

**[Convert String To Struct](/docs/components/convert-string-to-struct):** A transformation component (Databricks only) that converts JSON-format data stored as a STRING data type into a Databricks STRUCT data type for querying and manipulation.

**[Convert Type](/docs/components/convert-type):** A transformation component that changes the data type of columns.

**[Cortex Completions](/docs/components/cortex-completions):** An AI component (Snowflake only) that uses Snowflake Cortex to receive a prompt and generate a response using a supported large language model.

**[Cortex Embed](/docs/components/cortex-embed):** An AI component (Snowflake only) that converts English-language text into a Cortex vector embedding of 768 or 1024 dimensions for use in AI pipelines.

**[Cortex Extract Answer](/docs/components/cortex-extract-answer):** An AI component (Snowflake only) that uses Snowflake Cortex to answer a natural-language question by extracting the answer from your dataset.

**[Cortex Finetune](/docs/components/cortex-finetune):** An AI component (Snowflake only) that uses Snowflake Cortex to fine-tune large language models (LLMs) on your organization's data for domain-specific use cases.

**[Cortex Multi Prompt](/docs/components/cortex-multi-prompt):** An AI component (Snowflake only) that uses Snowflake Cortex to process multiple prompts and generate responses using a supported large language model.

**[Cortex Parse Document](/docs/components/cortex-parse-document):** An AI component (Snowflake only) that uses Snowflake Cortex to extract content from PDFs and image files stored on an internal or external stage.

**[Cortex Sentiment](/docs/components/cortex-sentiment):** An AI component (Snowflake only) that uses Snowflake Cortex to analyze English-language input text and return a sentiment score.

**[Cortex Summarize](/docs/components/cortex-summarize):** An AI component (Snowflake only) that uses Snowflake Cortex to summarize the input text of one or more columns and write the result to new output columns.

**[Cortex Translate](/docs/components/cortex-translate):** An AI component (Snowflake only) that uses Snowflake Cortex to translate the input text of one or more columns from one supported language to another.

**[Create External Table](/docs/components/create-external-table):** An orchestration component that defines a table referencing data stored outside the data warehouse. External tables don't store data themselves but can be queried like regular tables.

**[Create File Format](/docs/components/create-file-format):** An orchestration component (Snowflake only) that creates a named file format for use in bulk loading and unloading data in Snowflake tables.

**[Create Stream](/docs/components/create-stream):** An orchestration component (Snowflake only) that creates a new Snowflake Stream in a specified schema and table to capture data changes.

**[Create Table](/docs/components/create-table):** An orchestration component that creates a new table in the data warehouse.

**[Create View](/docs/components/create-view):** A transformation component that outputs a virtual table (SQL view) to your cloud data warehouse based on the upstream dataset, without storing data itself.

**[CSV Load](/docs/components/csv-load):** An orchestration component that loads data into a table from one or more CSV files, automatically inferring the schema and creating the corresponding table.

**[Custom Connector](/docs/guides/custom-connector-overview):** User-defined connectors that extract data from REST APIs returning JSON responses.

***

## D

**[Data Cleanse](/docs/components/data-cleanse):** A transformation component that profiles data, identifies data quality issues, and applies configurable rules to cleanse a dataset.

**Data Loader:** A service for easily loading data from various sources into your cloud data warehouse.

**[Data quality framework](/docs/guides/data-quality-framework):** A set of approaches and components in {maia} for identifying and addressing data quality issues across pipelines.

**[Data Transfer](/docs/components/data-transfer):** An orchestration component that transfers files from a chosen source to a chosen target using common network protocols, supporting files of any type.

**[Database Query](/docs/components/database-query):** An orchestration component that runs SQL queries on an accessible cloud or on-premises database and copies the results to a table.

**[Databricks](/docs/components/databricks):** A Modular connector that loads data from Databricks into your data warehouse.

**[Databricks Jobs Compute](/docs/guides/databricks-jobs-compute):** A configuration in {maia} that enables transformation pipelines to run on a Databricks Jobs Compute cluster by specifying the cluster details and associating the configuration with an environment.

**[Databricks Vector Search](/docs/components/databricks-vector-search):** An AI component (Databricks only) that performs a vector similarity search on an input table to find content that best answers specific questions using embeddings in your Databricks account.

**[Datadog](/docs/components/datadog):** A Flex connector that loads data from Datadog into your data warehouse.

**[Db2 for IBM i streaming connector](/docs/streaming/db2-for-ibm-i-streaming-source):** A streaming connector that monitors and captures row-level changes within Db2 for IBM i schemas using journal entries for tracked tables.

**[dbt Cloud](/docs/components/dbt-cloud):** A Flex connector that loads data from dbt Cloud into your data warehouse.

**[dbt Core](/docs/components/dbt-core):** An orchestration component that runs dbt commands as part of a pipeline.

**[Delete Tables](/docs/components/delete-tables):** An orchestration component that removes tables from the data warehouse.

**[Delighted](/docs/components/delighted):** A Flex connector that loads data from Delighted into your data warehouse.

**[Deployment](/docs/security/deployment-options):** The way {maia} is configured and hosted. The agents available include the [Streaming agent](/docs/streaming/create-streaming-agent), and [{maia} agent](/docs/guides/runner-overview).

**[{designer}](/docs/guides/designer-overview):** The visual, drag-and-drop interface for building data pipelines in {maia}.

**[Detect Changes](/docs/components/detect-changes):** A transformation component that compares two tables and adds a column indicating whether each row was inserted, deleted, changed, or unchanged.

**[Distinct](/docs/components/distinct):** A transformation component that removes duplicate rows from data.

**[Dixa](/docs/components/dixa):** A Flex connector that loads data from Dixa into your data warehouse.

**[Document AI Predict](/docs/components/document-ai-predict):** An AI component (Snowflake only) that extracts data from documents such as PDFs and images using Snowflake's Document AI model prediction function.

**[Maia Flex connector](/docs/components/maia-flex-connector):** A Flex connector that loads data from the {maia} API into your data warehouse.

**[Dropbox](/docs/components/dropbox):** A Flex connector that loads data from Dropbox into your data warehouse.

**[Dynamics 365 Business Central](/docs/components/dynamics-365-business-central):** A Flex connector that loads data from Microsoft Dynamics 365 Business Central into your data warehouse.

**[Dynamics 365 Query](/docs/components/dynamics-365-query):** A query connector that loads data from Microsoft Dynamics 365 into your data warehouse.

**[DynamoDB Query](/docs/components/dynamodb-query):** A query connector that loads data from Amazon DynamoDB into your data warehouse.

***

## E

**[Editions](/docs/administration/editions):** Different subscription tiers of {maia} with varying features and capabilities.

**[Email Query](/docs/components/email-query):** A query connector that loads data from email services into your data warehouse.

**[End Failure](/docs/components/end-failure):** An orchestration component that ends a pipeline execution with a failure status.

**[End Success](/docs/components/end-success):** An orchestration component that ends a pipeline execution with a success status.

**[Environment roles](/docs/administration/environment-roles):** Roles assigned at the environment level that control what users can do within specific environments. The four environment roles are **Owner**, **Contributor**, **Operator**, and **Viewer**.

**[Environments](/docs/guides/environments):** Configured connections to cloud data warehouses (Snowflake, Databricks, Redshift) with associated settings.

**[Eventbrite](/docs/components/eventbrite):** A Flex connector that loads data from Eventbrite into your data warehouse.

**[Excel Query](/docs/components/excel-query):** A query connector that loads data from Microsoft Excel into your data warehouse.

**[Except](/docs/components/except):** A transformation component that compares two datasets and returns only the rows that exist in the primary dataset but not the comparison dataset. Equivalent to the SQL EXCEPT operator.

**[Extract Nested Data](/docs/components/extract-nested-data):** A transformation component that unpacks JSON-formatted data stored in variant-type columns into structured columns and rows.

**[Extract Structured Data](/docs/components/extract-structured-data):** A transformation component (Databricks only) that unpacks arrays of structured data in STRUCT or ARRAY data types into columns and rows of data in a table.

***

## F

**[Facebook Ads Query](/docs/components/facebook-ads-query):** A query connector that loads data from Facebook Ads into your data warehouse.

**[Facebook Query](/docs/components/facebook-query):** A query connector that loads data from Facebook into your data warehouse.

**[Failover recovery](/docs/streaming/failover-recovery):** The process by which a {s_runner} reconnects and resumes streaming from the correct position when a source database fails over to a standby.

**[Fanatics](/docs/components/fanatics):** A Flex connector that loads data from Fanatics into your data warehouse.

**[File Iterator](/docs/components/file-iterator):** An orchestration component that loops through files in cloud storage, executing operations for each file.

**[Filter](/docs/components/filter):** A transformation component that selects rows based on specified conditions.

**[FireHydrant](/docs/components/firehydrant):** A Flex connector that loads data from FireHydrant into your data warehouse.

**[First/Last](/docs/components/first-last):** A transformation component that groups data, sorts the groups, and returns only the first or last row of each group using SQL window functions.

**[Fixed Flow](/docs/components/fixed-flow):** A transformation component that generates a table of data for use downstream in the pipeline, with values defined at design time or from variables at runtime.

**[Fixed Iterator](/docs/components/fixed-iterator):** An orchestration component that loops through a predefined list of values.

**[Flatten Variant](/docs/components/flatten-variant):** A transformation component (Snowflake only) that unpacks arrays of semi-structured data, such as JSON, into structured columns and rows.

**[Flex Connectors](/docs/guides/flex-connector-introduction):** Advanced custom connectors with extended capabilities for complex API integrations.

**[Float](/docs/components/flex-float):** A Flex connector that loads data from Float into your data warehouse.

**[Freshdesk](/docs/components/freshdesk):** A Flex connector that loads data from Freshdesk into your data warehouse.

***

## G

**[Generate Sequence](/docs/components/generate-sequence):** An orchestration component that creates a sequence of numbers or dates for iteration.

**[Git in Designer](/docs/guides/git-overview):** Version control integration for tracking changes to pipelines and enabling collaboration.

**[GitHub](/docs/components/github):** A Flex connector that loads data from GitHub into your data warehouse.

**[Gmail](/docs/components/gmail):** A Modular connector that loads data from Gmail into your data warehouse.

**[Gong](/docs/components/gong):** A Flex connector that loads data from Gong into your data warehouse.

**[Google Ads Query](/docs/components/google-ads-query):** A query connector that loads data from Google Ads into your data warehouse.

**[Google Analytics Query](/docs/components/google-analytics-query):** A query connector that loads data from Google Analytics into your data warehouse.

**[Google BigQuery Query](/docs/components/google-bigquery):** A query connector that loads data from Google BigQuery into your data warehouse.

**[Google Cloud Storage Load](/docs/components/google-cloud-storage-load):** An orchestration component (Snowflake only) that loads data from Google Cloud Storage into an existing table.

**[Google Cloud Storage Unload](/docs/components/google-cloud-storage-unload):** An orchestration component that writes data from a table or view to a specified Google Cloud Storage bucket.

**[Google Sheets](/docs/components/google-sheets):** A Modular connector that loads data from Google Sheets into your data warehouse.

**[Google Vertex AI Prompt](/docs/components/vertex-ai-prompt):** An AI component that uses a Google Gemini large language model (LLM) to provide responses to user-composed prompts by combining text, image, audio, or video inputs with configured prompts.

**[Grid Iterator](/docs/components/grid-iterator):** An orchestration component that loops through rows in a grid variable, executing operations for each row.

**[Grid Variables](/docs/guides/grid-variables):** Variables that store tabular (two-dimensional) data for use in pipelines.

***

## H

**[HubSpot Load](/docs/components/hubspot-load):** A Modular connector that loads data from HubSpot into your data warehouse.

**[HubSpot Query](/docs/components/hubspot-query):** A query connector that loads data from HubSpot into your data warehouse.

***

## I

**[IBM Db2 Load](/docs/components/ibm-db2-load):** A Modular connector that loads data from IBM Db2 into your data warehouse.

**[If](/docs/components/if):** An orchestration component that evaluates an expression involving variables and routes pipeline execution depending on whether the expression is true, false, or produces a runtime error.

**[Infobip](/docs/components/infobip):** A Flex connector that loads data from Infobip into your data warehouse.

**[Intercom](/docs/components/intercom):** A Flex connector that loads data from Intercom into your data warehouse.

**[Intersect](/docs/components/intersect):** A transformation component that compares two datasets and returns only the rows that are identical in both. Equivalent to the SQL INTERSECT operator.

**[IP allow list](/docs/administration/ip-allow-list):** An account-level security feature that restricts access to {maia} to a defined list of IP addresses or CIDR ranges.

***

## J

**[JDBC](/docs/components/jdbc):** A Modular connector that runs SQL queries against any JDBC-compatible database and loads the results into your data warehouse.

**[JDBC Load](/docs/components/jdbc-load):** A Modular connector that loads data from any JDBC-compatible database into your data warehouse.

**[JDBC Table Metadata to Grid](/docs/components/jdbc-table-metadata-to-grid):** An orchestration component that retrieves metadata from a JDBC table and uses it to populate a grid variable.

**[Jira Load](/docs/components/jira-load):** A Modular connector that loads data from Jira into your data warehouse.

**[Jira Query](/docs/components/jira-query):** A query connector that loads data from Jira into your data warehouse.

**[Join](/docs/components/join):** A transformation component that combines data from multiple sources based on matching columns.

**[Jotform](/docs/components/jotform):** A Flex connector that loads data from Jotform into your data warehouse.

**[JSON Load](/docs/components/json-load):** An orchestration component that loads data into a table from one or more JSON files, automatically inferring the schema and creating the corresponding table.

***

## K

**[Kafka](/docs/components/kafka):** A Modular connector that loads data from Apache Kafka into your data warehouse.

**[Klaviyo](/docs/components/klaviyo):** A Flex connector that loads data from Klaviyo into your data warehouse.

***

## L

**[LaunchDarkly](/docs/components/launchdarkly):** A Flex connector that loads data from LaunchDarkly into your data warehouse.

**[LDAP Query](/docs/components/ldap-query):** A query connector that loads data from LDAP directory services into your data warehouse.

**[Lead/Lag](/docs/components/lead-lag):** A transformation component that retrieves values from rows preceding or following the current row, using the SQL LEAD and LAG window functions.

**[Lineage (Security)](/docs/security/data-lineage):** Security aspects of data lineage tracking and visibility.

**[Lineage ({maia})](/docs/guides/data-lineage):** Tracking of data flow from source to destination, showing how data is transformed and where it originates.

**[LinkedIn Ads](/docs/components/linkedin-ads):** A Flex connector that loads data from LinkedIn Ads into your data warehouse.

**[Lob](/docs/components/lob):** A Flex connector that loads data from Lob into your data warehouse.

**[Loop Iterator](/docs/components/loop-iterator):** An orchestration component that repeats operations a specified number of times or until a condition is met.

***

## M

**[Maia](/docs/guides/maia-overview):** Matillion's AI-powered assistant that helps design, build, and optimize data pipelines.

**[Maia AI Agents](/docs/guides/maia-ai-agents-overview):** AI agents in {maia} that build, orchestrate, and execute data pipelines in {designer} using natural language. {maia_agents} can be enabled or disabled at the account level.

**[Maia sessions](/docs/guides/maia-sessions-and-tools):** Ongoing, structured interactions between you and {maia_agents}, including the full conversation history, relevant context, and any tool-based actions performed on your behalf within the current {designer} branch.

**[Maia skills](/docs/guides/maia-skills):** Reusable sets of instructions that {maia_agents} use to respond to repetitive prompts more consistently, removing the need to repeat guidance in every prompt.

**[Mailchimp](/docs/components/mailchimp):** A Modular connector that loads data from Mailchimp into your data warehouse.

**[Mailgun](/docs/components/mailgun):** A Flex connector that loads data from Mailgun into your data warehouse.

**[Mandrill](/docs/components/mandrill):** A Flex connector that loads data from Mandrill into your data warehouse.

**[Map Values](/docs/components/map-values):** A transformation component that replaces values based on a mapping table.

**[MariaDB Load](/docs/components/mariadb-load):** A Modular connector that loads data from MariaDB into your data warehouse.

**[Marketo Load](/docs/components/marketo-load):** A Modular connector that loads data from Marketo into your data warehouse.

**[Marketo Query](/docs/components/marketo-query):** A query connector that loads data from Marketo into your data warehouse.

**[MCP Server](/docs/api-reference/mcp-server):** A Model Context Protocol server that provides a standardized way for large language models (LLMs) to interact with {maia} resources such as pipeline executions, credit usage, and pipeline runs.

**[Merge from branch (Git action)](/docs/guides/git-merge):** Combining changes from one Git branch into another.

**[Microsoft Dataverse](/docs/components/microsoft-dataverse):** A Flex connector that loads data from Microsoft Dataverse into your data warehouse.

**[Microsoft Exchange](/docs/components/microsoft-exchange):** A Modular connector that loads data from Microsoft Exchange into your data warehouse.

**[Microsoft SQL Server Load](/docs/components/microsoft-sql-server-load):** A Modular connector that loads data from Microsoft SQL Server into your data warehouse.

**[Microsoft SQL Server Output](/docs/components/sql-server-output):** An orchestration component that outputs the contents of a table or view from your cloud data warehouse to a Microsoft SQL Server database.

**[Microsoft SQL Server streaming connector](/docs/streaming/microsoft-sql-server-streaming-source):** A streaming connector that monitors and captures row-level changes within Microsoft SQL Server schemas by taking a consistent snapshot and tracking change events.

**[Mixpanel](/docs/components/mixpanel):** A Flex connector that loads data from Mixpanel into your data warehouse.

**[ML Classification](/docs/components/ml-classification-sf):** An AI component (Snowflake only) that uses the Snowflake Classification machine learning function to sort data into classes using patterns detected in training data.

**[MongoDB Query](/docs/components/mongodb-query):** A query connector that loads data from MongoDB into your data warehouse.

**[Multi-factor Authentication](/docs/administration/multi-factor-authentication):** Additional security requiring multiple verification methods to access {maia}.

**[Multi Table Input](/docs/components/multi-table-input):** A transformation component that reads data from multiple tables simultaneously.

**[MySQL streaming connector](/docs/streaming/mysql-streaming-source):** A streaming connector that monitors and captures row-level changes within MySQL schemas in a non-intrusive and performant manner.

***

## N

**[NetSuite Query](/docs/components/netsuite-query):** A query connector that loads data from Oracle NetSuite into your data warehouse.

**[NetSuite SuiteAnalytics](/docs/components/netsuite-suiteanalytics):** An orchestration component that loads data from NetSuite via SuiteAnalytics Connect into your data warehouse.

**[NetSuite SuiteAnalytics Load](/docs/components/netsuite-suiteanalytics-load):** A Modular connector that loads data from NetSuite SuiteAnalytics into your data warehouse.

**[New Relic](/docs/components/new-relic):** A Flex connector that loads data from New Relic into your data warehouse.

**[Notion](/docs/components/notion):** A Flex connector that loads data from Notion into your data warehouse.

***

## O

**[OAuth](/docs/guides/add-oauth):** Authentication protocol for securely accessing third-party APIs in custom connectors.

**[OData Query](/docs/components/odata-query):** A query connector that loads data from OData protocol services into your data warehouse.

**[Ongoing WMS](/docs/components/ongoing-wms):** A Flex connector that loads data from Ongoing WMS into your data warehouse.

**[Open Exchange Rates](/docs/components/open-exchange-rates):** A Flex connector that loads data from Open Exchange Rates into your data warehouse.

**[OpenAI Prompt](/docs/components/openai-prompt):** An AI component that uses a large language model (LLM) via OpenAI to provide responses to user-composed prompts by combining inputs from a source table with configured prompts.

**[Operator (environment role)](/docs/administration/environment-roles#operator-role-permissions):** An environment role that allows users to view executions and lineage, and manage schedules, but cannot validate, sample, run, or publish pipelines.

**[Optimize](/docs/components/optimize):** An orchestration component (Databricks only) that optimizes the layout of Databricks table data using bin-packing or Z-order colocation.

**[Or](/docs/components/or):** An orchestration component that continues the pipeline as soon as any one of its input components completes.

**[Oracle Eloqua Load](/docs/components/oracle-eloqua-load):** A connector that loads data from Oracle Eloqua into your data warehouse, with full and incremental load options.

**[Oracle Fusion Cloud Financials Load](/docs/components/oracle-fcf-load):** A Modular connector that loads data from Oracle Fusion Cloud Financials into your data warehouse.

**[Oracle Fusion Cloud Procurement Load](/docs/components/oracle-fcp-load):** A Modular connector that loads data from Oracle Fusion Cloud Procurement into your data warehouse.

**[Oracle Fusion Cloud Project Management Load](/docs/components/oracle-fcpm-load):** A Modular connector that loads data from Oracle Fusion Cloud Project Management into your data warehouse.

**[Oracle Load](/docs/components/oracle-load):** A Modular connector that loads data from Oracle Database into your data warehouse.

**[Oracle streaming connector](/docs/streaming/oracle-streaming-source):** A streaming connector that monitors and records row-level changes in Oracle databases using Oracle's native LogMiner database package.

**[Oracle Unload](/docs/components/oracle-unload-snowflake):** An orchestration component (Snowflake only) that writes data from a Snowflake source table or view to a target Oracle database.

**[Orbit](/docs/components/orbit):** A Flex connector that loads data from Orbit into your data warehouse.

**[ORC Load](/docs/components/orc-load):** An orchestration component that loads data into a table from one or more ORC files, automatically inferring the schema and creating the corresponding table.

**[Ortto](/docs/components/ortto):** A Flex connector that loads data from Ortto into your data warehouse.

**[Owner (environment role)](/docs/administration/environment-roles#owner-role-permissions):** The highest environment role with full permissions including validating, sampling, running, and publishing pipelines, viewing all data, and managing schedules.

**[Owner (project role)](/docs/administration/project-roles#owner-role-permissions):** The highest project role with full permissions including managing project settings, environments, secrets, pipelines, Git operations, and user access.

***

## P

**[PagerDuty](/docs/components/pagerduty):** A Flex connector that loads data from PagerDuty into your data warehouse.

**[Pagination](/docs/guides/pagination):** Handling paginated API responses in custom connectors.

**[Parquet Load](/docs/components/parquet-load):** An orchestration component that loads data into a table from one or more Parquet files, automatically inferring the schema and creating the corresponding table.

**[PayPal](/docs/components/paypal):** A Flex connector that loads data from PayPal into your data warehouse.

**[Pendo](/docs/components/pendo):** A Flex connector that loads data from Pendo into your data warehouse.

**[Persona](/docs/components/persona):** A Flex connector that loads data from Persona into your data warehouse.

**[Pinecone Vector Query](/docs/components/pinecone-vector-query):** An AI component that ingests text search strings and returns data associated with similar vectors in a Pinecone vector database.

**[Pinecone Vector Upsert](/docs/components/pinecone-vector-upsert):** An AI component that converts data from your cloud data warehouse into embeddings and stores them as vectors in a Pinecone vector database.

**[Pingdom](/docs/components/pingdom):** A Flex connector that loads data from Pingdom into your data warehouse.

**[Pipedrive](/docs/components/pipedrive):** A Flex connector that loads data from Pipedrive into your data warehouse.

**[Pipeline notifications](/docs/guides/pipeline-notifications):** A feature that allows {maia} users to subscribe to email or Slack alerts for pipeline failures within projects and environments they have access to.

**[Pipeline Observability](/docs/guides/pipeline-run-history):** A dashboard in {maia} that lists all pipelines and their execution history, including those run manually, on a schedule, or via the API.

**[Pipeline quality review](/docs/guides/pipeline-quality):** A feature in {designer} that checks pipelines against a defined set of quality rules to ensure they align with organizational standards.

**[Pipelines](/docs/guides/pipelines):** Sequences of connected components that perform data operations. There are two types: orchestration pipelines (for loading data from sources to warehouses) and transformation pipelines (for transforming data within the warehouse).

**[Pivot](/docs/components/pivot):** A transformation component that converts row values into columns, reducing the number of rows and increasing the number of columns. Equivalent to an SQL PIVOT function.

**[PivotalTracker](/docs/components/pivotaltracker):** A Flex connector that loads data from Pivotal Tracker into your data warehouse.

**[Postgres Vector Upsert](/docs/components/postgres-vector-upsert):** An orchestration component that converts text data from your cloud data warehouse into embeddings and stores them as vectors in a Postgres vector database.

**[PostgreSQL Load](/docs/components/postgresql-load):** A Modular connector that loads data from PostgreSQL into your data warehouse.

**[PostgreSQL streaming connector](/docs/streaming/postgresql-streaming-source):** A streaming connector that monitors and captures row-level changes within PostgreSQL schemas using the pgoutput decoding plugin.

**[Post-processing](/docs/guides/post-processing):** A feature in {designer} that dynamically updates scalar variables and defines custom output messages after a component executes.

**[Print Variables](/docs/components/print-variables):** An orchestration component that outputs variable values to the execution log.

**[Private Link](/docs/security/private-link):** Secure communication between the control plane and {maia} agents using private network connectivity, avoiding the public internet.

**[Productboard](/docs/components/productboard):** A Flex connector that loads data from Productboard into your data warehouse.

**[Project roles](/docs/administration/project-roles):** Roles assigned at the project level controlling what users can do within specific projects.

**[Projects](/docs/guides/projects):** Git-backed containers for pipelines, variables, and related files.

**[Pull remote changes (Git action)](/docs/guides/git-pull):** Fetching and merging changes from the remote Git repository.

**[Pull requests (Git action)](/docs/guides/git-pull-requests):** Requests to merge changes between branches with review workflows.

**[Push local changes (Git action)](/docs/guides/git-push):** Uploading committed changes to the remote Git repository.

**[Python Pushdown](/docs/components/python-pushdown):** A transformation component that executes Python code directly in the data warehouse for efficient processing.

**[Python Script](/docs/components/python-script):** An orchestration component that executes Python scripts for tasks such as file handling, API calls, or complex logic.

***

## Q

**[Query Result to Grid](/docs/components/query-result-to-grid):** An orchestration component that queries a table and loads the returned rows into a predefined grid variable for use elsewhere in the pipeline.

**[Query Result to Scalar](/docs/components/query-result-to-scalar):** An orchestration component that captures a single query result value into a scalar variable.

***

## R

**[Rank](/docs/components/rank):** A transformation component that adds a ranking column to data using SQL window functions such as `RANK`, `DENSE_RANK`, `PERCENT_RANK`, `CUME_DIST`, or `ROW_NUMBER`.

**[RDS Bulk Output](/docs/components/rds-bulk-output):** An orchestration component that loads the contents of a table or view into a table in an Amazon RDS database.

**[RDS Query](/docs/components/rds-query):** A query connector that loads data from Amazon RDS into your data warehouse.

**[Recurly](/docs/components/recurly):** A Flex connector that loads data from Recurly into your data warehouse.

**[Refresh Table](/docs/components/refresh-table):** An orchestration component that refreshes table metadata or data.

**[Refresh External Table](/docs/components/refresh-external-table):** An orchestration component that refreshes an external table, re-syncing it with the target data.

**[Refresh Materialized View](/docs/components/refresh-materialized-view):** An orchestration component (Amazon Redshift only) that refreshes a materialized view by applying changes from its underlying tables.

**[Registration](/docs/administration/registration):** The process of creating a {maia} account.

**[Remove from Grid](/docs/components/remove-from-grid):** An orchestration component that removes rows from a grid variable based on matching criteria.

**[Rename](/docs/components/rename):** A transformation component that changes column names.

**[Reset branch (Git action)](/docs/guides/git-hard-reset):** Resetting a branch to a previous commit state.

**[Retry](/docs/components/retry):** An orchestration component that repeatedly attempts to run a connected component until it succeeds or a maximum number of attempts is reached.

**[Revert changes (Git action)](/docs/guides/git-revert):** Undoing changes by creating a new commit that reverses previous changes.

**[Rewrite Table](/docs/components/rewrite-table):** A transformation output component that replaces a table's contents with new data.

**[RingCentral](/docs/components/ringcentral):** A Flex connector that loads data from RingCentral into your data warehouse.

**[Role Based Access Control](/docs/administration/role-based-access-control-overview):** Security model where permissions are assigned through roles at account, project, and environment levels.

**[Rollback](/docs/components/rollback):** An orchestration component that ends a transaction in a database, and reverts any changes made to a previous state or version.

**[Rootly](/docs/components/rootly):** A Flex connector that loads data from Rootly into your data warehouse.

**[Run Notebook](/docs/components/run-notebook):** An orchestration component that executes a Databricks notebook from within a pipeline.

**[Run Orchestration](/docs/components/run-orchestration):** An orchestration component that executes another orchestration pipeline.

**[Run Shared Pipeline](/docs/components/run-shared-pipeline):** An orchestration component that executes a shared pipeline to completion.

**[Run Transformation](/docs/components/run-transformation):** An orchestration component that executes a transformation pipeline from within an orchestration pipeline.

***

## S

**[S3 Load](/docs/components/s3-load):** An orchestration component that loads data into an existing table from objects stored in Amazon S3.

**[S3 Unload](/docs/components/s3-unload):** An orchestration component that creates files on a specified Amazon S3 bucket and populates them by copying data from a designated table or view.

**[Sage Intacct Load](/docs/components/sage-intacct-load):** A connector that loads data from Sage Intacct into your data warehouse, with full and incremental load options.

**[Salesforce Load](/docs/components/salesforce-load):** A Modular connector that loads data from Salesforce into your data warehouse.

**[Salesforce Marketing Cloud Query](/docs/components/salesforce-marketing-cloud-query):** A query connector that loads data from Salesforce Marketing Cloud into your data warehouse.

**[Salesforce Output](/docs/components/salesforce-output):** An orchestration component that writes the contents of a source table or view back into a Salesforce table using the Salesforce API.

**[Salesforce Pardot](/docs/components/salesforce-pardot):** A Flex connector that loads data from Salesforce Pardot into your data warehouse.

**[Salesforce Query](/docs/components/salesforce-query):** A query connector that loads data from Salesforce into your data warehouse.

**[Salesloft](/docs/components/salesloft):** A Flex connector that loads data from Salesloft into your data warehouse.

**[Sampling output](/docs/guides/sampling-output):** A feature that lets you preview the data output by a component to confirm it is configured correctly before using it in a live pipeline.

**[SAP NetWeaver](/docs/components/sap-netweaver):** An orchestration component that uses the SAP Java Connector to retrieve SAP NetWeaver data via the SAP RFC protocol and load it into your data warehouse or cloud storage.

**[SAP NetWeaver Load](/docs/components/sap-netweaver-load):** A Modular connector that loads data from SAP NetWeaver into your data warehouse.

**[SAP ODP](/docs/components/sap-odp):** A Modular connector that loads data from SAP via Operational Data Provisioning into your data warehouse.

**[SAP SuccessFactors](/docs/components/sap-successfactors):** A Flex connector that loads data from SAP SuccessFactors into your data warehouse.

**[Schedules](/docs/guides/schedules):** Automated triggers that run pipelines at specified times or intervals.

**[Schema Copy](/docs/components/schema-copy):** An orchestration component that copies one or more tables from one schema to another.

**[Scripted paging](/docs/guides/scripted-paging):** A Matillion scripting language used in custom connectors to control how data is fetched and processed, including pagination, rate limiting, and API request and response management.

**[SeatGeek](/docs/components/seatgeek):** A Flex connector that loads data from SeatGeek into your data warehouse.

**[Secrets](/docs/guides/secrets-and-secret-definitions):** Securely stored credentials referenced by name in pipelines.

**[Security](/docs/security/security-overview):** The security measures protecting {maia}, including encryption standards, certificate validation, and secure communication protocols.

**[Send Email](/docs/components/send-email):** An orchestration component that sends emails, with or without attachments, from within a pipeline.

**[SendGrid](/docs/components/sendgrid):** A Flex connector that loads data from SendGrid into your data warehouse.

**[ServiceNow Query](/docs/components/servicenow-query):** A query connector that loads data from ServiceNow into your data warehouse.

**[Services](/docs/guides/services):** The various services available within {maia}.

**[Shared pipelines](/docs/guides/shared-pipelines):** Pipelines that can be reused across multiple projects.

**[SharePoint Query](/docs/components/sharepoint-query):** A query connector that loads data from Microsoft SharePoint into your data warehouse.

**[Shopify](/docs/components/shopify):** A Flex connector that loads data from Shopify into your data warehouse.

**[Shopify Load](/docs/components/shopify-load):** A Modular connector that loads data from Shopify into your data warehouse.

**[Show to Grid](/docs/components/show-to-grid):** An orchestration component (Snowflake only) that saves the results of a Snowflake SHOW command into a grid variable.

**[Single Sign-On (SSO)](/docs/administration/single-sign-on):** Authentication allowing users to access {maia} using organizational identity providers.

**[Slack](/docs/components/slack):** A Flex connector that loads data from Slack into your data warehouse.

**[Smartsheet](/docs/components/smartsheet):** A Flex connector that loads data from Smartsheet into your data warehouse.

**[Snapchat](/docs/components/snapchat):** A Flex connector that loads data from Snapchat into your data warehouse.

**[SNS Message](/docs/components/sns-message):** An orchestration component that sends a message to an Amazon SNS topic to initiate downstream processing in a business workflow.

**[Snowflake Load](/docs/components/snowflake-load):** A Modular connector that loads data from Snowflake into your data warehouse.

**[Snowflake streaming destination](/docs/streaming/snowflake-streaming-destination):** A streaming pipeline destination that writes captured change events directly to a Snowflake data warehouse.

**[Snowflake Vector Upsert](/docs/components/snowflake-vector-upsert):** An AI component (Snowflake only) that converts data from your cloud data warehouse into embeddings and stores them as vectors in Snowflake.

**[Snowpark Container Prompt](/docs/components/snowpark-container-prompt):** An orchestration component (Snowflake only) that hosts and queries large language models running within Snowpark Container Services.

**[Snyk](/docs/components/snyk):** A Flex connector that loads data from Snyk into your data warehouse.

**[Split Field](/docs/components/split-field):** A transformation component that splits a column's contents at a specified delimiter and outputs the resulting parts as new columns.

**[SQL](/docs/components/sql):** A transformation component for executing custom SQL queries.

**[SQL Script](/docs/components/sql-script):** An orchestration component for executing SQL scripts.

**[SQS Message](/docs/components/sqs-message):** An orchestration component that posts a message to an Amazon Simple Queue Service (SQS) queue for processing by other applications.

**[Square](/docs/components/square):** A Flex connector that loads data from Square into your data warehouse.

**[SSH Tunneling](/docs/security/ssh-tunnelling):** Secure connectivity to data sources through SSH tunnels.

**[Start](/docs/components/start):** An orchestration component that marks the starting point of an orchestration pipeline. All orchestration pipelines require at least one Start component.

**[Start Compute](/docs/components/start-compute):** An orchestration component (Databricks only) that ensures the environment's default Databricks cluster is running before the pipeline continues.

**[Stream Input](/docs/components/stream-input):** A transformation component (Snowflake only) that reads selected columns from a Snowflake stream and makes them available to the pipeline.

**[Streaming agent logs](/docs/streaming/streaming-agent-logs):** Logs specific to streaming agent execution.

**[Streaming pipelines](/docs/streaming/streaming-pipelines):** Pipelines that process data continuously in near real-time from source databases.

**[Stripe Query](/docs/components/stripe-query):** A query connector that loads data from Stripe into your data warehouse.

**[SugarCRM Load](/docs/components/sugarcrm-load):** A Modular connector that loads data from SugarCRM into your data warehouse.

**[Super Admin](/docs/administration/account-roles#roles):** The highest account role, which is automatically assigned the Owner role for all projects and environments in the account. Only another Super Admin can modify or remove a user with this role.

**[SurveyMonkey](/docs/components/surveymonkey):** A Modular connector that loads data from SurveyMonkey into your data warehouse.

**[Sybase ASE Load](/docs/components/sybase-ase-load):** A Modular connector that loads data from Sybase ASE into your data warehouse.

**[Sync All Tables](/docs/streaming/sync-all-tables):** Pre-built pipelines that process Avro files from Amazon S3 or Azure Blob Storage streaming destinations and load them into a cloud data platform.

**[System variables](/docs/guides/system-variables):** Built-in variables provided by the system (job ID, timestamps, etc.).

***

## T

**[Table Delete Rows](/docs/components/table-delete-rows):** A transformation component (Amazon Redshift only) that deletes rows from a target table by matching them to key values from an input flow.

**[Table Input](/docs/components/table-input):** A transformation component that reads data from an existing table.

**[Table Iterator](/docs/components/table-iterator):** An orchestration component that loops through tables matching specified criteria.

**[Table Metadata to Grid](/docs/components/table-metadata-to-grid):** An orchestration component that retrieves table structure information into a grid variable.

**[Table Output](/docs/components/table-output):** A transformation component that writes data to a destination table.

**[Table Update](/docs/components/table-update):** A transformation component that updates existing rows in a table.

**[Ticketmaster](/docs/components/ticketmaster):** A Flex connector that loads data from Ticketmaster into your data warehouse.

**[TikTok](/docs/components/tiktok):** A Flex connector that loads data from TikTok into your data warehouse.

**[Toggl](/docs/components/toggl):** A Flex connector that loads data from Toggl into your data warehouse.

**[Transactions](/docs/guides/transactions):** A series of database operations performed as a single unit of work, ensuring data integrity through ACID properties. Managed in {maia} using the Begin, Commit, and Rollback components.

**[Transpose Columns](/docs/components/transpose-columns):** A transformation component that converts columns into rows, reshaping data from a wide format into a longer format.

**[Transpose Rows](/docs/components/transpose-rows):** A transformation component that combines multiple input rows into a single output row, reshaping data from a long format into a wider format.

**[Truncate Table](/docs/components/truncate-table):** An orchestration component that removes all rows from a table while preserving its structure.

**[Twilio](/docs/components/twilio):** A Flex connector that loads data from Twilio into your data warehouse.

***

## U

**[Unite](/docs/components/unite):** A transformation component that combines two or more datasets, optionally including all columns or only shared columns.

**[Unpivot](/docs/components/unpivot):** A transformation component that converts columns into rows.

**[Unstructured.io](/docs/components/unstructured):** A Flex connector that processes and loads data from unstructured documents into your data warehouse.

**[Update Scalar](/docs/components/update-scalar):** An orchestration component that modifies the value of a scalar variable.

**[Usage Dashboard](/docs/administration/usage-dashboard):** A monitoring interface that provides a detailed daily breakdown of credit consumption, showing usage by project and pipeline. Available to users with the **Billing** service enabled.

***

## V

**[Vacuum](/docs/components/vacuum):** An orchestration component (Amazon Redshift only) that reorganizes table data according to its sort key and reclaims space from deleted rows.

**[Variables](/docs/guides/variables):** Named values that can be referenced throughout pipelines using `${variable_name}` syntax.

**[Vector Search](/docs/components/vector-search):** An AI component (Snowflake only) that performs a vector similarity search on two input tables to find content that best answers specific questions using Cortex vector embeddings.

**[Viewer (environment role)](/docs/administration/environment-roles#viewer-role-permissions):** An environment role that allows users to validate and sample pipelines, view executions, lineage, and schema, but cannot run or publish pipelines, and can only view (not manage) schedules.

**[Viewer (project role)](/docs/administration/project-roles#viewer-role-permissions):** A project role with read-only access that allows users to view projects, pipelines, environments, and other resources, but cannot create, modify, or delete anything.

**[Volume to Delta Table](/docs/components/volume-to-delta-table):** An orchestration component (Databricks only) that transfers data from a Databricks volume into a Delta Lake table without replacing or deleting existing data.

***

## W

**[Webhook Post](/docs/components/webhook-post):** An orchestration component that posts a payload to a specified webhook URL, triggering an automated message in an external application.

**[Window Calculation](/docs/components/window-calculation):** A transformation component that performs calculations across rows using SQL window functions.

**[Workday](/docs/components/workday):** An orchestration component that retrieves data such as employee, financial, and business records from Workday via the Workday API and loads it into your data warehouse.

**[Workday Custom Reports](/docs/components/workday-custom-reports):** A Modular connector that loads data from Workday Custom Reports into your data warehouse.

**[Workday Load](/docs/components/workday-load):** A Modular connector that loads data from Workday into your data warehouse.

***

## X

**[X Ads](/docs/components/x-ads):** A connector that loads advertising data from X (formerly Twitter) into your data warehouse.

**[X Ads Load](/docs/components/x-ads-load):** A Modular connector that loads advertising data from X (formerly Twitter) into your data warehouse.

***

## Y

**[Yelp](/docs/components/yelp):** A Flex connector that loads data from Yelp into your data warehouse.

***

## Z

**[Zendesk Talk](/docs/components/zendesk-talk):** A Flex connector that loads data from Zendesk Talk into your data warehouse.

**[Zendesk Ticketing](/docs/components/zendesk-ticketing):** A Flex connector that loads data from Zendesk Ticketing into your data warehouse.

**[Zoom](/docs/components/zoom):** A Flex connector that loads data from Zoom into your data warehouse.

**[Zuora](/docs/components/zuora):** A Flex connector that loads data from Zuora into your data warehouse.