The connector models AWS services as relational views, or read-only tables. The service view definitions are dynamically generated. When you connect, the connector retrieves the metadata from AWS Data Management and reflects any changes in the view schemas.
Stored Procedures are function-like interfaces to AWS Data Management. They can be used to perform common extra tasks that fall outside of what would make sense for a table.