Creating a Studio notebook with Kinesis Data Streams

Create a Table

1. Sign in to the Amazon Web Services Management Console and open the Amazon Glue console at https://console.amazonaws.cn/glue/.

2. If you don't already have a Amazon Glue database, choose Databases from the left navigation bar. Choose Add Database. In the Add database window, enter default for Database name. Choose Create.

3. In the left navigation bar, choose Tables. In the Tables page, choose Add tables, Add table manually.

4. In the Set up your table's properties page, enter stock for the Table name. Make sure you select the database you created previously. Choose Next.

5. In the Add a data store page, choose Kinesis. For the Stream name, enter ExampleInputStream. For Kinesis source URL, choose enter https://kinesis.us-east-1.amazonaws.com. If you copy and paste the Kinesis source URL, be sure to delete any leading or trailing spaces. Choose Next.

6. In the Classification page, choose JSON. Choose Next.

7. In the Define a Schema page, choose Add Column to add a column. Add columns with the following properties:

   Column name	Data type
   ticker	string
   price	double

   Choose Next.

8. On the next page, verify your settings, and choose Finish.

9. Choose your newly created table from the list of tables.

10. Choose Edit table and add a property with the key kinesisanalytics.proctime and the value proctime.

11. Choose Apply.

1. Open the Kinesis Data Analytics console at https://console.aws.amazon.com/kinesisanalytics/home?region=us-east-1#/applications/dashboard.

2. In the Kinesis Data Analytics applications page, choose the Studio tab. Choose Create Studio notebook.

   Note

   You can also create a Studio notebook from the Amazon MSK or Kinesis Data Streams consoles by selecting your input Amazon MSK cluster or Kinesis data stream, and choosing Process data in real time.

3. In the Create Studio notebook page, provide the following information:

   • Enter MyNotebook for the name of the notebook.

   • Choose default for Amazon Glue database.

   Choose Create Studio notebook.

4. In the MyNotebook page, choose Run. Wait for the Status to show Running. Charges apply when the notebook is running.

1. Verify your account ID. You need this value to create your application.

2. Create the role arn:aws:iam::AccountID:role/ZeppelinRole and add the following permissions to the auto-created role by console.

   "kinesis:GetShardIterator",

   "kinesis:GetRecords",

   "kinesis:ListShards"

3. Create a file called create.json with the following contents. Replace the placeholder values with your information.

   {
       "ApplicationName": "MyNotebook",
       "RuntimeEnvironment": "ZEPPELIN-FLINK-2_0",
       "ApplicationMode": "INTERACTIVE",
       "ServiceExecutionRole": "arn:aws:iam::AccountID:role/ZeppelinRole",
       "ApplicationConfiguration": {
           "ApplicationSnapshotConfiguration": {
               "SnapshotsEnabled": false
           },
           "ZeppelinApplicationConfiguration": {
               "CatalogConfiguration": {
                   "GlueDataCatalogConfiguration": {
                       "DatabaseARN": "arn:aws:glue:us-east-1:AccountID:database/default"
                   }
               }
           }
       }
   }
   

4. Run the following command to create your application:

   aws kinesisanalyticsv2 create-application --cli-input-json file://create.json 
   

5. When the command completes, you see output that shows the details for your new Studio notebook. The following is an example of the output.

   {
       "ApplicationDetail": {
           "ApplicationARN": "arn:aws:kinesisanalytics:us-east-1:012345678901:application/MyNotebook",
           "ApplicationName": "MyNotebook",
           "RuntimeEnvironment": "ZEPPELIN-FLINK-2_0",
           "ApplicationMode": "INTERACTIVE",
           "ServiceExecutionRole": "arn:aws:iam::012345678901:role/ZeppelinRole",
   ...
   

6. Run the following command to start your application. Replace the sample value with your account ID.

   aws kinesisanalyticsv2 start-application --application-arn arn:aws:kinesisanalytics:us-east-1:012345678901:application/MyNotebook\
   

1. Open the Kinesis Data Generator.

2. Choose Create a Cognito User with CloudFormation.

3. The Amazon CloudFormation console opens with the Kinesis Data Generator template. Choose Next.

4. In the Specify stack details page, enter a username and password for your Cognito user. Choose Next.

5. In the Configure stack options page, choose Next.

6. In the Review Kinesis-Data-Generator-Cognito-User page, choose the I acknowledge that Amazon CloudFormation might create IAM resources. checkbox. Choose Create Stack.

7. Wait for the Amazon CloudFormation stack to finish being created. After the stack is complete, open the Kinesis-Data-Generator-Cognito-User stack in the Amazon CloudFormation console, and choose the Outputs tab. Open the URL listed for the KinesisDataGeneratorUrl output value.

8. In the Amazon Kinesis Data Generator page, log in with the credentials you created in step 4.

9. On the next page, provide the following values:

   Region	us-east-1
   Stream/delivery stream	ExampleInputStream
   Records per second	1

   For Record Template, paste the following code:

   {
       "ticker": "{{random.arrayElement(
           ["AMZN","MSFT","GOOG"]
       )}}",
       "price": {{random.number(
           {
               "min":10,
               "max":150
           }
       )}}
   }
   

10. Choose Send data.

11. The generator will send data to your Kinesis data stream.

    Leave the generator running while you complete the next section.

1. Open the Kinesis Data Analytics console at https://console.aws.amazon.com/kinesisanalytics/home?region=us-east-1#/applications/dashboard.

2. On the Kinesis Data Analytics applications page, choose the Studio notebook tab. Choose MyNotebook.

3. In the MyNotebook page, choose Open in Apache Zeppelin.

   The Apache Zeppelin interface opens in a new tab.

4. In the Welcome to Zeppelin! page, choose Zeppelin Note.

5. In the Zeppelin Note page, enter the following query into a new note:

   %flink.ssql(type=update)
   select * from stock

   Choose the run icon.

   After a short time, the note displays data from the Kinesis data stream.