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. |