AWS Glue ETL from S3 to RDS Sql Server succeeds but there is no data in the table

My job succeeds with no error but when I query the table, its empty The CSV is a single column with no header The table has a single column, record_id

SELECT TOP 1000 [record_id]
  FROM 
 [h3-glue-db].[dbo].[h3_load]

Here's the job script

import sys
from awsglue.transforms import *
from awsglue.utils import getResolvedOptions
from pyspark.context import SparkContext
from awsglue.context import GlueContext
from awsglue.job import Job

args = getResolvedOptions(sys.argv, ["JOB_NAME"])
sc = SparkContext()
glueContext = GlueContext(sc)
spark = glueContext.spark_session
job = Job(glueContext)
job.init(args["JOB_NAME"], args)

# Script generated for node S3 bucket
S3bucket_node1 = glueContext.create_dynamic_frame.from_options(
    format_options={
        "quoteChar": '"',
        "withHeader": False,
        "separator": ",",
        "optimizePerformance": False,
    },
    connection_type="s3",
    format="csv",
    connection_options={"paths": ["s3://h3-public/testfile2.csv"]},
    transformation_ctx="S3bucket_node1",
)

# Script generated for node ApplyMapping
ApplyMapping_node2 = ApplyMapping.apply(
    frame=S3bucket_node1, mappings=[("col0", "string", "record_id", "string")], transformation_ctx="ApplyMapping_node2"
)

# Script generated for node SQL Server table
SQLServertable_node3 = glueContext.write_dynamic_frame.from_catalog(
    frame=ApplyMapping_node2,
    database="h3-sql-database",
    table_name="h3_glue_db_dbo_h3_load",
    transformation_ctx="SQLServertable_node3",
)

job.commit()