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 Data, expand Explore, then choose SQL Explorer.

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 saved transformation
• Export query results for analysis
• Save and organize frequently used queries

Interface

The SQL Editor provides:

Running queries

1. Write your SQL in the editor pane.
2. Click Run or press Cmd/Ctrl + Enter.
3. View results in the panel below.
4. 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 saved transformations
• 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:

1. Write your query.
2. Click Save in the toolbar.
3. Give it a descriptive name.
4. Reopen saved queries from the editor’s saved-query view.

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 or reusable logic, create a saved transformation instead of relying on an ad-hoc query