Guides

SQL workflow guides for teams

Practical playbooks for collaboration and delivery: variables, version history, comments, scheduling, on-prem workers, and exporting large results to CSV or streaming XLSX.

Start free No credit card required. See the product

Looking for comparisons or research topics? Browse resources.

Most read guides

Start here if you’re building a collaborative SQL workflow with reliable exports and traceable run history.

Collaboration

Query comments

Keep decisions attached to the SQL: threaded comments, context on changes, and handoffs that don’t lose the “why”.

Open guide

Versioning

Query history

Track every execution, restore past SQL, and keep exports traceable with run history linked to downloads.

Open guide

Parameters

Query variables

Define parameter types, defaults, and prompts so scheduled exports and Run Now use the right inputs every time.

Open guide

Exports

Exporting large results (CSV / XLSX)

Use CSV for fast sharing, stream XLSX with LargeXlsx for big datasets, and deliver files through notifications.

Open guide

On-prem execution

On-prem scheduler workers

Install the agent, set DP_SCHEDULER_WORKER_ID and DP_SCHEDULER_WORKER_KEY, attach your DP_CONN_* secrets, and monitor workers as they pick up schedules behind the firewall.

Need a starting point?

If you’re migrating a team workflow, begin with history → variables → exports, then add on-prem workers if needed.