[37/100] #100DaysOfCloud Today, I created a sample Amazon RDS instance on an MS SQL engine, and connected the data for visualization using Amazon QuickSight.
In this, I created a MS SQL database instance in RDS and using Microsoft SQL Server Management Studio, I connected into the database and created a database and added queries to it to create the necessary data. The RDS BD instance was made public to do this and once it is created, it is made not publically accesssible.
Then the necessary security groups are created for the QuickSight to access the RDS instance as well as for the RDS to connect to QuickSight.
Later, I connect create a VPC connection and create a dataset from the data in the RDS DB and then use the dataset to visualise the data in QuickSight.
You can try do it by yourself by following the steps from the link below: GitHub
Top comments (0)