Appsmith
GithubDiscordAppsmith CloudCommunity Forum
Search…
v1.3
Introduction
Setup Appsmith
Tutorials
How To Guides
Debugging Errors
FAQs
Telemetry
Security
Core Concepts
Connecting to Data Sources
Displaying Data (Read)
Capturing Data (Write)
Writing Code
Designing an Application
Building Dynamic UI
Access Control
Datasource Reference
Amazon / Generic S3
ArangoDB
DynamoDB
Elasticsearch
Firestore
Google Sheets
MongoDB
MS SQL
MySQL
PostgreSQL
Redis
Redshift
Snowflake
SMTP
Framework Reference
Cheat Sheet
appsmith
Query
Show Modal
Close Modal
Download
Show Alert
Navigate To
Store Value
Copy To Clipboard
Reset Widget
JavaScript Editor (Beta)
Widget Reference
Audio
Audio Recorder
Button
Button Group
Camera
Chart
Checkbox
Checkbox Group
Container
Datepicker
Divider
Document Viewer
Form
Filepicker
Icon Button
Iframe
Image
Input
List
Maps
Map Chart
Menu Button
Modal
Multi-select
Multi-tree-select
Progress Bar
Radio Group
Rating
Rich Text Editor
Select
Stat Box
Switch
Switch Group
Tabs
Table
Text
Tree-select
Video
Powered By GitBook
Redshift
The following document assumes that you understand the basics of connecting to databases on Appsmith. If not, please go over them before reading further.

Connection Settings

Appsmith needs the following parameters for connecting to a Redshift database:
All required fields are suffixed with an asterisk (*).

Connection

You need to fill in the following parameters:
  • Connection Mode*: You must choose one of the following two modes:
    • Read Only: Choosing this mode gives Appsmith read-only permission on the database. This allows you to only fetch data from the database.
    • Read / Write: Choosing this mode gives Appsmith both read and write permissions on the database. This allows you to execute all CRUD queries.
  • Host Address / Port*: Fill in the database host’s address and port. If you don’t specify a port, Appsmith will try to connect to port 5439.
  • Database Name*: Fill in the name of the database that you want to connect to. This is your database’s name.

Authentication

You need to fill in the following parameters:
  • Username*: Fill username required for authenticating connection requests to your database.
  • Password*: Fill password required for authenticating connection requests for the given username to the database.

SSL

You need to fill in the following parameters:
  • SSL Mode: Choose your SSL model from the dropdown.
  • Key File: Upload your SSL key file from here.
  • Certificate: Upload your SSL certificate here**.**
  • CA Certificate: Upload your CA certificate here.
  • PEM Certificate: Upload your PEM certificate here.
  • PEM Passphrase: Fill in your PEM passphrase here.

Querying Redshift

Redshift databases can be queried using the standard SQL syntax. All Redshift queries return an array of objects where each object is a row returned by the query and each property in the object is a column. Appsmith provides template queries to help with the syntax
Click to expand

Using Queries in applications

Once you have successfully run a Query, you can use it in your application to
Datasource Reference - Previous
Redis
Next - Datasource Reference
Snowflake
Last modified 2mo ago
Copy link
Edit on GitHub
Contents
Connection Settings
Connection
Authentication
SSL
Querying Redshift
Using Queries in applications