# pip install boto3
# install the aws cli v2
# use aws configure to set script for keys and region credentials

import boto3   # Python Library to Access AWs CLI

# Download the file form the S3 
'''
Loading data directly from an Amazon S3 bucket into an Oracle RDS database using 
SQL*Loader involves a few additional steps, as SQL*Loader cannot directly access files in S3. 
You'll first need to download the file from S3 to a location accessible to SQL*Loader 
(like an EC2 instance or your local machine), and then use 
SQL*Loader to load the data into Oracle RDS.
'''

def download_file_from_s3(bucket_name, s3_file_name, local_file_path):
    s3 = boto3.client('s3')
    s3.download_file(bucket_name, s3_file_name, local_file_path)
    print(f"File downloaded successfully: {local_file_path}")

local_file_path = 'contacts_temp.csv'

bucket_name = 'your_bucket_name'
s3_file_name = 'your_file_name'

download_file_from_s3(bucket_name, s3_file_name, local_file_path)

# S3 bucket details
# bucket_name = 'bucket_name_from_above'
# s3_file_name = 's3_file_name_from_above'