Refresh token expiry issue in Snowflake adapter in OIC Gen3
Summary:
Refresh token expiry issue in Snowflake adapter in OIC Gen3
Content (please ensure you mask any confidential information):
We are using the OIC Gen 3 Snowflake adapter for one of our implementations and have a query regarding its configuration. According to the Oracle documentation on the Snowflake adapter, the refresh token expires after a maximum of 90 days. The documentation states:
"For the OAuth refresh token value, the maximum value can be set to 7776000 (90 days)."
You can find this information under the "Prerequisites for Creating a Connection" section on the Snowflake adapter Oracle page.
Link for Snowflake Adapter doc:
Does this mean that after 90 days, we need to provide consent again on the connection page in OIC and test the connection? If so, is there any way or workaround to mitigate the token expiry issue so that we don't have to reconfigure the connection in OIC every 90 days?