SQL Rainmaker Assistant

The SQL Rainmaker Assistant in SQL Designer helps you create, optimize, and troubleshoot SQL queries by providing suggestions, feedback, and performance improvements.

How to Use the SQL Rainmaker Assistant

Accessing SQL Designer

1. Navigate to Reports → SQL Designer.

2. Click New to start creating a report.

3. Complete required fields:

4. Label: Descriptive report name.

5. Identifier: Typically the same as the label.

   1. When first tabbing to the Identifier field from the Label field, after a SQL Report is created, the Identifier field is automatically populated with the contents of the Label field.

Evaluating New or Existing Queries

1. Click Ask and do one of the following:

   1. request that the SQL Rainmaker Assistant create a new query based on specific criteria.

   2. request the SQL Rainmaker Assistant evaluate an existing query or request the assistant improve a query based on specific criteria.

2. Review any explanations and suggested SQL provided by the SQL Rainmaker Assistant.

3. Click Replace SQL to apply the query directly into the SQL Window.

4. Click Test to preview results:

   1. If the results are as expected, save your report.

   2. If not:

      1. If you received an error message, paste the error in the Ask section and request feedback.

      2. Continue to use the assistant to refine your query or manually adjust your query until it meets your needs.

      3. Consider using the Optimize option to further improve your query.

(See screenshots below for examples.)

Rainmaker Assistant Buttons and Functions

• Replace SQL: Applies the SQL Rainmaker Assistant’s suggested query.

• Copy to Clipboard: Copies the query for external use or manual edits.

• Ask: Submit questions or request clarification and alternative solutions.

• Optimize: Refine queries.

• Test: Preview query results with sample data.

• Run: Execute the final query to generate your report.

Testing and Validating SQL Queries

• When testing always use a LIMIT in the WHERE Clause. For example, best practice is to limit returned rows to 10 while testing.

• Click Test to preview and verify the data.

• Remove the limit, produce the report and validate all data.

• Validate results thoroughly to ensure accuracy.

Best Practices

• Start with simple queries and test after each change.

• Review all SQL Rainmaker Assistant recommendations before applying.

• Familiarize yourself with PostgreSQL.

• Consider reporting misidentified fields to Support.

• Validate all suggestions and changes to ensure accuracy.