mbarugelCA commented on issue #47003: URL: https://github.com/apache/airflow/issues/47003#issuecomment-2708846656
> > [@rawwar](https://github.com/rawwar) I haven't tried this but I don't think it would work, because the `-----BEGIN PRIVATE KEY-----` should be in its own line afaik. > > I don't have a Snowflake account handy; if you can, please try it and confirm here. Thanks! It returns this error: ```Traceback (most recent call last): File "/usr/local/bin/airflow", line 8, in <module> sys.exit(main()) File "/usr/local/lib/python3.10/site-packages/airflow/__main__.py", line 62, in main args.func(args) File "/usr/local/lib/python3.10/site-packages/airflow/cli/cli_config.py", line 49, in command return func(*args, **kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/utils/cli.py", line 116, in wrapper return f(*args, **kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/utils/session.py", line 97, in wrapper return func(*args, session=session, **kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/cli/commands/task_command.py", line 680, in task_test ti.run(ignore_task_deps=True, ignore_ti_state=True, test_mode=True, raise_on_defer=True) File "/usr/local/lib/python3.10/site-packages/airflow/utils/session.py", line 97, in wrapper return func(*args, session=session, **kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/models/taskinstance.py", line 3239, in run self._run_raw_task( File "/usr/local/lib/python3.10/site-packages/airflow/utils/session.py", line 94, in wrapper return func(*args, **kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/models/taskinstance.py", line 3006, in _run_raw_task return _run_raw_task( File "/usr/local/lib/python3.10/site-packages/airflow/models/taskinstance.py", line 274, in _run_raw_task TaskInstance._execute_task_with_callbacks( File "/usr/local/lib/python3.10/site-packages/airflow/models/taskinstance.py", line 3161, in _execute_task_with_callbacks result = self._execute_task(context, task_orig) File "/usr/local/lib/python3.10/site-packages/airflow/models/taskinstance.py", line 3185, in _execute_task return _execute_task(self, context, task_orig) File "/usr/local/lib/python3.10/site-packages/airflow/models/taskinstance.py", line 768, in _execute_task result = _execute_callable(context=context, **execute_callable_kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/models/taskinstance.py", line 734, in _execute_callable return ExecutionCallableRunner( File "/usr/local/lib/python3.10/site-packages/airflow/utils/operator_helpers.py", line 252, in run return self.func(*args, **kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/models/baseoperator.py", line 424, in wrapper return func(self, *args, **kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/decorators/base.py", line 266, in execute return_value = super().execute(context) File "/usr/local/lib/python3.10/site-packages/airflow/models/baseoperator.py", line 424, in wrapper return func(self, *args, **kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/operators/python.py", line 238, in execute return_value = self.execute_callable() File "/usr/local/lib/python3.10/site-packages/airflow/operators/python.py", line 256, in execute_callable return runner.run(*self.op_args, **self.op_kwargs) File "/usr/local/lib/python3.10/site-packages/airflow/utils/operator_helpers.py", line 252, in run return self.func(*args, **kwargs) ... File "/usr/local/lib/python3.10/site-packages/airflow/providers/common/sql/hooks/sql.py", line 336, in get_first return self.run(sql=sql, parameters=parameters, handler=fetch_one_handler) File "/usr/local/lib/python3.10/site-packages/airflow/providers/snowflake/hooks/snowflake.py", line 459, in run with closing(self.get_conn()) as conn: File "/usr/local/lib/python3.10/site-packages/airflow/providers/snowflake/hooks/snowflake.py", line 329, in get_conn conn_config = self._get_conn_params File "/usr/local/lib/python3.10/functools.py", line 981, in __get__ val = self.func(instance) File "/usr/local/lib/python3.10/site-packages/airflow/providers/snowflake/hooks/snowflake.py", line 272, in _get_conn_params p_key = serialization.load_pem_private_key( File "/usr/local/lib/python3.10/site-packages/cryptography/hazmat/backends/openssl/backend.py", line 494, in _handle_key_loading_error raise ValueError( ValueError: ('Could not deserialize key data. The data may be in an incorrect format, it may be encrypted with an unsupported algorithm, or it may be an unsupported key type (e.g. EC curves with explicit parameters).', [<OpenSSLError(code=503841036, lib=60, reason=524556, reason_text=unsupported)>])``` This happens even before an actual connection to Snowflake is attempted. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
