Get effective timeout respecting Snowflake parameter hierarchy.
This follows Snowflake's official parameter management best practices:
get_effective_timeout(
session: Session,
request_timeout: int = 30,
respect_session_timeout: bool = True
) -> int