The iT Tech Solutions

Setup git in VSCODE

Install Python on Windows and set Environment Variables

Use git in VSCODE | A quick guide

Setup git in VSCODE

Snowflake Copy Command and Internal Stage | Bulk Data Load Using Internal Stage

PySpark Learning Series | 10-Run Queries on Files without Reading it

Spark Installation - Complete Setup on Windows

PySpark Learning Series | 08-Write Dataframes to Files

PySpark Learning Series | 07-Create DataFrames from Parquet, JSON and CSV

PySpark Learning Series | 16 How to Use Joins in Pyspark

PySpark Learning Series | 15 SPARK-MySQL connection using JDBC driver

PySpark Learning Series | 13- Viewing Data | Some important options to remember

Learn SQL | Install MySQL Workbench on Windows

PySpark Learning Series | 05-Create DataFrame from RDD | toDF() | createDataFrame()

What is Snowflake Storage Integration?

Work with HIVE in PySpark

Load data into Snowflake from AWS s3 Bucket | Using IAM credentials

PySpark Learning Series | 17 How to add a new column

PySpark Learning Series | 11-Save Mode (Error, Ignore, Append, Overwrite)

PySpark Learning Series | 14- groupby(), avg(), min(), max(), count()

What is Snowflake Snowpipe?

PySpark Learning Series | 06-Hive Integration & Spark SQL | Read/Write data from/to Hive

Create multiple Lambda functions using single docker image

PySpark Tutorial

Python Datetime | Generate code with Codewhisperer and work with Date, Time, Formats and Timedelta

PySpark Learning Series | 23 Combining Dataframes With Different Structures using unionByName()

PySpark Learning Series | 02-Spark Installation on Windows

AWS Step function Variables

Connect to ChatGPT from Python

AWS Step Function States | Choice State, Success State and Fail State

How to run python on VSCODE

Connect VSCODE to AWS - Edit Step Functions using AWS toolkit

PySpark Learning Series | 04- RDD Hands-On

PySpark Learning Series | 18 How to Rename Column Names

PySpark Basic Concepts

ChatGPT - What is Prompt Engineering | Benefits and Types of Prompt

AWS Step Function Variables | ResultPath, InputPath, OutputPath

AWS Step Function Function Error Handling

ChatGPT Prompting Principles | Hands-on | Write Effective Prompts

Create a Lambda using Docker Image and Amazon ECR

PySpark Learning Series | 20 Filtering Data from Dataframe

ChatGPT Prompt Engineering

PySpark Learning Series | 12- Some useful FILE SOURCE OPTIONS to remember

Snowflake Stream and Task

Connect to Snowflake from Python

Connect to ChatGPT via openAI API using Python

Install AWS CLI on Windows

PySpark Learning Series | 09-Write Dataframe into Table (Persistent and Temporary)