Follow these steps to get started with federated SQL query against AWS RDS Aurora (MySQL Compatible).
Step 1. Navigate to your AWS RDS Aurora instance in the AWS Management Console.
Note: Ensure that inbound connections are enabled in the associated security group.
Step 2. Look for "Reader" endpoint name and port.
Step 3. Depending on chosen credentials management option (AWS Secrets Manager, or Self managed) retrieve username and password.
Step 4. Edit the spicepod.yaml file in this working directory and replace [remote_table_path] with the path to the remote table to be accelerated, [local_table_name] with the desired name for the locally accelerated table, and the [mysql_host] and [mysql_tcp_port] params with the connection parameters for the AWS RDS instance. The [mysql_user] should be set to the username for the RDS instance. The [mysql_db] should be set to the name of the database in the RDS instance. The MYSQL_PASS environment variable should be set to the password for the RDS instance. Environment variables can be specified on the command line when running the Spice runtime or in a .env file in the same directory as spicepod.yaml.
echo "MYSQL_PASS=<password>" > .envSee the datasets reference for more dataset configuration options and MySQL Data Connector for more options on configuring a MySQL Data Connector.
To securely store your RDS password, see Secret Stores
Step 5. Run the Spice runtime with spice run from this directory.
Follow the quickstart guide to get started with the Spice runtime.
Step 6. Run spice sql in a new terminal to start an interactive SQL query session against the Spice runtime.
For more information on using spice sql, see the CLI reference.
Step 7. Execute the query select * from [local_table_name]; to see the AWS RDS table accelerated locally.