---
title: "Get ZCQL Instance"
url: https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/zcql/get-component-instance/
description: "This page describes the method to execute ZCQL queries on a table in the Data Store in your Python application with sample code snippets."
last_updated: 2026-03-06T16:19:28Z
service: Cloud Scale
type: general
related_links:
  - name: "ZCQL Help"
    url: /en/cloud-scale/help/zcql/introduction
  - name: "Data Store Help"
    url: /en/cloud-scale/help/data-store/introduction
---

# ZCQL

[Catalyst Cloud Scale ZCQL](https://docs.catalyst.zoho.com/en/cloud-scale/help/zcql/introduction) is Catalyst's own query language that enables you to perform data retrieval, insertion, updation, and deletion operations on the tables in the Catalyst Cloud Scale Data Store. You can execute a variety of DML queries using ZCQL to obtain or manipulate data, and use various clauses and statements such as the SQL Join clauses, Groupby and OrderBy statements, and built-in SQL functions.

Catalyst also provides an [**OLAP database**](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/olap-database/introduction/), in addition to the primary Data Store that is suited for analytical data retrieval queries. You can choose to execute simple transactional queries on the primary Data Store, and complex analytical queries that involve [ZCQL functions](https://docs.catalyst.zoho.com/en/cloud-scale/help/zcql/zcql-functions/) on the OLAP database. 

### Get a Component Instance

A component instance is an object that can be used to access the predefined configurations specific to a particular component. This process will not fire a server-side call.

The `app` reference used in the code below is the Python object returned as a response during SDK initialization. Also note that this instance will be used in multiple scenarios while performing retrieval, insertion, updating, or deleting operations in the Catalyst Data Store.

```python
#Get a ZCQL component instance
zcql_service = app.zcql()

```