I am looking out a possible solution for Github Secrets. I have created a pipeline for CICD wherein it executes the script as soon as any sql file lands in dbscripts folder.
I am able to execute the scripts till it fetches Snowflake Username and Password from the secrets which I have maintained like below.
env:
Code:
But the problem is in real time, I have a SSO login on my snowflake account so how to configure GIT to execute the workflow scripts if password will not be available in secrets due to SSO login for snowflake account.
I am able to execute the scripts till it fetches Snowflake Username and Password from the secrets which I have maintained like below.
env:
Code:
SF_ACCOUNT: ${{ secrets.SF_ACCOUNT }} SF_USERNAME: ${{ secrets.SF_USERNAME }} SF_ROLE: ${{ secrets.SF_ROLE }} SF_WAREHOUSE: ${{ secrets.SF_WAREHOUSE }} SF_DATABASE: ${{ secrets.SF_DATABASE }} SNOWFLAKE_PASSWORD: ${{ secrets.SF_PASSWORD }}But the problem is in real time, I have a SSO login on my snowflake account so how to configure GIT to execute the workflow scripts if password will not be available in secrets due to SSO login for snowflake account.