Holisticz - Embrace the Infinite

Step into the world of endless opportunities and unlock the gateway to virtual transactions.

  • Domain Update: Our Forum has moved! Please visit us at Holisticz.com for the latest updates.

Snowflake-Github workflow

0

0%

Status

Offline

Posts

2

Likes

0

Rep

0

Bits

0

3

Years of Service

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:
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.
 

48,610

38,214

238,323

Top