Fix default config reading import

[sfc-gh-jdu]

The original import won't work in stored procedure, so we need to import it inside the create function

[sfc-gh-sfan]

We might want to add this function to sp connector even if it is just a no-op to reduce the stored proc check we have in code. Can you create a ticket to track that?

[sfc-gh-sfan]

We probably can do is_in_stored_procedure() check for the import? And for safety, also add the same check in the if clause before calling the function.

[sfc-gh-jdu]

done

[sfc-gh-sfan]

Sorry does not mean to approve yet

[sfc-gh-jdu]

We might want to add this function to sp connector even if it is just a no-op to reduce the stored proc check we have in code. Can you create a ticket to track that?

sure, created https://snowflakecomputing.atlassian.net/browse/SNOW-911000

[sfc-gh-aalam]

2023-09-08 11:16:32     from snowflake.snowpark.session import Session
2023-09-08 11:16:32   File "/home/jenkins/workspace/AnacondaPackageBuilder-x86/conda-bld/snowflake-snowpark-python_1694196935262/_test_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_pl/lib/python3.8/site-packages/snowflake/snowpark/session.py", line 154, in <module>
2023-09-08 11:16:32     from snowflake.connector.config_manager import _get_default_connection_params
2023-09-08 11:16:32 ImportError: cannot import name '_get_default_connection_params' from 'snowflake.connector.config_manager' (/home/jenkins/workspace/AnacondaPackageBuilder-x86/conda-bld/snowflake-snowpark-python_1694196935262/_test_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_pl/lib/python3.8/site-packages/snowflake/connector/config_manager.py)

This is still breaking https://ci-dev-142.int.snowflakecomputing.com/job/AnacondaPackageBuilder-x86/

@sfc-gh-jdu can you look into this and verify if our precommit test is happy?