PinnedSerkan SAKINMAZHow 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…4 min read·May 5, 2021----
Serkan SAKINMAZPostgre 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…1 min read·Sep 4, 2023----
Serkan SAKINMAZHow 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…1 min read·Sep 1, 2023----
Serkan SAKINMAZHow 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…6 min read·Aug 31, 2023----
Serkan SAKINMAZHow 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…5 min read·Jan 8, 2023----
Serkan SAKINMAZHow 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…2 min read·Dec 7, 2022----
Serkan SAKINMAZCreating 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…5 min read·Nov 27, 2022----
Serkan SAKINMAZProcess 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…3 min read·Sep 19, 2022----
Serkan SAKINMAZPreparation 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…8 min read·Jun 1, 2022----
Serkan SAKINMAZDatabricks 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…5 min read·Feb 20, 2022----