If you want to use the snowflake python connector in your pipeline you have to install the connector software on a agent. If you have a private agent it's only necessary once but on a public agent you need to install the software every time. If you don't do that, you will get an error in python :
ImportError: No module named snowflake.connector
##[error]The process '/usr/bin/python' failed with exit code 1
- Upgrade pip to the latest version.
- Download the python connector.
- Installation of the python connector.
- script : | python --version python -m pip install --upgrade pip python -m pip install -r https://raw.githubusercontent.com/snowflakedb/snowflake-connector-python/v2.3.7/tested_requirements/requirements_36.reqs python -m pip install snowflake-connector-python==2.1.3 displayName: 'Install Snowflake connector'
This will download the software on the machine and you can use the connector in your python script.