Deploy and Run Redash on Alibaba Cloud

0.0.201

[{"countrySite":"intl","languages":[{"tce_rule_count":"1","siteText":"Intl","text":"English","lang":"en","defaultLang":true,"tel":"","telText":""},{"tce_rule_count":"1","siteText":"Intl","text":"简体中文","lang":"zh","defaultLang":false,"tel":"","telText":""},{"tce_rule_count":"1","siteText":"Intl","text":"繁體中文","lang":"tc","defaultLang":false,"tel":""},{"tce_rule_count":"1","siteText":"Intl","text":"日本語","lang":"ja","defaultLang":false},{"tce_rule_count":"1","siteText":"Intl","text":"한국어","lang":"ko","defaultLang":false},{"tce_rule_count":"1","siteText":"Intl","text":"Deutsch","lang":"de","defaultLang":false},{"tce_rule_count":"1","siteText":"Intl","text":"Français","lang":"fr","defaultLang":false},{"text":"Bahasa Indonesia","lang":"id","siteText":"Intl","defaultLang":false},{"text":"ไทย","lang":"th","siteText":"Intl","defaultLang":false},{"lang":"ru","siteText":"Intl","text":"Pусский"},{"text":"Español","lang":"es","siteText":"Intl"}],"link":"//www.alibabacloud.com","text":"International","openTarget":"_self","key":"intl"},{"countrySite":"au","languages":[{"tce_rule_count":"1","siteText":"AU","text":"English","lang":"en","defaultLang":"true","tel":"+61 2-8379-8028","pctel":"tel:+61 2-8379-8028","telText":"Call Us (+61 2-8379-8028)"}],"link":"//au.alibabacloud.com","text":"Australia","openTarget":"_self","key":"intl"},{"countrySite":"eu","languages":[{"tce_rule_count":"1","siteText":"EU","text":"English","lang":"en","defaultLang":"true","tel":"+44 20-7048-8226","pctel":"tel:+44 20-7048-8226","telText":"Call Us (+44 20-7048-8226)"}],"link":"//eu.alibabacloud.com","text":"Europe","openTarget":"_self","key":"intl"},{"countrySite":"in","languages":[{"tce_rule_count":"1","siteText":"IN","text":"English","lang":"en","defaultLang":"true","tel":"+91 11-71279699","pctel":"tel:+91 11-71279699","telText":"Call Us (+91 11-71279699)"}],"link":"//in.alibabacloud.com","text":"India","openTarget":"_self","key":"intl"},{"countrySite":"id","languages":[{"tce_rule_count":"1","siteText":"ID","text":"Bahasa","lang":"id","defaultLang":"false","tel":"+62 212-789-9352","pctel":"tel:+62 212-789-9352","telText":"Call Us (+62 212-789-9352)"}],"link":"//id.alibabacloud.com","text":"Indonesia","openTarget":"_self","key":"intl"},{"countrySite":"my","languages":[{"tce_rule_count":"1","siteText":"MY","text":"English","lang":"en","defaultLang":"true","tel":"+60 1546-0000-23","pctel":"tel:+60 1546-0000-23","telText":"Call Us (+60 1546-0000-23)"}],"link":"//my.alibabacloud.com","text":"Malaysia","openTarget":"_self","key":"intl"},{"countrySite":"sg","languages":[{"tce_rule_count":"1","siteText":"SG","text":"English","lang":"en","defaultLang":"true","tel":"+65 3163-8014","pctel":"tel:+65 3163-8014","telText":"Call Us (+65 3163-8014)"}],"link":"//sg.alibabacloud.com","text":"Singapore","openTarget":"_self","key":"intl"},{"countrySite":"us","languages":[{"tce_rule_count":"1","siteText":"US","text":"English","lang":"en","defaultLang":"true","tel":"+1-833-732-2135","pctel":"tel:+1-833-732-2135","telText":"Call Us (+1-833-732-2135)"}],"link":"//us.alibabacloud.com","text":"United States","openTarget":"_self","key":"intl"},{"countrySite":"hk","languages":[{"tce_rule_count":"1","siteText":"HK","text":"繁體中文","lang":"tc","defaultLang":"true","tel":"800-931-108","pctel":"tel:800-931-108","telText":"聯絡我們 (800-931-108)"}],"link":"//hk.alibabacloud.com","text":"中國香港","openTarget":"_self","key":"intl"},{"countrySite":"cn","languages":[{"tce_rule_count":"1","siteText":"中国","text":"简体中文","lang":"zh","defaultLang":"true"}],"link":"//cn.aliyun.com","text":"中国","openTarget":"_self","key":"cn"},{"link":"//ph.alibabacloud.com","openTarget":"_self","key":"intl","countrySite":"ph","text":"Philippines","languages":[{"lang":"en","defaultLang":true,"text":"English","siteText":"Philippines"}]},{"key":"intl","link":"//th.alibabacloud.com","openTarget":"_self","countrySite":"th","languages":[{"text":"ไทย","lang":"th","siteText":"ประเทศไทย","defaultLang":true}],"text":"ประเทศไทย"},{"text":"Việt Nam","key":"intl","link":"//vn.alibabacloud.com","openTarget":"_self","languages":[{"text":"Tiếng Việt","lang":"vi","defaultLang":true,"siteText":"Việt Nam"}],"countrySite":"vn"},{"text":"Türkiye","key":"intl","link":"//tr.alibabacloud.com","countrySite":"tr","languages":[{"siteText":"Türkiye","lang":"tr","text":"Türkçesi","defaultLang":true}]},{"link":"//middle-east.alibabacloud.com","key":"intl","text":"Middle East","languages":[{"siteText":"Middle East","text":"English","lang":"en"}],"countrySite":"me"}]

