ACCOUNT INFO
SCRIPTS
DATABASE
  • Reports
  • Database
  • Storage
    • Sign Out

  • Create Folder
  • Upload File
  • Download File
  • Delete
  • New
  • Upload File
  • Download File
  • Cut
  • Copy
  • Paste
  • Rename
  • Delete
  • Create Folder
  • Refresh
  • Access Backups
  • Upload File
  • Download File
  • Generate Load SQL
  • Cut
  • Copy
  • Paste
  • Rename
  • Delete
  • Create Folder
  • Refresh
  • Scripts
    • Grant Access
    • Revoke Access
    • Change Password
    • Rename User
    • Change Superuser Access
    • Change DB Create Access
  • User Review
    • Last 10 Queries
    • Table Privileges
    • Schema Privileges
  • Advanced
    • Assign to Email
    • Drop...
  • Data Dictionary
  • New Column...
  • Delete/Drop
  • CREATE Script
  • Data Review
    • Show Distinct Top 100
    • Show Counts with Group By this column
  • Data Dictionary
  • Scripts
    • Select Statement
    • Insert Statement
    • DDL
    • Update Statement
    • Delete Statement
    • Drop Statement
    • Rename Statement
  • Data Review
    • Show Top 100
    • Find Duplicate Records
    • Show Top 100 Duplicates
  • Advanced
    • Vacuum
    • Change Sort Keys
    • Re-order the Data
    • Drop...
Report Wizard
This Report Wizard guides you through the process of creating and editing reports directly from your Redshift database. The basic steps are (1) Enter General report attributes (2) Select a SQL file as the Source for the report (3) Assign User Input (search & replace text) in the SQL file (4) Select the report Output Type and other parameters (5) Add Report to a Scheduler to run at pre-determined times and (6) Set the Delivery method like downloading & emailing.
  • General
  • Sources
  • User Input
  • Output Type
  • Scheduler
  • Delivery
Report Name:
Report Description:
Report Category:
« Prev
1/6
Next »

Add SQL File

Data Providers

Click or Drop file here
*optional
« Prev
2/6
Next »
« Prev
3/6
Next »
« Prev
4/6
Next »

Schedule Based on Date/Time

« Prev
5/6
Next »
« Prev
6/6
Save
Explain Query
  • Query
  • Explain
  • Explain Verbose
Save Query Output To File
Add Join Key

No mapping (join key) exists for the following tables. Add join keys by selecting fields from the dropdown lists below. To join on multiple columns, add the matching fields from each table one at a time.

New Table FieldExisting Table Field
Sort Parameters

Assign field sort order using the table below. Click in the Asc/Desc column to change between ascending, descending, or to remove from the sort order. Drag and Drop the rows to change the order - with priority going to the higher rows.

Function Arguments

Function

Scripts Backups
Report Wizard Edits
Insert Function

Select a category:

Select a function:

Filter Parameters

Add Filter parameters one at a time below. These compose the where clause for the query being built. Use the Match Case checkbox to assign case sensitivity. The Show Field checkbox determines if the Field will be selected in the query or simply used in the Filter.

Field NameOperatorValueMatch CaseShow Field
Contact Us

For immediate assistance - contact us @ 203-276-0672
User Settings

Change Password


The Analytic Platform is a fully managed Data Analytics platform built off the cloud computing resources and database architecture on Amazon Web Services. Webbs Hill will host, manage and maintain your data on Amazon Redshift; a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze all your data using your existing business intelligence tools. Fill in the form to request a Demo. We will get back to you shortly.
Login
Assign User to Email

  • Filter
  • Sort
  • Function
  • Delete
  • Export
    • CSV
    • TXT
    • JSON
  • Export
    • CSV
    • TXT
    • JSON
  • Copy
    • Copy Selected
    • Copy with Headers