hasura / hasura/graphql-engine

Aggregate Query Permission [SQL SERVER]

Open
#8,289 1 comment 0 reactions 0 assignees View on GitHub
k/enhancement
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

The [docs seem to indicate that there should be aggregate query permissions available](https://hasura.io/docs/latest/graphql/core/auth/authorization/permission-rules.html#aggregation-queries-permissions), however in `2.4.0-beta.1` there don't seem to be any. Currently it appears only admin level users are able to query aggregates.

Please add this capability or provide details on how to enable it directly in the yaml metadata as it's a really helpful feature for paging large tables to know what the count is.

Thanks!

This is from the docs:
![image](https://user-images.githubusercontent.com/49927862/157298962-5c9729b0-dec0-4e63-88bd-ffae881663fa.png)

This is what the console ui looks like for Sql Server currently:
![image](https://user-images.githubusercontent.com/49927862/157299027-37908ae7-b41e-432a-b7d2-7d6353dbb3b9.png)

Contributor guide

Open the contributing guide

Research direction

Start with the linked aggregate-query permission documentation and the SQL Server console behavior shown in the issue, then inspect the YAML metadata path mentioned in the request. Done means non-admin SQL Server users can use aggregate queries, or the supported metadata configuration is documented clearly.

Written by the indexing model from the issue text.

Assessment

Tech stack
graphql
Domain
api, authorization, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.