Skip to main content

In-DB and Live Query Tool Comparison

In-Database (In-DB) tools in Designer Desktop and Live Query in Alteryx One both support workflows that process data in a database or cloud data platform. They differ in the tools available, how you view results during workflow design, and how you integrate data with standard workflows.

In-DB provides tools for database processing, data streaming, and macros. Live Query provides corresponding capabilities for many In-DB operations, along with additional tools for data preparation, transformation, custom SQL, and AI processing. Live Query tool availability varies by cloud data platform.

Compare Tools

The following tables compare In-DB tools with their Live Query equivalents by category.

Some Live Query capabilities, such as viewing results at each tool, are built into the workflow experience rather than provided through a separate tool. Review the notes for platform restrictions and differences in behavior.

Category

Tool Name

Purpose

Avaliablity

Notes

In/Out

Input Data (In-DB: Connect In-DB)

Connect to a warehouse table and read its data.

Both

The Live Query connection is selected at the workspace level.

Output Data (In-DB: Write Data In-DB)

Create or update a warehouse table.

Both

Browse In-DB

Inspect data at any point in a workflow.

Both

Live Query provides automatically refreshed results at each tool rather than a separate Browse tool.

Text Input

Manually enter a small table of data.

Live Query only

DateTimeNow

Return the current date and time at runtime.

Live Query only

Directory

List files in a cloud storage location.

Live Query only

Available only for BigQuery. In preview.

Data Movement

Data Stream In

Transfer data from a standard workflow to a database.

Both

In Live Query, you can bring in additional datasets, which are stored in base storage

Data Stream Out

Transfer In-DB results to a standard workflow.

Both

Live Query keeps processing in the warehouse. You can load the output dataset into a standard workflow with Use-In.

Dynamic Input In-DB

Pass fields from a standard data stream to an In-DB stream.

In DB only

No equivalent is available in Live Query

Dynamic Output In-DB

Send In-DB workflow information to a standard workflow for predictive processing.

In DB only

No equivalent is available in Live Query

Macros

Macro Input In-DB

Provide an In-DB input connection for a macro.

In DB only

Available only in Designer Desktop.

Macro Output In-DB

Provide an In-DB output connection for a macro.

In DB only

Available only in Designer Desktop.

Preparation

Filter

Keep rows that meet a condition.

Both

Formula

Create or update columns with expressions.

Both

Select

Include, exclude, rename, and reorder columns

Both

Sample

Limit a data stream to a specified number or percentage of rows.

Both

Multi-Column Formula

Apply an expression to multiple columns.

In Live Query only

Random % Sample

Return a random percentage of rows.

In Live Query only

Create Samples

Split records into 2 or 3 random samples.

In Live Query only

Select Rows

Return specific rows or ranges of rows.

In Live Query only

Sort

Order rows by one or more fields.

In Live Query only

No Sort In-DB tool is available.

Unique

Separate unique rows from duplicate rows.

In Live Query only

No Unique In-DB tool is available.

Data Cleansing

Clean null values, capitalization, punctuation, and whitespace.

In Live Query only

Imputation

Replace missing values.

In Live Query only

Added for Databricks in June 2026, as noted in the release notes.

Multi-Column Binning

Group values in multiple columns into bins or tiles.

In Live Query only

Added for Databricks in June 2026.

Tile

Assign tile values based on ranges in the data.

In Live Query only

Oversample Column

Balance imbalanced data for modeling.

In Live Query only

Added for Databricks in August 2026.

Row ID

Add a sequential row identifier.

In Live Query only

Join

Join

Combine 2 inputs based on common columns.

Both

Union

Stack 2 or more data streams.

Both

Join Multiple

Combine 3 or more inputs.

In Live Query only

Append Columns

Cross join every source row with every target row.

In Live Query only

Find Replace

Find and replace strings or append columns.

In Live Query only

Parse

DateTime

Convert date-time values between formats.

In Live Query only

Available only for Snowflake and BigQuery.

RegEx

Parse, match, or replace text with regular expressions.

In Live Query only

Text To Columns

Split text into columns or rows based on delimiters.

In Live Query only

Available only for Snowflake and BigQuery.

Transform

Summarize

Group data and perform operations such as sum, count, and count distinct.

Both

Transpose

Change the orientation of a table.

Both

Listed in the In-DB overview but absent from the In-DB tool index. Added for Databricks in August 2026.

Cross Tab

Pivot columns onto a horizontal axis and summarize values.

In Live Query only

Available only for Snowflake and BigQuery.

Arrange

Rearrange columns and rows for presentation.

In Live Query only

Count Rows

Count rows in a data stream, including streams with zero rows.

In Live Query only

Rolling Window

Calculate aggregations over a sliding window of sequential rows.

In Live Query only

Running Total

Calculate a cumulative sum for each row.

In Live Query only

Weighted Average

Calculate the weighted average of a column.

In Live Query only

Developer

JSON Parse

Parse JSON text into a table schema.

In Live Query only

SQL executes in the warehouse.

SQL Transform

Write and run custom SQL in a workflow.

In Live Query only

SQL executes in the warehouse.

Dynamic Rename

Rename columns based on patterns, such as prefixes or underscores.

In Live Query only

Available only for Snowflake and Databricks.

AI (Big Query)

Classify

Assign categories to text with AI.

In Live Query only

Available only for BigQuery.

Document Extract

Extract structured data from PDFs with AI.

In Live Query only

Available only for BigQuery.

Score (AI)

Assign a numeric value to text based on a custom instruction.

In Live Query only

Available only for BigQuery. This tool differs from the predictive Score tool.

Speech To Text

Convert audio to text with AI.

In Live Query only

Available only for BigQuery. In preview.

Text Summary

Summarize long-form text with AI.

In Live Query only

Available only for BigQuery.

Translate

Translate text between languages with AI.

In Live Query only

Available only for BigQuery.

Forecast

Forecast a numeric series with TimesFM for quick forecasting or ARIMA_PLUS for advanced forecasting.

In Live Query only

Available only for BigQuery. In preview and requires a feature flag to be enabled.

Predict

Predict a label from training data with

In Live Query only

Available only for BigQuery. In preview and requires a feature flag to be enabled.

Trend

Extract the trend component of a time series.

In Live Query only

Available only for BigQuery. In preview and requires a feature flag to be enabled.

Seasonality

Extract seasonal components of a time series.

In Live Query only

Available only for BigQuery. In preview and requires a feature flag to be enabled.

AI (Databricks)

Data Intelligence

Analyze string data and extract information with AI functions.

In Live Query only

Available only for Databricks.

Grammar And Language

Transform string data with AI functions.

In Live Query only

Available only for Databricks.

Platform and Workflow Differences

Area

In-DB

Live Query

Execution Environment

Build workflows in Designer Desktop with 64-bit drivers. Execution on Alteryx Server requires a system data source name (DSN).

Build workflows in a browser in Alteryx One. The cloud data platform (CDP) executes the workflow operations.

Design-Time Results

Results are available after the entire In-DB workflow runs.

Results recalculate automatically against the full dataset after each change.

Integration with Standard Workflows

Use Data Stream In, Data Stream Out, Dynamic Input In-DB, and Dynamic Output In-DB to connect standard and In-DB processing.

Additional datasets can be brought in and stored in base storage. Output datasets can be loaded into a standard workflow with Use-In. No equivalent is available for Dynamic Input In-DB or Dynamic Output In-DB.

Spatial Tools, Python, and Iterative Macros

These capabilities are available in Designer Desktop outside the In-DB toolset.

These capabilities aren't supported in Live Query.