Connecting to our PostgreSQL database in Metabase

Connecting to our database in Metabase is very similar to how we connected to it on the command line, except it is more user-friendly. To get started, open the admin panel in Metabase:

1. From the top menu bar, click Databases.
2. You should have one database already, the sample dataset that comes with Metabase.
3. Click Add Database.
4. PostgreSQL should be the default option from the dropdown. If not, choose it.
5. For Name, enter Pies. This is just a user-friendly name that Metabase will use.
6. Under Host, enter the endpoint from RDS.
7. For Port, use 5432, which is the standard port for PostgreSQL traffic.
8. The database name will be pies.
9. The database username will be postgres.
10. Enter the password you made when you created the database.
11. Keep the Enabled slider on.
12. Click Save.

At this point, Metabase will store the connection parameters for our database. It will automatically start scanning...