SQL Editor

The SQL Editor lets you query your data warehouse directly from the Vendo interface. Write ad-hoc queries, explore tables, and save useful queries for later.

Open SQL Explorer under Data → Explore in the Data menu.

What the SQL Editor is for

Run ad-hoc queries against your BigQuery warehouse
Explore table schemas and preview data
Test transformation logic before creating a Data Studio transformation
Export query results for analysis
Save and organize frequently used queries

Interface

The SQL Editor provides:

Area	Purpose
Query editor	Write and edit SQL with syntax highlighting
Schema browser	Browse available tables and columns
Results panel	View query output with pagination
Saved queries	Access previously saved queries

Running queries

Write your SQL in the editor pane.
Click Run or press Cmd/Ctrl + Enter.
View results in the panel below.
Optionally save the query for reuse.

Queries run against your account’s BigQuery dataset. Results are limited to prevent large downloads — use LIMIT clauses for exploratory work.

Table access

The schema browser shows all tables available to your account:

Source tables — raw data from connected integrations
Transformation outputs — tables created by Data Studio
System tables — Vendo-managed tables (events, users, etc.)

Click a table name to see its columns and data types.

Saving queries

Save useful queries to reuse later:

Write your query.
Click Save in the toolbar.
Give it a descriptive name.
Access saved queries from the sidebar.

Saved queries are visible to all workspace members.

Tips

Use SELECT * FROM table LIMIT 10 to preview table structure
Reference the Data Catalog for column documentation
For complex transformations, consider creating a Data Studio transformation instead of running ad-hoc queries