Security while providing connection options.

Question

How can I provide connection options securely while loading data using **glueContext.create_dynamic_frame.from_options** , writing them down in the script is a no go and providing them through arguments to the job also does not seem to be secure. Is there something that I am missing here or there is no other way? TIA.

Accepted Answer

GlueContext.extract_jdbc_conf method might help your use-case.  
With this method, you can retrieve JDBC parameters from your existing Glue connections.

```
jdbc_conf = glue_context.extract_jdbc_conf(connection_name='')
user = jdbc_conf['user']
password = jdbc_conf['password']
```

See details here.  
https://docs.aws.amazon.com/glue/latest/dg/aws-glue-api-crawler-pyspark-extensions-glue-context.html

Security while providing connection options.

Contenuto pertinente