Interacting with datasets in MySQL

Data has been loaded into a MySQL relational database for your consumption. This is particularly useful for especially large datasets that can be hard to load into memory on your local machine or are slow to download from S3.

Accessing from the mysql CLI

Log in:

$ mysql -h health-db-internet.c6clocfz5zxy.us-east-1.rds.amazonaws.com -P3306 -u data_hacker -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 147207
Server version: 5.6.23-log MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]>

SHOW available databases:

MySQL [(none)]> show databases;
+------------------------------------------------+
| Database                                       |
+------------------------------------------------+
| information_schema                             |
| CMS_open_payments_2013                         |
| CMS_open_payments_2014                         |
| Chronic_conditions_PUFs_2008                   |
| Chronic_conditions_PUFs_2010                   |
| Elhadad                                        |
| Medicare_provider_utilization_and_payment_data |
| NPDB_malpractice_claims                        |
| SPARCS                                         |
| innodb                                         |
| mysql                                          |
| performance_schema                             |
+------------------------------------------------+
12 rows in set (0.11 sec)