DataboxDatabox Databox
Connect to your Amazon Redshift Data with Databox

AmazonRedshift
Dashboard and Reporting Software

Connect now

Amazon Redshift is a fully managed, cloud-based data warehousing service provided by Amazon Web Services. It offers fast and petabyte-scale data warehousing capabilities, utilizing columnar storage, parallel query execution, and massively parallel processing. It allows businesses to analyze large datasets and derive insights for making data-driven decisions.

Visualize important business data from your company’s databases

Use Amazon Redshift queries to pull data from your proprietary database and showcase it alongside data from popular services like Mixpanel, Google Analytics and Salesforce.

With Databox, your most important KPIs will be transformed into meaningful insights and delivered to your mobile, Apple Watch, TV display or Slack channels. One of the key benefits of Databox is the ability to combine multiple data sources in one place.

Learn more about the integrations

  • Technical Details
  • Behavior & Usage
  • Help Articles
Category
Sort by

General

  • Description
    Amazon Redshift is a fully managed, cloud-based data warehousing service provided by Amazon Web Services. It offers fast and petabyte-scale data warehousing capabilities, utilizing columnar storage, parallel query execution, and massively parallel processing. It allows businesses to analyze large datasets and derive insights for making data-driven decisions.
  • Categories
    Databases
  • Status
    stable

Specification

  • Authentication Method
    other
  • Time Zone
    User- or source-specific
  • Media Creatives Available
    No
  • Metric Builder Available
    Yes

Metric Builder

  • Run Query
    - The metrics are categorized under the "general" type.
    - Granularities available are hourly, daily, weekly, monthly, quarterly, yearly and all-time.
    - Custom relative periods are available.
  • Missing data on Databoard with the SQL query pushing several values to the same day (1 value)

    Databox recommends to group data by day in the SQL query in Metric Builder. If you have several entries for the same date, you need to configure your SQL query to group all values for the given day. You can use Aggregation Functions such as SUM, MIN, MAX, AVG, Count in the SQL query and GROUP BY date DESC to take all values for a day into consideration and compute them based on used Aggregated Function to display all data from your SQL database.
    You can learn more about Data Types in Databox here.

Track all of your key business metrics from one screen

GET STARTED
Databox app preview