---
title: "GET /v1/projects/{projectsId}/locations/{locationsId}/sessions/{sessionsId}/sparkApplications/{sparkApplicationsId}:accessSqlQuery"
method: GET
path: "/v1/projects/{projectsId}/locations/{locationsId}/sessions/{sessionsId}/sparkApplications/{sparkApplicationsId}:accessSqlQuery"
tags: ["projects"]
---

# GET /v1/projects/{projectsId}/locations/{locationsId}/sessions/{sessionsId}/sparkApplications/{sparkApplicationsId}:accessSqlQuery

`GET /v1/projects/{projectsId}/locations/{locationsId}/sessions/{sessionsId}/sparkApplications/{sparkApplicationsId}:accessSqlQuery`

## Request

- Base URL: `https://dataproc.googleapis.com`
- URL: `https://dataproc.googleapis.com/v1/projects/{projectsId}/locations/{locationsId}/sessions/{sessionsId}/sparkApplications/{sparkApplicationsId}:accessSqlQuery`
- Auth: one of:
  - OAuth 2 and OAuth 2
    - Implicit: `https://accounts.google.com/o/oauth2/auth`
    - Scopes: `https://www.googleapis.com/auth/cloud-platform`
    - Authorization code: `https://accounts.google.com/o/oauth2/auth`
    - Token URL: `https://accounts.google.com/o/oauth2/token` scopes: `https://www.googleapis.com/auth/cloud-platform`
  - OAuth 2 and OAuth 2
    - Implicit: `https://accounts.google.com/o/oauth2/auth`
    - Scopes: `https://www.googleapis.com/auth/dataproc`
    - Authorization code: `https://accounts.google.com/o/oauth2/auth`
    - Token URL: `https://accounts.google.com/o/oauth2/token` scopes: `https://www.googleapis.com/auth/dataproc`
  - OAuth 2 and OAuth 2
    - Implicit: `https://accounts.google.com/o/oauth2/auth`
    - Scopes: `https://www.googleapis.com/auth/dataproc.read-only`
    - Authorization code: `https://accounts.google.com/o/oauth2/auth`
    - Token URL: `https://accounts.google.com/o/oauth2/token` scopes: `https://www.googleapis.com/auth/dataproc.read-only`
- TypeScript: <https://skmtc.dev/google/apis/dataproc/docs/v1/projects/:projectsId/locations/:locationsId/sessions/:sessionsId/sparkApplications/:sparkApplicationsId:accessSqlQuery/get.ts> (a function with typed inputs; its response is checked against the schema)

Obtain data corresponding to a particular SQL Query for a Spark Application.

## Path parameters

- `projectsId` string, required
- `locationsId` string, required
- `sessionsId` string, required
- `sparkApplicationsId` string, required

## Query parameters

- `details` boolean
- `executionId` string, int64
- `parent` string
- `planDescription` boolean

## Response `200`

Successful response

- AccessSessionSparkApplicationSqlQueryResponse: Details of a query for a Spark Application
  - `executionData` SqlExecutionUiData: SQL Execution Data
    - `completionTime` string, google-datetime
    - `description` string
    - `details` string
    - `errorMessage` string
    - `executionId` string, int64
    - `jobs` object
    - `metricValues` object
    - `metricValuesIsNull` boolean
    - `metrics` SqlPlanMetric[]
      - `accumulatorId` string, int64
      - `metricType` string
      - `name` string
    - `modifiedConfigs` object
    - `physicalPlanDescription` string
    - `rootExecutionId` string, int64
    - `stages` string[]
    - `submissionTime` string, google-datetime

## Changes

- **2026-10-29** `99b75ef6e002`: 4 info
  - the security scope `https://www.googleapis.com/auth/cloud-platform` was added to the endpoint's security scheme `Oauth2`
  - the security scope `https://www.googleapis.com/auth/cloud-platform` was added to the endpoint's security scheme `Oauth2c`
  - the security scope `https://www.googleapis.com/auth/dataproc.read-only` was removed from the endpoint's security scheme `Oauth2`
  - the security scope `https://www.googleapis.com/auth/dataproc.read-only` was removed from the endpoint's security scheme `Oauth2c`

[Operation history](https://skmtc.dev/google/apis/dataproc/changes/v1/projects/:projectsId/locations/:locationsId/sessions/:sessionsId/sparkApplications/:sparkApplicationsId:accessSqlQuery/get.md)

---

[API](https://skmtc.dev/google/apis/dataproc.md) - [All operations](https://skmtc.dev/google/apis/dataproc/llms.txt) - [OpenAPI document](https://skmtc.dev/google/apis/dataproc/revisions/99b75ef6e002?raw)