Skip to main content

LiveQuery

With Live Query, you can use cloud data processing while building your workflow. Live Query provides access to your cloud data warehouse, enabling you to work seamlessly without moving or replicating data into your Alteryx One environment. Use Live Query to work directly with your entire dataset in real-time.

Use Live Query to connect directly to your cloud data warehouses on Google BigQuery, Databricks, or Snowflake.

To start building a workflow in Live Query, select Live Query from the Alteryx One home page or app.

How Live Query Executes a Workflow

When you create a Live Query workflow, you select a cloud data platform connection and a catalog or schema. The selected connection becomes the workflow's execution CDP. Live Query runs the workflow in that CDP and uses the selected catalog or schema for temporary objects.

If you add a dataset from another CDP, Live Query reads the dataset from the source CDP and uploads it to the execution CDP. Live Query materializes the imported data as a temporary object in the selected schema and runs the workflow in the execution CDP.

For supported execution-CDP configurations and information about using data from multiple CDPs, go to Live Query Configuration and Compatibility.

Live Query and Designer Desktop

Have you worked with Designer Desktop? See the differences between Live Query and Designer Desktop.

Limites

You might notice small differences in precision when you use numbers with more than 15 significant digits. In some cases, the workflow output can appear slightly rounded or formatted differently. If precision beyond 15 digits is important for your analysis, review your results to confirm that values appear as intended before using the workflow in production.