Skip to contents

Run Redshift SQL Query Builder Shiny App

Source: R/run_redshift_query_builder.R
run_redshift_query_builder.Rd

Launches an interactive Shiny application for building Amazon Redshift SQL queries without writing code. The app provides an intuitive interface with form-based inputs for constructing complex SQL queries including table selection, column specifications, WHERE conditions, date filters, GROUP BY, ORDER BY, and more.

Usage

run_redshift_query_builder(background = TRUE, ...)

Arguments

background

Logical. If TRUE (default), runs the app in a background R process (requires the callr package), allowing continued use of the console. If FALSE, blocks the console until the app is stopped.

...

Additional arguments passed to shiny::runApp() when background = FALSE.

Value

If background = FALSE, invisibly returns the result of shiny::runApp(). If background = TRUE (default), returns a process handle from callr::r_bg() which can be used to monitor or terminate the background process. The process is returned visibly so you can easily assign it to a variable.

Details

The Redshift SQL Query Builder includes:

  • Table Selection: Specify schema, table name, and optional alias

  • Column Selection: Choose all columns, specific columns, or aggregate functions (COUNT, SUM, AVG, MIN, MAX, COUNT DISTINCT)

  • WHERE Conditions: Add up to 3 conditions with AND/OR logic, supporting operators like =, !=, >, <, LIKE, IN, BETWEEN, IS NULL, etc.

  • Date Filters: Filter by date ranges, last N days, current month/year, or specific dates using Redshift functions

  • Sorting & Grouping: GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET

  • Validation: Real-time error checking and helpful messages

  • Copy to Clipboard: One-click copy of generated SQL

Note

This app requires the shiny and bslib packages. Running in background mode (default) requires the callr package.

Examples

if (interactive()) {
  # Run in background (default) - IMPORTANT: assign to variable
  app <- run_redshift_query_builder()
  
  # Continue using console for other work...
  
  # Stop the app when done
  app$kill()
  
  # Run in foreground (blocks console)
  # run_redshift_query_builder(background = FALSE)
}