{"query": {"wh_site":"intl","wh_language":"en","wh_intl_choice":"intl","wh_hostname":"www.alibabacloud.com"},"uuid": 6791778070,"config_asyncComponentUUID": ""}

Overview

Redash is designed to enable anyone, regardless of the level of technical sophistication, to harness the power of data big and small. SQL users leverage Redash to explore, query, visualize, and share data from any data sources. Their work in turn enables anybody in their organization to use the data. Every day, millions of users at thousands of organizations around the world use Redash to develop insights and make data-driven decisions.

This solution deploys Redash with Docker on Ubuntu on Alibaba Cloud ECS to enhance the high availability of Alibaba Cloud database family.

Reference Architecture

Steps

Deploy Resources

Use this main.tf file in Terraform to provision ECS and other resources from this solution.
Note: This solution uses RDS PostgreSQL as example data source for Redash, so ECS and RDS PostgreSQL instances are included in the Terraform script.
Use the correct Image ID of WordPress image on the corresponding region.

Set Up Redash on ECS

1 Run the following command to log on to ECS.
ssh root@ECS_EIP

2 Run the following command to setup Redash.

mkdir /opt/redash
 wget https://raw.githubusercontent.com/getredash/setup/master/setup.sh
 sh setup.sh

3 After the setup is completed, visit the following URL in a web browser to initialize Redash.
http://ECS_EIP

Connect to RDS PostgreSQL

1 On the Redash main page, click "Connect a data source"" to add RDS PostgreSQL as a source database.

2 Input the RDS PostgreSQL instance connection string.

3 Create Query, Dashboard or work with other BI features on Redash.

Connect Redash to other databases on Alibaba Cloud

For ApsaraDB RDS for MySQL, refer to https://redash.io/data-sources/mysql

For ApsaraDB RDS for PostgreSQL, refer to: https://redash.io/data-sources/postgresql

For ApsaraDB RDS for SQL Server, refer to: https://redash.io/data-sources/microsoft-sql-server

For PolarDB for MySQL, refer to: https://redash.io/data-sources/mysql

For PolarDB for PostgreSQL, refer to reference: https://redash.io/data-sources/postgresql

For PolarDB for Oracle, connection URI reference: https://redash.io/data-sources/postgresql

For ApsaraDB for MongoDB, refer to: https://redash.io/data-sources/mongodb

For AnalyticDB for MySQL, refer to: https://redash.io/data-sources/mysql

For AnalyticDB PostgreSQL, refer to: https://redash.io/data-sources/greenplum

For ApsaraDB for ClickHouse, refer to: https://redash.io/data-sources/clickhouse

Quick Start

Quick Start—Terraform Template for Building Resources

Deployment Guide

Related Products

Elastic Compute Service Elastic IP Address ApsaraDB RDS for MySQL ApsaraDB RDS for PostgreSQL ApsaraDB RDS for SQL Server PolarDB AnalyticDB for MySQL AnalyticDB for PostgreSQL ApsaraDB for ClickHouse ApsaraDB for MongoDB

Database Migration Solution

Migrate to fully managed cloud databases.

Learn More >

Reach Alibaba Cloud experts for support