PinnedHow to use Athena to analyse data in Amazon S3 using standard SQLDo you have any difficulty analysing the CSV, Json, Avro, Parquet, XML file in your company or research project? In this blog, I am going…May 5, 2021May 5, 2021
Postgre Identifier “table_name_abc” will be truncated to “table_name”In your application, when you automatically generate the table from code, the table name could be different from how you create it. The…Sep 4, 2023Sep 4, 2023
How to fetch JSON via URL and parse in PythonIn this post, I am going to explain simple a code snippet that is very helpful for lots of applications. With Python, we are going to fetch…Sep 1, 2023Sep 1, 2023
How to tackle challenging situations as a solution architect?Software development is more than implementing the functional requirements based on the technical roadmap. Since development is teamwork…Aug 31, 2023Aug 31, 2023
How to manage your data with UpstashRedis is a distributed in-memory database that provides peak performance for applications. When you need a good caching solution, Redis…Jan 8, 2023Jan 8, 2023
How to export and import data to PostgreSQL from S3If you are working with PostgreSQL and S3 on your cloud project, most probably, there is a need to export and import between these…Dec 7, 2022Dec 7, 2022
Creating simple data pipeline with AWS Step FunctionsData pipeline is the skeleton of your application when you run multiple steps to create the final output. It consist of data collection…Nov 27, 2022Nov 27, 2022
Process S3 Located CSV files in LambdaLambda is a compute service that lets you run your code without provisioning or managing any server. Lambda is one of the most used…Sep 19, 2022Sep 19, 2022
Preparation for AWS Certified Data Analytics SpecialtyAWS Certified Data Analytics — Specialty is one of the most popular exam when it comes to work with data in AWS. In this section, I will…Jun 1, 2022Jun 1, 2022
Databricks Certified Developer for Apache Spark Scala Exam QuestionsDatabricks Academy is one of the most popular exam source for Apache Spark. In this section, I have listed up some example questions that…Feb 20, 2022Feb 20, 2022