Amazon Redshift

Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse service that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools. It's engineered for high-performance analytical processing, making it an ideal central repository for business intelligence, reporting, and complex data analysis.

Why Connect Amazon Redshift to Whatsdash?

Integrating your Amazon Redshift data with Whatsdash leverages the power of your cloud data warehouse, turning raw, aggregated data into visualized metrics for faster, more informed decision-making.

• High-Performance Visualization: Utilize Redshift's Massively Parallel Processing (MPP) architecture to execute complex analytical queries quickly, ensuring your dashboards are powered by up-to-the-second data even with petabyte-scale datasets.

• Centralized Analytical Hub: Pull critical, aggregated data from your Redshift warehouse and visualize it alongside operational metrics from your marketing, sales, and analytics platforms in a unified dashboard environment.

• Custom SQL Query Reporting: Whatsdash's direct integration allows you to use your own SQL queries to define specific analytical datasets, enabling advanced joins, window functions, and data transformations directly within Redshift before visualization.

• Secure Cloud Connection: Establish a secure and direct connection to your Amazon Redshift cluster, respecting your established AWS security protocols for data access.

📋 Steps to Integrate your Amazon Redshift account to Whatsdash

✔️ Navigate to the 'Integrations' page using the Navigation bar.

✔️ Select Amazon Redshift from the Available Integrations.

✔️ Click the + button to open the connection configuration window.

✔️ Enter your connection details in the form:

• Step 1: Enter AWS Security and Location Parameters 🔐

  In this first step, you provide the necessary AWS credentials and specify the location of your Redshift cluster and how the database credentials will be retrieved.

  You must fill in the following five mandatory fields marked with an asterisk (*):

  *AWS access Key : Enter the AWS Access Key ID for a user with permissions to read data from the Redshift cluster and access the region

  *AWS secret Key : Enter the corresponding AWS Secret Access Key.

  *Region name : Enter the AWS Region where your Redshift cluster is hosted (e.g., us-east-1, eu-west-2).

  *Secret Type : Select the service used to store your Redshift login credentials. By default,the Secret Type is set to Secret Manager.

  For "Secret Manager" in Secret Type ,you need to specifiy the Secret Name field, Otherwise, you need to specify the details ofthe Amazon Redshift credentials manually.

  *Secret name : Enter the name of the secret stored in AWS Secrets Manager that holds the Redshift database credentials (username and password).

  Once all five fields are filled, click the green Next button to proceed.

• Step 2: Enter Redshift Connection Details ⚙️

  Cluster Endpoint/Host: You will be prompted to enter the host URL or IP address of your Redshift cluster.

  Note: The cluster endpoint should be publicly accessible endpoint.

  Port: Enter the port number for the cluster (the default is typically 5439).

  Database Name: Enter the name of the specific Redshift database you wish to query (e.g., analytics_db).

Click Next to proceed.

• Step 3: Select Schema and Tables 📁 After successful connection, you specify the data source structure.

  Select Schema: Choose the specific Redshift schema (like a folder) that contains your reporting data (e.g., public, reporting).

  Select Tables/Views: You will be presented with the available tables and views within that schema. Select the specific tables or materialized views that hold the core data you want to use for dashboards (e.g., fct_sales, dim_customer).

  Click Next to proceed to the final configuration step.

• Step 4: Define Dimensions and Metrics 📊

  In this step, you define how the columns from your selected tables will be interpreted by Whatsdash.

  Specify Fields: You are prompted to define the schema by designating columns as Dimensions or Metrics.

  Dimensions: Select columns used for categorization, grouping, or time segmentation (e.g., sale_date, region_name, product_id).

  Metrics: Select columns containing numerical values for aggregation and calculation (e.g., total_revenue, units_sold, cost_of_goods).

  Finalize Integration: After defining the schema, the connection is saved.

✔️ Once successfully authenticated, your Amazon Redshift Integration will appear in the Connected Integrations list.

🔗 Explore More Integrations

Whatsdash supports a wide range of marketing, analytics, and eCommerce integrations to give you a holistic view of your business performance.

👉 Visit the Integrations Page to explore all available connections