Connect your AWS RDS Database to Google Sheets
Quickly link your AWS RDS database to Google Sheets for hassle-free data integration and visualization.
Superjoin has revolutionized the way organizations connect to RDS databases, offering secure and efficient connection solutions. This guide will walk you through setting up a connection with Superjoin, ensuring you can leverage the full capabilities of Superjoin with your MySQL database. 🚀
Step-by-step walkthrough: How to connect RDS to Google Sheets
Launch Superjoin
Once Superjoin is installed, navigate to the Extensions menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.
Pick MySQL
Select MySQL (for RDS as well) from the list of available data sources.
Connect your MySQL Database
Enter your connection credentials.
| Field | Description | Example |
|---|---|---|
| Host | This will be the endpoint of your RDS instance. | your-db-instance.123456789012.us-east-1.rds.amazonaws.com |
| Port | Use the specific port for your MySQL database. | Default is 3306 |
| Database | Specify the name of the database you want to query. | initialdatabase |
| User | Enter the username for connecting to your MySQL database. | admin or user123 |
| Password | Provide the password corresponding to the specified user. | password123 |
For using AWS RDS (Relational Database Service), you will typically gather the same types of credentials. However, the process may include some AWS-specific steps.
If you’re connecting to a PostgreSQL RDS instance which is running PostgreSQL version 15 or higher, you must enable the enforce SSL toggle beflow the password field.
Login to AWS
Log in to the AWS Management Console.
Navigate to RDS
Navigate to the RDS dashboard and select your database instance.
Identify endpoint (host) & port
Under the ‘Connectivity & Security’ section, find the ‘Endpoint’ and ‘Port’ information.
Connect to your RDS Database
Click “Authorize” to establish the connection. Superjoin will open the Data Preview upon successful creation, allowing you to start querying your database.