{"id":92637,"date":"2020-08-13T15:25:21","date_gmt":"2020-08-13T06:25:21","guid":{"rendered":"https:\/\/support.questetra.com\/developer-blog\/choices-aws-lambda-rds-console\/"},"modified":"2026-04-14T15:20:59","modified_gmt":"2026-04-14T06:20:59","slug":"choices-aws-lambda-rds-console","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/","title":{"rendered":"Using Amazon RDS as an External Master (AWS Console)"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"58\" data-attachment-id=\"113114\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/first-questetra-bpm-suite-step1\/attachment\/basic-banner-new-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"basic-banner-new-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en-1024x58.png?resize=1024%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-113114\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=768%2C44&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">You may want to use master data managed by an external system in Questetra BPM Suite. In this article, we are going to use data that has been managed by Amazon RDS (Relational Database Service) as the external options master for Search Select Box in Questetra BPM Suite.<\/p>\n\n\n<div class=\"su-note\"  style=\"border-color:#dbdbdb;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f5f5f5;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\nIn this article, you will use the AWS console to create AWS resources. If you want to use <a href=\"https:\/\/www.terraform.io\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Terraform (open in new tab)\">Terraform<\/a>, please refer to <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/\">Using Amazon RDS as External Master (Terraform)<\/a>.<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">What is a Search Select Box?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A Search Select Box is one of the Data Item types. When you enter a search string and press the search button, a list of options that contains the search string out from the master data will be shown and you can select one from the list to enter the data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"124\" data-attachment-id=\"92602\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image1_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?fit=1080%2C124&amp;ssl=1\" data-orig-size=\"1080,124\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image1_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?fit=1024%2C118&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=1080%2C124&#038;ssl=1\" alt=\"\" class=\"wp-image-92602\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?w=1080&amp;ssl=1 1080w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=600%2C69&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=1024%2C118&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=768%2C88&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Benefits of using RDS as an External Master<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When you use RDS as an external master, you can take advantage of its capability of handling a large amount of data, and changes in the data can be reflected in real-time. For more information on how to manage master data and the advantages and disadvantages of each method please refer to the article <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/\">Several Ways to Manage Master Data with Questetra<\/a>. (the method introduced in this article corresponds to \u201cPattern 1\u201d)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">AWS Services to Use<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The method introduced in this article uses the following services from AWS (Amazon Web Service). The purpose is shown in parentheses.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>RDS (database)<\/li><li>RDS Proxy (database connection proxy)<\/li><li>Secrets Manager (management of authentication information)<\/li><li>Lambda (application creation)<\/li><li>API GatewayAPI Gateway (Create API)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">How it works<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The general mechanism is as shown in the figure below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"427\" data-attachment-id=\"92614\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image2_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?fit=1155%2C482&amp;ssl=1\" data-orig-size=\"1155,482\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image2_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?fit=1024%2C427&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?resize=1024%2C427&#038;ssl=1\" alt=\"\" class=\"wp-image-92614\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?resize=1024%2C427&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?resize=600%2C250&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?resize=768%2C320&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?w=1155&amp;ssl=1 1155w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When the Search Select Box sends a GET request to the API Gateway, the event is sent to Lambda. Based on the event, Lambda queries RDS for data and returns the result.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Although not shown in the figure, the connection to RDS goes through RDS Proxy and the authentication information is managed by Secrets Manager.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can connect to RDS directly from Lambda without going through the RDS Proxy, but this can lead to a large number of connections being initiated and consuming resources, and by going through the RDS Proxy you can manage your connections more efficiently.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Outline of Procedure<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Using the API Gateway and Lambda, create an API to retrieve the RDS data. Set the endpoint of the API you created as the options data URL of the search select box and use the RDS as an external master.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"622\" height=\"630\" data-attachment-id=\"92605\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image3_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?fit=1290%2C1306&amp;ssl=1\" data-orig-size=\"1290,1306\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image3_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?fit=622%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=622%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92605\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=622%2C630&amp;ssl=1 622w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=311%2C315&amp;ssl=1 311w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=768%2C778&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?w=1290&amp;ssl=1 1290w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Outline of Procedure<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Create a database with RDS<\/li><li>Configure settings to connect to the database via RDS Proxy<\/li><li>Create a Lambda function (this article uses Node.js)<\/li><li>Attach an RDS Proxy to your Lambda function<\/li><li>Set up the API Gateway as a trigger for your Lambda function<\/li><li>Create an App that uses a Search Select Box in Questetra BPM Suite<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Required Environment<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You need the following to proceed with the steps in this article:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MySQL \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\">MySQL client<\/a> (used to create the database)<\/li><li><a href=\"https:\/\/nodejs.org\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Node.js \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\">Node.js<\/a> \/ <a href=\"https:\/\/www.npmjs.com\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"npm \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\">npm<\/a> command (used to create Lambda function code)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Procedure<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">1. Create a Database with RDS<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">1-1. Database creation<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Create the database in RDS. Please select the engine type and edition which RDS Proxy supports (<a rel=\"noreferrer noopener\" aria-label=\"AWS \u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\" href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/rds-proxy.html#rds-proxy.limitations\" target=\"_blank\">RDS Proxy restrictions<\/a>). In this case, Amazon Aurora compatible with MySQL 5.6 is selected.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"511\" height=\"630\" data-attachment-id=\"92642\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/choices-aws-lambda-rds-console-image1_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Console-image1_en.png?fit=1028%2C1268&amp;ssl=1\" data-orig-size=\"1028,1268\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-Console-image1_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Console-image1_en.png?fit=511%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Console-image1_en.png?resize=511%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92642\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Console-image1_en.png?resize=511%2C630&amp;ssl=1 511w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Console-image1_en.png?resize=255%2C315&amp;ssl=1 255w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Console-image1_en.png?resize=768%2C947&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Console-image1_en.png?w=1028&amp;ssl=1 1028w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Enter the DB cluster identifier and Master username. In this case, DB cluster identifier is \u201csample-database-1\u201d and Master username is \u201cadmin\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"795\" height=\"630\" data-attachment-id=\"92645\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image2_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image2_en.png?fit=1032%2C818&amp;ssl=1\" data-orig-size=\"1032,818\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image2_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image2_en.png?fit=795%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image2_en.png?resize=795%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92645\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image2_en.png?resize=795%2C630&amp;ssl=1 795w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image2_en.png?resize=397%2C315&amp;ssl=1 397w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image2_en.png?resize=768%2C609&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image2_en.png?w=1032&amp;ssl=1 1032w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you click [Create database] and wait for a while, you will see &#8220;Successfully created database {DB cluster identifier} &#8221; at the top.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"55\" data-attachment-id=\"92648\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image3_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image3_en.png?fit=2180%2C118&amp;ssl=1\" data-orig-size=\"2180,118\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image3_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image3_en.png?fit=1024%2C55&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image3_en.png?resize=1024%2C55&#038;ssl=1\" alt=\"\" class=\"wp-image-92648\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image3_en.png?resize=1024%2C55&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image3_en.png?resize=600%2C32&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image3_en.png?resize=768%2C42&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image3_en.png?resize=1536%2C83&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image3_en.png?resize=2048%2C111&amp;ssl=1 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click [View credential details] and make a note of the Master Username, Master Password, and Endpoint.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"407\" height=\"315\" data-attachment-id=\"92651\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image4_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image4_en.png?fit=804%2C622&amp;ssl=1\" data-orig-size=\"804,622\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image4_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image4_en.png?fit=804%2C622&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image4_en.png?resize=407%2C315&#038;ssl=1\" alt=\"\" class=\"wp-image-92651\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image4_en.png?resize=407%2C315&amp;ssl=1 407w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image4_en.png?resize=768%2C594&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image4_en.png?w=804&amp;ssl=1 804w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">1-2. Connect to the database and create a table<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Connect to the database with the following mysql command (type the master password after the command):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -h {ENDPOINT} -P {PORT NUMBER} -u {MASTER USERNAME} -p<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The port number is displayed by clicking the database identifier in the database list. By default, it is set to 3306.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the connection is successful the following will be displayed.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Welcome to the MySQL monitor.&nbsp; Commands end with ; or \\g.\nYour MySQL connection id is 7\nServer version: 5.6.10 MySQL Community Server (GPL)\n&nbsp;\nCopyright (c) 2000, 2020, Oracle and\/or its affiliates. All rights reserved.\n&nbsp;\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n&nbsp;\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n&nbsp;\nmysql&gt;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If the connection fails check the database instance settings (Public accessibility permittance, VPC security groups settings). For specific instructions, see <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-troubleshooting\/\">Using Amazon RDS as an External Master (Troubleshooting)<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you can connect to the database, first check the character code settings to prevent garbled characters (You can skip this step if the data does not include Double-byte characters). Type mysql&gt; followed by the following mysql command to execute it.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>show variables like 'char%';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">It is good if the value of these variables, <em>character_set_client, character_set_connection, character_set_database, character_set_results,<\/em> and <em>character_set_server<\/em> is <em>utf8<\/em> as shown below.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>+--------------------------+--------------------------------------------------+\n| Variable_name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | Value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |\n+--------------------------+--------------------------------------------------+\n| character_set_client &nbsp; &nbsp; | utf8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |\n| character_set_connection | utf8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |\n| character_set_database &nbsp; | utf8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |\n| character_set_filesystem | binary &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |\n| character_set_results&nbsp; &nbsp; | utf8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |\n| character_set_server &nbsp; &nbsp; | utf8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |\n| character_set_system &nbsp; &nbsp; | utf8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |\n| character_sets_dir &nbsp; &nbsp; &nbsp; | \/rdsdbbin\/oscar-5.6.10a.200340.0\/share\/charsets\/ |\n+--------------------------+--------------------------------------------------+<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If there are parameters that are not utf8, create a parameter group in RDS and apply it to your database. For the specific procedure, see <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-troubleshooting\/\">Using Amazon RDS as an External Master (Troubleshooting)<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After setting the character code, create the database schema and table. In this example, we will create a database schema in the name &#8220;sample_db&#8221; and create a table in the name &#8220;nations&#8221; in it.<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">Creating the database schema<\/h6>\n\n\n\n<p class=\"wp-block-paragraph\">Create a database schema named &#8220;sample_db&#8221; by executing the following SQL statement after mysql&gt;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>create database sample_db;<\/code><\/pre>\n\n\n\n<h6 class=\"wp-block-heading\">Switching database schema<\/h6>\n\n\n\n<p class=\"wp-block-paragraph\">Execute the following SQL statement to switch to the &#8220;sample_db&#8221; created earlier.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>use sample_db;<\/code><\/pre>\n\n\n\n<h6 class=\"wp-block-heading\">Creating table<\/h6>\n\n\n\n<p class=\"wp-block-paragraph\">Create a table with two columns, value and display. value is the choice ID and display is the display label.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE `nations` (\n&nbsp;&nbsp;`value` VARCHAR(10) NOT NULL PRIMARY KEY,\n&nbsp;&nbsp;`display` VARCHAR(100) NOT NULL\n) DEFAULT CHARSET=utf8;<\/code><\/pre>\n\n\n\n<h6 class=\"wp-block-heading\">Inserting data<\/h6>\n\n\n\n<p class=\"wp-block-paragraph\">Here, insert 4 rows of data.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO nations (value, display)\n&nbsp;&nbsp;VALUES\n&nbsp;&nbsp;&nbsp;&nbsp;(\"JP\", \"JAPAN\"),\n&nbsp;&nbsp;&nbsp;&nbsp;(\"US\", \"USA\"),\n&nbsp;&nbsp;&nbsp;&nbsp;(\"UK\", \"UNITED KINGDOM\"),\n&nbsp;&nbsp;&nbsp;&nbsp;(\"AU\", \"AUSTRALIA\");<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2. Configure the Connection to the Database via RDS Proxy<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">2-1. Save database credentials as a secret<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Open Secrets Manager and click Save a new secret.\n<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"147\" data-attachment-id=\"92654\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image5_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image5_en.png?fit=2006%2C288&amp;ssl=1\" data-orig-size=\"2006,288\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image5_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image5_en.png?fit=1024%2C147&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image5_en.png?resize=1024%2C147&#038;ssl=1\" alt=\"\" class=\"wp-image-92654\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image5_en.png?resize=1024%2C147&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image5_en.png?resize=600%2C86&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image5_en.png?resize=768%2C110&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image5_en.png?resize=1536%2C221&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image5_en.png?w=2006&amp;ssl=1 2006w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">With &#8216;Credentials for RDS database&#8217; selected, enter the database master username and master password to the Username and Password respectively. Select your DB instance and click Next.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"701\" height=\"630\" data-attachment-id=\"92657\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image6_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image6_en.png?fit=1406%2C1264&amp;ssl=1\" data-orig-size=\"1406,1264\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image6_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image6_en.png?fit=701%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image6_en.png?resize=701%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92657\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image6_en.png?resize=701%2C630&amp;ssl=1 701w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image6_en.png?resize=350%2C315&amp;ssl=1 350w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image6_en.png?resize=768%2C690&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image6_en.png?w=1406&amp;ssl=1 1406w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Enter the secret name. Here name it &#8220;sample-rds-secret&#8221;. Click Next.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"785\" height=\"630\" data-attachment-id=\"92660\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image7_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image7_en.png?fit=1410%2C1132&amp;ssl=1\" data-orig-size=\"1410,1132\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image7_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image7_en.png?fit=785%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image7_en.png?resize=785%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92660\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image7_en.png?resize=785%2C630&amp;ssl=1 785w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image7_en.png?resize=392%2C315&amp;ssl=1 392w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image7_en.png?resize=768%2C617&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image7_en.png?w=1410&amp;ssl=1 1410w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Leave the other defaults and click Next to save.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once the secret is created, open the details and make a note of the Secret ARN.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"330\" data-attachment-id=\"92663\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image8_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image8_en.png?fit=1794%2C578&amp;ssl=1\" data-orig-size=\"1794,578\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image8_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image8_en.png?fit=1024%2C330&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image8_en.png?resize=1024%2C330&#038;ssl=1\" alt=\"\" class=\"wp-image-92663\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image8_en.png?resize=1024%2C330&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image8_en.png?resize=600%2C193&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image8_en.png?resize=768%2C247&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image8_en.png?resize=1536%2C495&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image8_en.png?w=1794&amp;ssl=1 1794w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">2-2\uff0eCreate IAM role so RDS Proxy to read secrets<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">First, create a policy for the IAM role. Open IAM, select Policies in Access management in the left menu, and click Create policy.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"258\" data-attachment-id=\"92666\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image9_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image9_en.png?fit=832%2C358&amp;ssl=1\" data-orig-size=\"832,358\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image9_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image9_en.png?fit=832%2C358&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image9_en.png?resize=600%2C258&#038;ssl=1\" alt=\"\" class=\"wp-image-92666\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image9_en.png?resize=600%2C258&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image9_en.png?resize=768%2C330&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image9_en.png?w=832&amp;ssl=1 832w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select the JSON tab, describe the policy as shown below (enter the secret ARN you just created in Resource) and proceed to Review policy.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n&nbsp;&nbsp;&nbsp;\"Version\": \"2012-10-17\",\n&nbsp;&nbsp;&nbsp;\"Statement\": &#091;\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"Sid\": \"VisualEditor0\",\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"Effect\": \"Allow\",\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"Action\": &#091;\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"secretsmanager:GetResourcePolicy\",\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"secretsmanager:GetSecretValue\",\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"secretsmanager:DescribeSecret\",\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"secretsmanager:ListSecretVersionIds\"\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;],\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"Resource\": &#091;\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"{SECRET ARN}\"\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;]\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;},\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"Sid\": \"VisualEditor1\",\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"Effect\": \"Allow\",\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"Action\": &#091;\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"secretsmanager:GetRandomPassword\",\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"secretsmanager:ListSecrets\"\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;],\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\"Resource\": \"*\"\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\n&nbsp;&nbsp;&nbsp;]\n}<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"630\" data-attachment-id=\"92669\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image10_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image10_en.png?fit=1622%2C1260&amp;ssl=1\" data-orig-size=\"1622,1260\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image10_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image10_en.png?fit=811%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image10_en.png?resize=811%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92669\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image10_en.png?resize=811%2C630&amp;ssl=1 811w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image10_en.png?resize=406%2C315&amp;ssl=1 406w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image10_en.png?resize=768%2C597&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image10_en.png?resize=1536%2C1193&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image10_en.png?w=1622&amp;ssl=1 1622w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Enter a name for your policy and click Create Policy. Here we will call it &#8220;AllowAccessToSampleRdsSecret&#8221;.\n<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"447\" data-attachment-id=\"92672\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image11_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image11_en.png?fit=1608%2C702&amp;ssl=1\" data-orig-size=\"1608,702\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image11_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image11_en.png?fit=1024%2C447&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image11_en.png?resize=1024%2C447&#038;ssl=1\" alt=\"\" class=\"wp-image-92672\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image11_en.png?resize=1024%2C447&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image11_en.png?resize=600%2C262&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image11_en.png?resize=768%2C335&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image11_en.png?resize=1536%2C671&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image11_en.png?w=1608&amp;ssl=1 1608w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After creating the policy, create an IAM role. Select Roles in Access Management on the left menu of the IAM page and click Create role.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"489\" data-attachment-id=\"92675\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image12_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image12_en.png?fit=1452%2C694&amp;ssl=1\" data-orig-size=\"1452,694\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image12_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image12_en.png?fit=1024%2C489&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image12_en.png?resize=1024%2C489&#038;ssl=1\" alt=\"\" class=\"wp-image-92675\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image12_en.png?resize=1024%2C489&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image12_en.png?resize=600%2C287&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image12_en.png?resize=768%2C367&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image12_en.png?w=1452&amp;ssl=1 1452w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select AWS service, and select RDS and RDS \u2013 Add Role to Database in Select your use case, then proceed to Next Permission.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"229\" data-attachment-id=\"92678\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image13_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image13_en.png?fit=1290%2C288&amp;ssl=1\" data-orig-size=\"1290,288\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image13_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image13_en.png?fit=1024%2C229&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image13_en.png?resize=1024%2C229&#038;ssl=1\" alt=\"\" class=\"wp-image-92678\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image13_en.png?resize=1024%2C229&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image13_en.png?resize=600%2C134&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image13_en.png?resize=768%2C171&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image13_en.png?w=1290&amp;ssl=1 1290w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"902\" height=\"630\" data-attachment-id=\"92681\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image14_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image14_en.png?fit=1306%2C912&amp;ssl=1\" data-orig-size=\"1306,912\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image14_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image14_en.png?fit=902%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image14_en.png?resize=902%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92681\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image14_en.png?resize=902%2C630&amp;ssl=1 902w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image14_en.png?resize=451%2C315&amp;ssl=1 451w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image14_en.png?resize=768%2C536&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image14_en.png?w=1306&amp;ssl=1 1306w\" sizes=\"auto, (max-width: 902px) 100vw, 902px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select the policy you just created and go to Next: Tags.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"334\" data-attachment-id=\"92684\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image15_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image15_en.png?fit=1298%2C424&amp;ssl=1\" data-orig-size=\"1298,424\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image15_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image15_en.png?fit=1024%2C334&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image15_en.png?resize=1024%2C334&#038;ssl=1\" alt=\"\" class=\"wp-image-92684\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image15_en.png?resize=1024%2C334&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image15_en.png?resize=600%2C196&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image15_en.png?resize=768%2C251&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image15_en.png?w=1298&amp;ssl=1 1298w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Go to Next: Review without adding any tags. Enter the Role name and click Create Role. In this case, it is &#8220;rds-getting-secret-role&#8221;.\n<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"574\" data-attachment-id=\"92687\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image16_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image16_en.png?fit=1284%2C720&amp;ssl=1\" data-orig-size=\"1284,720\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image16_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image16_en.png?fit=1024%2C574&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image16_en.png?resize=1024%2C574&#038;ssl=1\" alt=\"\" class=\"wp-image-92687\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image16_en.png?resize=1024%2C574&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image16_en.png?resize=562%2C315&amp;ssl=1 562w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image16_en.png?resize=768%2C431&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image16_en.png?w=1284&amp;ssl=1 1284w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Once the role is created, open the details and make a note of the Role ARN.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"321\" data-attachment-id=\"92695\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image17_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image17_en.png?fit=1264%2C396&amp;ssl=1\" data-orig-size=\"1264,396\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image17_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image17_en.png?fit=1024%2C321&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image17_en.png?resize=1024%2C321&#038;ssl=1\" alt=\"\" class=\"wp-image-92695\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image17_en.png?resize=1024%2C321&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image17_en.png?resize=600%2C188&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image17_en.png?resize=768%2C241&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image17_en.png?w=1264&amp;ssl=1 1264w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">3. Creating  Lambda Function<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">3-1. Creating  Lambda Function<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Open Lambda, select Function in the left menu, and click Create Function.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"88\" data-attachment-id=\"92699\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image18_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image18_en.png?fit=2430%2C208&amp;ssl=1\" data-orig-size=\"2430,208\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image18_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image18_en.png?fit=1024%2C88&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image18_en.png?resize=1024%2C88&#038;ssl=1\" alt=\"\" class=\"wp-image-92699\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image18_en.png?resize=1024%2C88&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image18_en.png?resize=600%2C51&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image18_en.png?resize=768%2C66&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image18_en.png?resize=1536%2C131&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image18_en.png?resize=2048%2C175&amp;ssl=1 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select &#8220;Author from scratch&#8221; and enter the function name. In this example, name it &#8220;myRdsFunction&#8221;. Select Node.js 12.x for the runtime and click Create Function.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"448\" data-attachment-id=\"92702\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image19_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image19_en.png?fit=2360%2C1032&amp;ssl=1\" data-orig-size=\"2360,1032\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image19_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image19_en.png?fit=1024%2C448&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image19_en.png?resize=1024%2C448&#038;ssl=1\" alt=\"\" class=\"wp-image-92702\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image19_en.png?resize=1024%2C448&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image19_en.png?resize=600%2C262&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image19_en.png?resize=768%2C336&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image19_en.png?resize=1536%2C672&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image19_en.png?resize=2048%2C896&amp;ssl=1 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">3-2. Creating function code locally<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">We will create the function code locally. This article uses the following two packages.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.npmjs.com\/package\/promise-mysql\" target=\"_blank\" rel=\"noreferrer noopener\">promise-mysql<\/a><\/li><li><a href=\"https:\/\/www.npmjs.com\/package\/xmlbuilder\" target=\"_blank\" rel=\"noreferrer noopener\">xlmbiulder<\/a><\/li><\/ul>\n\n\n\n<pFirst, create a local directory and execute the following command in the directory to create <em>package.json<\/em>.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>npm init -y<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Install the two packages (promise-mysql and xmlbuilder) respectively with the following command.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>npm install {PACKAGE NAME} -save<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Create the file &#8220;index.js&#8221; and write the code.<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">Code example (index.js)<\/h6>\n\n\n\n<p class=\"wp-block-paragraph\">Below is an example of the code.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>const mysql = require('promise-mysql');\nconst builder = require('xmlbuilder');\nconst db_config = {\n  host   : process.env&#091;'endpoint'],\n  user   : process.env&#091;'user'],\n  password : process.env&#091;'password'],\n  database : process.env&#091;'db']\n};\nconst table = process.env&#091;'table'];\nconst pool = mysql.createPool(db_config);\n \nexports.handler = async (event) =&gt; {\n  let response = {};\n  let connection;\n  try {\n    connection = await (await pool).getConnection();\n    console.log(\"Connected\");\n  } catch (e) {\n    console.log(e);\n    response = formatError(e);\n    return response;\n  }\n  console.log(\"Starting query ...\");\n  try {\n    const {sql, inserts} = buildSql(event);\n    const results = await connection.query(sql, inserts);\n    const xml = buildXml(results);\n    response = formatResponse(xml);\n  } catch (e) {\n    console.log(e);\n    response = formatError(e);\n  } finally {\n    await connection.release();\n    console.log(\"Connection released\");\n    return response;\n  }\n \n};\n \nfunction buildSql (event) {\n  let sql = \"SELECT * FROM ??\";\n  let inserts = &#091;table];\n  let conditions = new Array();\n  if (event.queryStringParameters &amp;&amp; event.queryStringParameters.query) {\n    const query = event.queryStringParameters.query;\n    conditions.push('display LIKE ?');\n    inserts.push(`%${query}%`);\n  }\n  if (event.queryStringParameters &amp;&amp; event.queryStringParameters.parent) {\n    const parentItemId = event.queryStringParameters.parent;\n    conditions.push('value LIKE ?');\n    inserts.push(`${parentItemId}%`);\n  }\n  const condNum = conditions.length;\n  if (condNum &gt;= 1) {\n    sql += ` WHERE ${conditions&#091;0]}`;\n    if (condNum == 2) {\n      sql += ` AND ${conditions&#091;1]}`;\n    }\n  } else if (event.multiValueQueryStringParameters &amp;&amp; event.multiValueQueryStringParameters.values) {\n    const values = event.multiValueQueryStringParameters.values;\n    sql += \" WHERE value IN (?\";\n    for (let i = 1; i &lt; values.length; i++) {\n      sql += \", ?\";\n    }\n    sql += \")\";\n    inserts = inserts.concat(values);\n  }\n  sql += ';';\n  return {sql, inserts};\n}\n \nfunction buildXml (results) {\n  const resultsNum = results.length;\n  let root = builder.create('items');\n  for (let i = 0; i &lt; resultsNum; i++) {\n    let item = root.ele('item');\n    item.att('value', results&#091;i].value);\n    item.att('display', results&#091;i].display);\n  }\n  const xml = root.end({ pretty: true});\n  return xml;\n}\n \nfunction formatResponse (body) {\n  const response = {\n    \"statusCode\": 200,\n    \"headers\": {\n      \"Content-Type\": \"text\/plain; charset=utf-8\"\n    },\n    \"isBase64Encoded\": false,\n    \"body\": body,\n  };\n  return response;\n}\n \nfunction formatError (error) {\n  const response = {\n    \"statusCode\": error.statusCode,\n    \"headers\": {\n      \"Content-Type\": \"text\/plain\",\n      \"x-amzn-ErrorType\": error.code\n    },\n    \"isBase64Encoded\": false,\n    \"body\": error.code + \": \" + error.message\n  };\n  return response;\n}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This code gets the connection information to the database from the environment variable of the Lambda function (lines 4-7). I will explain how to set environment variables later.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When a GET request is sent to the API Gateway, Lambda receives it as an event. It creates a SQL SELECT statement based on the request parameters (line 25), queries the database (line 26), formats the result into <a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024332132\">R3190: Format of Choice XML<\/a> (line 27), and returns it as a response.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The three request parameters are as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>query: Search string. Returns the rows that contain the search string in display (display label).<\/li><li>parent: Choice ID of the parent choice. Returns rows with a prefixed value (choice ID). This parameter does not need to be considered if you don\u2019t set any parent choices.<\/li><li>values: Parameters used when searching by directly specifying a value (choice ID).<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">3-2. Uploading as a .zip file<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Create a .zip file by running the following command in your local directory (in environments such as Windows where the zip command is not available, right-click the directory and zip it into a .zip file):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>zip -r myRdsFunction.zip .<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Open the Lambda function and go to &#8220;Upload a .zip file&#8221; from &#8220;Action&#8221; at the upper right of the function code.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"63\" data-attachment-id=\"92705\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image20_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image20_en.png?fit=2150%2C132&amp;ssl=1\" data-orig-size=\"2150,132\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image20_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image20_en.png?fit=1024%2C63&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image20_en.png?resize=1024%2C63&#038;ssl=1\" alt=\"\" class=\"wp-image-92705\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image20_en.png?resize=1024%2C63&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image20_en.png?resize=600%2C37&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image20_en.png?resize=768%2C47&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image20_en.png?resize=1536%2C94&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image20_en.png?resize=2048%2C126&amp;ssl=1 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select the .zip file you created and click Save to upload.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"179\" data-attachment-id=\"92709\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image21_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image21_en.png?fit=1102%2C328&amp;ssl=1\" data-orig-size=\"1102,328\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image21_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image21_en.png?fit=1024%2C305&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image21_en.png?resize=600%2C179&#038;ssl=1\" alt=\"\" class=\"wp-image-92709\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image21_en.png?resize=600%2C179&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image21_en.png?resize=1024%2C305&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image21_en.png?resize=768%2C229&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image21_en.png?w=1102&amp;ssl=1 1102w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">4. Attaching the RDS Proxy to your Lambda Function<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Attach the RDS Proxy to the Lambda function and configure the connection relationship.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">4-1. Attach the RDS Proxy<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Open your Lambda function and click Add database proxy in the Database Proxy block at the bottom.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"76\" data-attachment-id=\"92712\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image22_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image22_en.png?fit=2138%2C158&amp;ssl=1\" data-orig-size=\"2138,158\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image22_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image22_en.png?fit=1024%2C76&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image22_en.png?resize=1024%2C76&#038;ssl=1\" alt=\"\" class=\"wp-image-92712\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image22_en.png?resize=1024%2C76&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image22_en.png?resize=600%2C44&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image22_en.png?resize=768%2C57&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image22_en.png?resize=1536%2C114&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image22_en.png?resize=2048%2C151&amp;ssl=1 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Create a new database proxy. The proxy identifier is &#8220;sample-rds-proxy&#8221; in this example. Select the database you created in &#8220;RDS DB Instance&#8221;, enter the ARN of the secret you created in &#8220;Secret&#8221;, and select the IAM role you also created. For &#8220;Authentication&#8221;, select Password and click Add.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"641\" height=\"630\" data-attachment-id=\"92715\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image23_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image23_en.png?fit=1086%2C1068&amp;ssl=1\" data-orig-size=\"1086,1068\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image23_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image23_en.png?fit=641%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image23_en.png?resize=641%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92715\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image23_en.png?resize=641%2C630&amp;ssl=1 641w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image23_en.png?resize=320%2C315&amp;ssl=1 320w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image23_en.png?resize=768%2C755&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image23_en.png?w=1086&amp;ssl=1 1086w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">View the proxy details and make a note of the proxy endpoint.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"350\" data-attachment-id=\"92718\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image24_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image24_en.png?fit=1592%2C544&amp;ssl=1\" data-orig-size=\"1592,544\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image24_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image24_en.png?fit=1024%2C350&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image24_en.png?resize=1024%2C350&#038;ssl=1\" alt=\"\" class=\"wp-image-92718\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image24_en.png?resize=1024%2C350&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image24_en.png?resize=600%2C205&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image24_en.png?resize=768%2C262&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image24_en.png?resize=1536%2C525&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image24_en.png?w=1592&amp;ssl=1 1592w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">4-2. Configure environment variables for Lambda function<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">In the Lambda function code in this article we read the necessary information from the environment variables and connect it to the database. We will set the database information in the environment variables of the Lambda function.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Open your Lambda function and click Manage Environment Variables in the Environment Variables block.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"92\" data-attachment-id=\"92721\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image25_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image25_en.png?fit=2144%2C192&amp;ssl=1\" data-orig-size=\"2144,192\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image25_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image25_en.png?fit=1024%2C92&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image25_en.png?resize=1024%2C92&#038;ssl=1\" alt=\"\" class=\"wp-image-92721\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image25_en.png?resize=1024%2C92&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image25_en.png?resize=600%2C54&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image25_en.png?resize=768%2C69&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image25_en.png?resize=1536%2C138&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image25_en.png?resize=2048%2C183&amp;ssl=1 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Set the key and value as shown in the table below and click Save.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Key<\/td><td>value<\/td><\/tr><tr><td>db<\/td><td>Database schema name<\/td><\/tr><tr><td>endpoint<\/td><td>RDS Proxy endpoint<\/td><\/tr><tr><td>user<\/td><td>Database master username<\/td><\/tr><tr><td>password<\/td><td>Database master password<\/td><\/tr><tr><td>table<\/td><td>table name<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"744\" height=\"630\" data-attachment-id=\"92724\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image26_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image26_en.png?fit=1086%2C920&amp;ssl=1\" data-orig-size=\"1086,920\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image26_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image26_en.png?fit=744%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image26_en.png?resize=744%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92724\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image26_en.png?resize=744%2C630&amp;ssl=1 744w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image26_en.png?resize=372%2C315&amp;ssl=1 372w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image26_en.png?resize=768%2C651&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image26_en.png?w=1086&amp;ssl=1 1086w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">4-3. Set up a VPC for your Lambda function<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">In order for your Lambda function to use the RDS Proxy you must place the Lambda function in the same VPC (virtual network) as your RDS or RDS Proxy<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First, give the Lambda function&#8217;s execution role a policy to access your VPC. Open your Lambda function and click Edit in the upper right corner of the Basic settings block.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"226\" data-attachment-id=\"92727\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image27_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image27_en.png?fit=1064%2C400&amp;ssl=1\" data-orig-size=\"1064,400\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image27_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image27_en.png?fit=1024%2C385&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image27_en.png?resize=600%2C226&#038;ssl=1\" alt=\"\" class=\"wp-image-92727\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image27_en.png?resize=600%2C226&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image27_en.png?resize=1024%2C385&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image27_en.png?resize=768%2C289&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image27_en.png?w=1064&amp;ssl=1 1064w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click &#8220;View the&#8230;roles&#8230;&#8221; at the bottom.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"611\" height=\"630\" data-attachment-id=\"92732\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image28_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image28_en.png?fit=1086%2C1120&amp;ssl=1\" data-orig-size=\"1086,1120\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image28_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image28_en.png?fit=611%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image28_en.png?resize=611%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92732\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image28_en.png?resize=611%2C630&amp;ssl=1 611w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image28_en.png?resize=305%2C315&amp;ssl=1 305w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image28_en.png?resize=768%2C792&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image28_en.png?w=1086&amp;ssl=1 1086w\" sizes=\"auto, (max-width: 611px) 100vw, 611px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click Attach policies.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"284\" data-attachment-id=\"92736\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image29_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image29_en.png?fit=1155%2C547&amp;ssl=1\" data-orig-size=\"1155,547\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image29_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image29_en.png?fit=1024%2C485&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image29_en.png?resize=600%2C284&#038;ssl=1\" alt=\"\" class=\"wp-image-92736\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image29_en.png?resize=600%2C284&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image29_en.png?resize=1024%2C485&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image29_en.png?resize=768%2C364&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image29_en.png?w=1155&amp;ssl=1 1155w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Search for and select AWSLambdaVPCAccessExecutionRole and click Attach Policies.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"262\" data-attachment-id=\"92740\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image30_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image30_en.png?fit=686%2C300&amp;ssl=1\" data-orig-size=\"686,300\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image30_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image30_en.png?fit=686%2C300&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image30_en.png?resize=600%2C262&#038;ssl=1\" alt=\"\" class=\"wp-image-92740\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image30_en.png?resize=600%2C262&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image30_en.png?w=686&amp;ssl=1 686w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Return to the Lambda function screen again and click Edit in the VPC block.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"48\" data-attachment-id=\"92743\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image31_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image31_en.png?fit=2142%2C100&amp;ssl=1\" data-orig-size=\"2142,100\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image31_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image31_en.png?fit=1024%2C48&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image31_en.png?resize=1024%2C48&#038;ssl=1\" alt=\"\" class=\"wp-image-92743\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image31_en.png?resize=1024%2C48&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image31_en.png?resize=600%2C28&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image31_en.png?resize=768%2C36&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image31_en.png?resize=1536%2C72&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image31_en.png?resize=2048%2C96&amp;ssl=1 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select Custom VPC, set the same VPC, subnet, and security group as your RDS, and click Save (You can find the VPC settings in RDS on the Connections &amp; Security tab of the database instance).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"935\" height=\"630\" data-attachment-id=\"92746\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image32_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image32_en.png?fit=1104%2C744&amp;ssl=1\" data-orig-size=\"1104,744\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image32_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image32_en.png?fit=935%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image32_en.png?resize=935%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92746\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image32_en.png?resize=935%2C630&amp;ssl=1 935w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image32_en.png?resize=467%2C315&amp;ssl=1 467w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image32_en.png?resize=768%2C518&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image32_en.png?w=1104&amp;ssl=1 1104w\" sizes=\"auto, (max-width: 935px) 100vw, 935px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">5. Configure the API Gateway as a trigger for your Lambda function<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">5-1. API Gateway Settings<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Open your Lambda function and click Add Trigger in the Designer block of the Configuration tab.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"246\" data-attachment-id=\"92749\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image33_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image33_en.png?fit=2139%2C514&amp;ssl=1\" data-orig-size=\"2139,514\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image33_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image33_en.png?fit=1024%2C246&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image33_en.png?resize=1024%2C246&#038;ssl=1\" alt=\"\" class=\"wp-image-92749\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image33_en.png?resize=1024%2C246&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image33_en.png?resize=600%2C144&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image33_en.png?resize=768%2C185&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image33_en.png?resize=1536%2C369&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image33_en.png?resize=2048%2C492&amp;ssl=1 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select API Gateway and Create an API. Select REST API as the API type. Set the security to &#8220;Open&#8221; and click Add.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"645\" height=\"630\" data-attachment-id=\"92752\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image34_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image34_en.png?fit=1086%2C1060&amp;ssl=1\" data-orig-size=\"1086,1060\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image34_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image34_en.png?fit=645%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image34_en.png?resize=645%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92752\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image34_en.png?resize=645%2C630&amp;ssl=1 645w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image34_en.png?resize=323%2C315&amp;ssl=1 323w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image34_en.png?resize=768%2C750&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image34_en.png?w=1086&amp;ssl=1 1086w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Make a note of the endpoint once you have added the API Gateway. The endpoint is visible when you select API Gateway in the Lambda function&#8217;s Designer block.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"845\" height=\"630\" data-attachment-id=\"92755\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/attachment\/lambda-rds-console-image35_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image35_en.png?fit=1476%2C1100&amp;ssl=1\" data-orig-size=\"1476,1100\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Lambda-RDS-Console-image35_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image35_en.png?fit=845%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image35_en.png?resize=845%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92755\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image35_en.png?resize=845%2C630&amp;ssl=1 845w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image35_en.png?resize=423%2C315&amp;ssl=1 423w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image35_en.png?resize=768%2C572&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Lambda-RDS-Console-image35_en.png?w=1476&amp;ssl=1 1476w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">5-2. Operation check in a browser<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s access the API Gateway endpoint with a browser and check the operation. If you get the XML as shown below, it&#8217;s a success.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"235\" data-attachment-id=\"92608\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-xm_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?fit=712%2C279&amp;ssl=1\" data-orig-size=\"712,279\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-xm_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?fit=712%2C279&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?resize=600%2C235&#038;ssl=1\" alt=\"\" class=\"wp-image-92608\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?resize=600%2C235&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?w=712&amp;ssl=1 712w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you see an error, it may be because your Lambda function timeout is too short. See the article <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-troubleshooting\/\">Using Amazon RDS as an External Master (Troubleshooting)<\/a> and try changing the timeout setting.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If characters are garbled, again look at Using Amazon RDS as an External Master (Troubleshooting).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">6. Create an App that Uses a Search Select Box in Questetra BPM Suite<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Create an App in Questetra BPM Suite and add \u201cSearch Select Box\u201d to the data items (Display name is \u201cSearch Select\u201d). Select \u201cGet choices list via HTTP\u201d in \u201cType of data source\u201d, enter the API endpoint in \u201cURL\u201d, and click \u201cApply and Close\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"622\" height=\"630\" data-attachment-id=\"92605\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image3_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?fit=1290%2C1306&amp;ssl=1\" data-orig-size=\"1290,1306\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image3_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?fit=622%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=622%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92605\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=622%2C630&amp;ssl=1 622w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=311%2C315&amp;ssl=1 311w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=768%2C778&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?w=1290&amp;ssl=1 1290w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s release the App and check the form. Enter the search string and press the search button to display the options that match the conditions.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"118\" data-attachment-id=\"92602\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image1_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?fit=1080%2C124&amp;ssl=1\" data-orig-size=\"1080,124\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image1_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?fit=1024%2C118&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=1024%2C118&#038;ssl=1\" alt=\"\" class=\"wp-image-92602\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=1024%2C118&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=600%2C69&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=768%2C88&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?w=1080&amp;ssl=1 1080w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">What did you think? We used Amazon RDS this time, but you can use other databases as external masters in a similar way. Please consider using an external service according to the nature and purpose of the master data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Utilizing Data managed in Amazon RDS (Relational Database Service) as the external master of the Search Select Box of Questetra BPM Suite. Creating an AWS resource with AWS Console.<\/p>\n","protected":false},"author":17,"featured_media":91604,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[296],"tags":[3138],"class_list":["post-92637","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-blog","tag-aws-2"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Shiho Tatsumi","author_link":"https:\/\/support.questetra.com\/en\/author\/tatsumi48c607ec82\/"},"uagb_comment_info":2,"uagb_excerpt":"Utilizing Data managed in Amazon RDS (Relational Database Service) as the external master of the Search Select Box of Questetra BPM Suite. Creating an AWS resource with AWS Console.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-o69","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":92570,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/","url_meta":{"origin":92637,"position":0},"title":"Using Amazon RDS as an External Master (Terraform)","author":"Shiho Tatsumi","date":"2020-08-13","format":false,"excerpt":"Utilizing Data managed in Amazon RDS (Relational Database Service) as the external master of the Search Select Box of Questetra BPM Suite. Creating an AWS resource with Terraform.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":93945,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-kintone\/","url_meta":{"origin":92637,"position":1},"title":"Using Kintone App as an External Master","author":"Shiho Tatsumi","date":"2020-08-26","format":false,"excerpt":"We are going to use data that has been managed by kintone as the external options master for Search Select Box in Questetra BPM Suite. For the resource of AWS that relays kintone and Questetra BPM, Terraform is available.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":92943,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-troubleshooting\/","url_meta":{"origin":92637,"position":2},"title":"Using Amazon RDS as an External Master (Troubleshooting)","author":"Shiho Tatsumi","date":"2020-08-13","format":false,"excerpt":"Introducing troubleshooting when garbled characters or errors occur in Using Amazon RDS as an External Master (AWS console) and Using Amazon RDS as an External Master (Terraform).","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":104211,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/lambda-external-master\/","url_meta":{"origin":92637,"position":3},"title":"How to Use a File in Lambda as an External Master","author":"Peter Glover","date":"2021-05-11","format":false,"excerpt":"You may want to use master data managed by files such as XML, CSV, etc. in Questetra BPM Suite. This time, we will upload a master data file to AWS Lambda and use it as an external master for a [Search Select Box] in Questetra BPM Suite.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":70597,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-salesforce\/","url_meta":{"origin":92637,"position":4},"title":"How to Use Customer Data in Salesforce as Options","author":"HatanakaAkihiro","date":"2018-08-16","format":false,"excerpt":"How to check details of selected customer data on Salesforce.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":72429,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/","url_meta":{"origin":92637,"position":5},"title":"Several Ways to Manage Master Data with Questetra","author":"Tsuyoshi Kusaka","date":"2017-09-19","format":false,"excerpt":"Hi there! The topic I am going to talk about this time is related with utilizing Questetra, as well as system collaboration. Management of master data associated with Questetra is one of the common agendas. There are cases where you prepare an approval flow when registering\/modifying\/deleting master data, which Questetra\u2026","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/92637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=92637"}],"version-history":[{"count":32,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/92637\/revisions"}],"predecessor-version":[{"id":113276,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/92637\/revisions\/113276"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/91604"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=92637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=92637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=92637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}