Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support to run pre-execution queries such as SET statements for runtime configurations #728

Open
jsjasonseba opened this issue Jan 18, 2025 · 0 comments

Comments

@jsjasonseba
Copy link

Describe your feature request

Please describe the behavior you want and the motivation.

Related to: #645 #656 #512

Several use cases require issuing SET statement, such as setting transaction isolation levels, timeouts, etc. Connectorx can support this use case by adding a new parameter pre_execution_querries on cx.read_sql where user can submit SET statements and it is run before the SELECT statement. Since SET statements are typically applied per session (connection), each connection created for each partition must execute the pre-execution queries after connection is created.

I’m currently developing this functionality and planning to submit a PR. But I'm not certain if this aligns with the project’s direction. Any feedback or discussion would be appreciated.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant