In this exercise, you add reference data to the application you created in the Kinesis
Data Analytics
Getting Started
exercise. The reference data provides the company name for each ticker symbol; for
example:

In the Access to chosen resources section, choose Choose from IAM roles that Kinesis Analytics can assume, and
choose the KinesisAnalytics-ReadS3Object IAM role you created in the previous section.

Choose Discover schema. The console detects two columns in the reference data.

Choose Save and close.

Step 3: Test: Query the In-Application Reference
Table

You can now query the in-application reference table, CompanyName.
You can use the reference information to enrich your application by joining the
ticker price data with the reference table. The result shows the company
name.

Replace your application code with the following. The query joins the
in-application input stream with the in-application reference table. The
application code writes the results to another in-application stream,
DESTINATION_SQL_STREAM.