Queries

The Queries section in Flipspace lets you manage all your saved SQL queries and view query history. Saved queries are accessible from the Queries dashboard and can be used in your automations.

​

Creating Queries

There are two ways to create queries in Flipspace:

​

1. Create from Scratch

Create a new query directly in the SQL Editor:

1. Navigate to Queries and click New Query
2. Write your SQL in the editor
3. Run and test your query
4. Save with a descriptive name

​

2. Save from Chat

When using Chat, any SQL it generates can be saved:

1. Ask a question that requires data analysis
2. Chat will generate and confirm the SQL with you
3. Once the query runs successfully, click the Save Query button
4. The query is now accessible in your Queries dashboard and automations

​

Viewing Queries

Navigate to Queries to see all your saved queries. Each query displays:

• Query name: Descriptive title for the query
• Last modified: When the query was last updated
• Last run: When the query was last executed
• Created by: Who authored the query

​

Working with Queries

Click on any saved query to open it in the SQL Editor. From there you can:

• Run the query to get fresh results
• Modify the SQL to adjust your analysis
• Save changes or Save as new to create a copy
• Export results in various formats

​

Using Queries in Automations

Saved queries can be added to your automations as Query blocks. This lets you build repeatable workflows that run your analysis on a schedule or trigger.

Learn more about Automations

Build automated workflows with your saved queries

​

Next Steps