dbt-spark does not support secure ssl connection with hive

[rahulgoyal2987]

Describe the feature

dbt-spark does not support secure ssl connection using hive.
pyhive does not support use_ssl hive feature. py_hive provide transport support using this secure ssl connenction can be created. pure-transport create transport object which can be passed to pyhive which can be used to support use_ssl feature. and certificate can be stored on default store location

If you are interested in feature I can create pull request for same

[jtcohen6]

Hi @rahulgoyal2987, thanks for opening! Do you have a sense of how we'd add support for this? Does it look like new use_ssl parameter in profiles.yml, passed to hive.connect()?

[rahulgoyal2987]

Hi @jtcohen6 I have added a pull request #169 for the same. I have tested the code on local and added the test cases also
SSL certificate can be stored on default store location which can get using below two lines of code
import ssl
ssl.get_default_verify_paths()

[jtcohen6]

Closed by #169