Team, i followed the flyte documentation and updated the snowflake JWT_TOKEN. it is working fine, h...

mammoth-lion-71167

10/28/2022, 7:50 AM

Team, i followed the flyte documentation and updated the snowflake JWT_TOKEN. it is working fine, however token validity is just one day. we need to create new everyday and new token require editing the kubernetes secret. we can create jwt_token without expiry?

Copy code

FLYTE_SNOWFLAKE_CLIENT_TOKEN: <JWT_TOKEN>

tall-lock-23197

10/28/2022, 10:33 AM

cc: @glamorous-carpet-83516

thankful-minister-83577

10/28/2022, 2:37 PM

can you make an issue for this @mammoth-lion-71167

thankful-minister-83577

10/28/2022, 2:40 PM

the plugin only takes one token right now.

thankful-minister-83577

10/28/2022, 2:40 PM

the way around this is probably to take a refresh token as well.

thankful-minister-83577

10/28/2022, 2:42 PM

and then the webapi plugin can refresh on expiry, but not sure where’s the best place to put this. presumably this is something the webapi plugin can support more broadly not just in snowflake. in the meantime, any chance you can bump the expiration?

mammoth-lion-71167

11/01/2022, 5:18 AM

@delightful-lion-57360

mammoth-lion-71167

11/02/2022, 11:28 AM

@thankful-minister-83577 @glamorous-carpet-83516 thanks yee. do you have any sample code for executing snowflake query using backend plugin?

glamorous-carpet-83516

11/02/2022, 7:05 PM

https://docs.flyte.org/projects/cookbook/en/latest/auto/integrations/external_services/snowflake/snowflake.html#sphx-glr-auto-in[…]lake-snowflake-py

glamorous-carpet-83516

11/02/2022, 7:05 PM

Configuring the backend to get snowflake working

156 Views

Open in Slack

Previous Next

Flyte

Flyte enables production-grade orchestration for machine learning workflows and data processing created to accelerate local workflows to production.