Get Started with Live Query
Live Query empowers analysts and data scientists with a self-service solution for data prep, blending, and analytics in the cloud.
Important
Live Query for Google BigQuery requires a workspace that uses Google Cloud Storage as the base storage. In Google Cloud Storage based workspaces, Live Query does not support Snowflake and Databricks. In workspaces that use a base storage other than Google Cloud Storage, Live Query supports Snowflake and Databricks.
Supported Base Storage and Primary CDPs
Base storage | BigQuery primary | Snowflake primary | Databricks primary |
|---|---|---|---|
GCS | Yes | No | No |
ADS, AWS, or ADLS | No | Yes | Yes |
Note
Additional Requirements
Google BigQuery: The dataset used for Live Query temporary objects and the GCS base-storage bucket must use compatible locations.
Databricks: A Workspace Admin must configure the Databricks workspace in the Alteryx One Platform workspace admin settings. Live Queryrequires a Databricks SQL Warehouse and Unity Catalog. Databricks on GCP isn't supported.
For the complete compatibility matrix, go to Live Query Configuration and Compatibility.
Application Setup
Complete these steps to get started using the application.
Assign Roles
Each user of your workspace who needs access to the application must be assigned a Live Query Creator or Live Query Consumer role by a Workspace Admin.
Note
Each application has a specific set of roles. When a workspace user is assigned an application role, the licensed seat count for the application is incremented, where applicable.
For more information on user roles, go to User Roles.
For more information on capabilities, go to Capability Reference.
For more information on assigning roles, go to Roles Page.
For the legacy pricing and packaging, go to Privileges and Roles Reference and Permissions Matrix.
Consumer Role Restrictions
The Live Query Consumer role gives users access to view and run workflows in a minimalist viewer mode. Note these restrictions for the Live Query Consumer role...
User
You only have access to Live Query.
You can view and run workflows.
If a workflow contains a cloud connection, you must enter your own credentials to access the data from that connection.
Many UI elements are hidden, including the Tool Palette and Interactive Results Grid.
You can't edit workflows.
You can't edit the input or output data in a workflow.
You can't share or delete workflows.
Other users can share a workflow with you with Editor permissions, but you can't edit the workflow yourself.
Admin
Only assign the Live Query Consumer role to users. Don't assign the Default role to the same user.
Ask Alteryx in Live Query
Use Ask Alteryx to get started with Live Query. Ask Alteryx can build workflows, help you understand tools, and troubleshoot workflow issues. Ask Alteryx uses Generative AI to analyze your current workflow and provide tailored recommendations.
Ask Alteryx appears as a window in Live Query where you can enter prompts in natural language. For more information, go to Ask Alteryx in Live Query.
Note
Ask Alteryx in Live Query is available only for Live Query for Google BigQuery workflows.
Users Who Have Not Used Designer
For users unfamiliar with Designer, we recommend our Getting Started pages to get comfortable using and customizing the Live Query:
Users Who Have Used Designer
Users familiar with Designer will find a cloud-scalable, easy to manage version of the product they know and love. Live Query provides a very similar intuitive interface available with many of Designer's code-free and code-friendly tools. Find more information on building workflows and using tools in Live Query on the Workflows page.