in python/dataproc_templates/gcs/gcs_to_jdbc.py [0:0]
def parse_args(args: Optional[Sequence[str]] = None) -> Dict[str, Any]:
parser: argparse.ArgumentParser = argparse.ArgumentParser()
parser.add_argument(
f'--{constants.GCS_JDBC_INPUT_LOCATION}',
dest=constants.GCS_JDBC_INPUT_LOCATION,
required=True,
help='Cloud Storage location of the input files'
)
parser.add_argument(
f'--{constants.GCS_JDBC_INPUT_FORMAT}',
dest=constants.GCS_JDBC_INPUT_FORMAT,
required=True,
help='Input file format (one of: avro,parquet,csv,json,delta)',
choices=[
constants.FORMAT_AVRO,
constants.FORMAT_PRQT,
constants.FORMAT_CSV,
constants.FORMAT_JSON,
constants.FORMAT_DELTA
]
)
add_spark_options(parser, constants.get_csv_input_spark_options("gcs.jdbc.input."))
parser.add_argument(
f'--{constants.GCS_JDBC_OUTPUT_TABLE}',
dest=constants.GCS_JDBC_OUTPUT_TABLE,
required=True,
help='JDBC output table name'
)
parser.add_argument(
f'--{constants.GCS_JDBC_OUTPUT_MODE}',
dest=constants.GCS_JDBC_OUTPUT_MODE,
required=False,
default=constants.OUTPUT_MODE_APPEND,
help=(
'Output write mode '
'(one of: append,overwrite,ignore,errorifexists) '
'(Defaults to append)'
),
choices=[
constants.OUTPUT_MODE_OVERWRITE,
constants.OUTPUT_MODE_APPEND,
constants.OUTPUT_MODE_IGNORE,
constants.OUTPUT_MODE_ERRORIFEXISTS
]
)
parser.add_argument(
f'--{constants.GCS_JDBC_OUTPUT_URL}',
dest=constants.GCS_JDBC_OUTPUT_URL,
required=True,
help='JDBC output URL'
)
parser.add_argument(
f'--{constants.GCS_JDBC_OUTPUT_DRIVER}',
dest=constants.GCS_JDBC_OUTPUT_DRIVER,
required=True,
help='JDBC output driver name'
)
parser.add_argument(
f'--{constants.GCS_JDBC_BATCH_SIZE}',
dest=constants.GCS_JDBC_BATCH_SIZE,
required=False,
default=1000,
help='JDBC output batch size'
)
parser.add_argument(
f'--{constants.GCS_JDBC_NUMPARTITIONS}',
dest=constants.GCS_JDBC_NUMPARTITIONS,
required=False,
help='The maximum number of partitions to be used for parallelism in table writing'
)
known_args: argparse.Namespace
known_args, _ = parser.parse_known_args(args)
return vars(known_args)