---
schema_version: "1"
id: a49fc74da618b3ddb8e22d4df955d2f5186124f983dcd37df03145226ea11fbb
title: ConnectApi.QuerySqlStatus
collection: legacydeveloper
version: current
locale: en-us
portal_url: https://docs.salesforce.com/legacydeveloper/current/en-us/apexref/apex_connectapi_output_query_sql_status.md
canonical_url: https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_connectapi_output_query_sql_status.htm
source_site: developer.salesforce.com
content_type: documentation
content_hash: 0831a2e14af917de62dfca9510e4d1e403620a4d15e549c1c7e0d74da9ac0f70
description: Represents the status of an SQL query.
---
# ConnectApi.QuerySqlStatus

Represents the status of an SQL query.

<table class="featureTable sort_table" summary="">




          <thead class="thead sorted" align="left">
            <tr>
              <th class="featureTableHeader vertical-align-top " id="d1188751e46">Property Name</th>

              <th class="featureTableHeader vertical-align-top " id="d1188751e49">Type</th>

              <th class="featureTableHeader vertical-align-top " id="d1188751e52">Description</th>

              <th class="featureTableHeader vertical-align-top " id="d1188751e55">Available Version</th>

            </tr>

          </thead>

          <tbody class="tbody">
            <tr>
              <td class="entry" headers="d1188751e46" data-title="Property Name"><samp class="codeph apex_code">chunkCount</samp></td>

              <td class="entry" headers="d1188751e49" data-title="Type">Long</td>

              <td class="entry" headers="d1188751e52" data-title="Description"><span class="ph" id="chunkCount"><a name="chunkCount"><!-- --></a>Number of chunks available for extraction.</span></td>

              <td class="entry" headers="d1188751e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1188751e46" data-title="Property Name"><samp class="codeph apex_code">completionStatus</samp></td>

              <td class="entry" headers="d1188751e49" data-title="Type"><a class="xref" href="https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/connectAPI_enums.htm#QuerySqlStatusEnum"><samp class="codeph apex_code">QuerySqlStatusEnum</samp></a></td>

              <td class="entry" headers="d1188751e52" data-title="Description">Completion status of the query.<ul class="ul bulletList">
                  <li class="li"><samp class="codeph nolang">Finished</samp></li>
                  <li class="li"><samp class="codeph nolang">ResultsProduced</samp></li>
                  <li class="li"><samp class="codeph nolang">Running</samp></li>
                  <li class="li"><samp class="codeph nolang">Unspecified</samp></li>
                </ul>
              </td>

              <td class="entry" headers="d1188751e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1188751e46" data-title="Property Name"><samp class="codeph apex_code">expirationTime</samp></td>

              <td class="entry" headers="d1188751e49" data-title="Type">String</td>

              <td class="entry" headers="d1188751e52" data-title="Description"><span class="ph" id="expirationTime"><a name="expirationTime"><!-- --></a>Time when the query expires. You can't make requests to
                  an expired query.</span></td>

              <td class="entry" headers="d1188751e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1188751e46" data-title="Property Name"><samp class="codeph apex_code">progress</samp></td>

              <td class="entry" headers="d1188751e49" data-title="Type">Double</td>

              <td class="entry" headers="d1188751e52" data-title="Description">A number between 0 and 1 that indicates the current progress of query.
                <a name="ul_s4x_nkp_nfc"><!-- --></a>
                <ul class="ul bulletList" id="ul_s4x_nkp_nfc">
                  <li class="li">
                    <samp class="codeph apex_code">0</samp>: The query execution has not
                    started.
                  </li>

                  <li class="li">
                    <samp class="codeph apex_code">1</samp>: The query execution is complete and
                    the results are available for you to retrieve.
                  </li>

                </ul>
              </td>

              <td class="entry" headers="d1188751e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1188751e46" data-title="Property Name"><samp class="codeph apex_code">queryId</samp></td>

              <td class="entry" headers="d1188751e49" data-title="Type">String</td>

              <td class="entry" headers="d1188751e52" data-title="Description"><span class="ph" id="queryId"><a name="queryId"><!-- --></a>ID of the query for which status information is
                  returned.</span></td>

              <td class="entry" headers="d1188751e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1188751e46" data-title="Property Name"><samp class="codeph apex_code">rowCount</samp></td>

              <td class="entry" headers="d1188751e49" data-title="Type">Long</td>

              <td class="entry" headers="d1188751e52" data-title="Description"><span class="ph" id="rowCount"><a name="rowCount"><!-- --></a>Number of rows available for extraction.</span></td>

              <td class="entry" headers="d1188751e55" data-title="Available Version">62.0</td>

            </tr>

          </tbody>

        </table>

#### See Also

- [querySqlStatus(queryId)](https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_ConnectAPI_CdpQuery_static_methods.htm#apex_ConnectAPI_CdpQuery_querySqlStatus_1 "Get the status of an SQL query request. Results are available for up to 24 hours.")
- [querySqlStatus(queryId, waitTimeMs)](https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_ConnectAPI_CdpQuery_static_methods.htm#apex_ConnectAPI_CdpQuery_querySqlStatus_2 "Get the status of an SQL query request and specify the time to wait before returning the response. Results are available for up to 24 hours.")
- [querySqlStatus(queryId, dataspace)](https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_ConnectAPI_CdpQuery_static_methods.htm#apex_ConnectAPI_CdpQuery_querySqlStatus_3 "Get the status of an SQL query request and specify the data space. Results are available for up to 24 hours.")
- [querySqlStatus(queryId, dataspace, waitTimeMs)](https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_ConnectAPI_CdpQuery_static_methods.htm#apex_ConnectAPI_CdpQuery_querySqlStatus_4 "Get the status of an SQL query request. Specify the data space and time to wait before returning the response. Results are available for up to 24 hours.")
- [querySqlStatus(queryId, workloadName, dataspace)](https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_ConnectAPI_CdpQuery_static_methods.htm#apex_ConnectAPI_CdpQuery_querySqlStatus_5 "Get the status of an SQL query request. Specify the workload name and data space. Results are available for up to 24 hours.")
- [querySqlStatus(queryId, workloadName, dataspace, waitTimeMs)](https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_ConnectAPI_CdpQuery_static_methods.htm#apex_ConnectAPI_CdpQuery_querySqlStatus_6 "Get the status of an SQL query request. Specify the workload name, data space, and time to wait before returning the response. Results are available for up to 24 hours.")