Skip to content
This repository was archived by the owner on May 14, 2026. It is now read-only.
This repository was archived by the owner on May 14, 2026. It is now read-only.

Enable Spanner Request Priority argument in queries / sessions #248

Closed
#286
Closed
Enable Spanner Request Priority argument in queries / sessions#248
#286
Assignees
asthamohta
Labels
api: spannerIssues related to the googleapis/python-spanner-sqlalchemy API.priority: p3Desirable enhancement or fix. May not be included in next release.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.

Description

@awertman
awertman
opened on Sep 22, 2022

The standard cloud spanner python API enables a RequestOptions parameter in requests which can be used to set request Priorities.

https://cloud.google.com/python/docs/reference/spanner/latest/google.cloud.spanner_v1.types.RequestOptions
https://cloud.google.com/python/docs/reference/spanner/latest/google.cloud.spanner_v1.types.RequestOptions.Priority

https://github.com/googleapis/python-spanner/blob/474b1b56cd11bc22d274a85664b09532a576e3d6/tests/unit/test_snapshot.py#L810

We would like to be able to set low and medium priorities on certain requests.

Activity

  1. awertman
    added
    priority: p3Desirable enhancement or fix. May not be included in next release.
    type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.
    on Sep 22, 2022
  2. product-auto-label
    added
    api: spannerIssues related to the googleapis/python-spanner-sqlalchemy API.
    on Sep 22, 2022
  3. blunderbuss-gcf
    assigned
    asthamohta
    on Sep 22, 2022

  4. IlyaFaer commented on Sep 23, 2022

    @IlyaFaer
    IlyaFaer
    on Sep 23, 2022

    @asthamohta, this should be possible. We're already using some execution options:

    python-spanner-sqlalchemy/google/cloud/sqlalchemy_spanner/sqlalchemy_spanner.py

    Line 145 in 68b9bc8

    class SpannerExecutionContext(DefaultExecutionContext):

    Something similar can be done for priorities.

  5. asthamohta
    closed this as completedin #286on Nov 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

api: spannerIssues related to the googleapis/python-spanner-sqlalchemy API.priority: p3Desirable enhancement or fix. May not be included in next release.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions