Skip to main content
Skip table of contents

Alli Data - Download Query Results to Workflows

Overview

Use this Workflow to run a SQL query directly against Alli Data—whether it’s a custom report, Google Sheet datasource, or a certified table—and automatically save the results as a downloadable file in Workflows. From there, you can transfer the file to other services or run additional Task for processing.

Variables

Name

Reference

Type

Required

Default

Options

Description

SQL Query

ALLI_DATA_QUERY

Alphanumeric

None

-

A SELECT statement that returns data. Ensure your datasource includes client.datasourcename

Workflows File Name

ALLI_DATA_DESTINATION_FILE_NAME

Alphanumeric

None

File name that will be created with the results of the query

Executing a query against a datasource or report:

Avoid using SELECT * without filters unless you know the data source is small, or your using a filtered report. Datasources & Certified datasources may return large amounts of data—filtering and limiting your queries will make your Workflow more reliable.

Not comfortable writing SQL? No worries—use Data Explorer with Ask Alli to build a report using natural language prompts. Once created, publish your report, then query it with:

SELECT * FROM {client_slug}.{report_name}

Take the below example. If I want execute a query against criterion_research, then my SQL query will look something like

CODE
select * from playground.criterion_research where….limit 100
image-20250513-151236.png

You must always provide the client slug for the datasource. See Alli Data - Download Query Results to Workflows | How-to-Find-Your-Client’s-Slug for instructions on how to find this.

Executing a query against a certified datasource:

To access certified datasources, your query will look something like this

CODE
select *
from {alli_client_slug}_core.{table_name}

You can check out Data Explorer which Certified Datasources your client has enabled.

How to Find Your Client’s Slug

  1. In the left side nav, at the bottom click the Settings Icon & Manage Client

image-20250513-151409.png
  1. Navigate to the Settings Tab and look for Slug

image-20250513-151030.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.