apache / apache/hop

[Feature Request]: Caching the snowflake connection

Open
#3,158 0 comments 0 reactions 0 assignees View on GitHub
API awaiting triage Causes friction P3
Dominant language
Java
Stars
1.5k
Forks
476
Avg merge
19h
Merged PRs (30d)
227

Description

### What would you like to happen?

I would like to request the new feature for caching the snowflake connection once logged in successfully. Currently the connection is discarded after query execution this could cause issues when too many requests via externalbrowser authentication take place.

### Issue Priority

Priority: 3

### Issue Component

Component: API

Contributor guide

Open the contributing guide

Research direction

The issue names the API component, Snowflake connections, query execution, and externalbrowser authentication, but no files or tests. Start by locating the API entry point that creates and discards the connection after a query. Done means a successfully authenticated connection can be reused for later requests without repeated externalbrowser authentication.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
api, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.