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

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

select * from playground.criterion_research where….limit 100

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

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

2. Navigate to the Settings Tab and look for Slug