> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/gridgain/gridgain-9/gridgain9-development/accessing-data.md).

# Data Access

Read and write data in GridGain 9 — the Table API, tables from Java classes, SQL, transactions, continuous queries, data streaming, and data archiving.

{% columns %}
{% column %}
{% content-ref url="/pages/dwZGzyojFsGMyAfFNPop" %}
[Table API](/docs/gridgain/gridgain-9/gridgain9-development/accessing-data/table-api.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Execute table operations in GridGain 9 with RecordView and KeyValueView, map user objects to table tuples, run criterion queries, and use the partition API.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/UdECLRFDIztsYWToFHLM" %}
[Tables from Java Classes](/docs/gridgain/gridgain-9/gridgain9-development/accessing-data/tables-from-java-classes.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Create tables, zones, and indexes directly from Java POJOs using the GridGain 9 catalog API, with annotation-based and builder-based examples.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/44qnEmy7E47wnm0VlkEJ" %}
[Working with SQL](/docs/gridgain/gridgain-9/gridgain9-development/accessing-data/sql.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Work with SQL in GridGain 9 through the Apache Calcite-based SQL engine, the Java SQL API, and the ODBC driver.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/tBulXCm9sdpa3JpSWVGq" %}
[Transactions](/docs/gridgain/gridgain-9/gridgain9-development/accessing-data/transactions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Perform explicit and implicit transactions in GridGain 9 — lifecycle, isolation, read-only transactions, timeouts, labels, and runInTransaction.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/4LcG2QU0B3ZwNuiyW7sl" %}
[Continuous Queries](/docs/gridgain/gridgain-9/gridgain9-development/accessing-data/continuous-queries.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Monitor data modifications in a GridGain 9 table with continuous queries — subscribers, watermarks, dedicated executors, remote filters, and event types.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Z1v1UVnLrmrhW2R0ZJOq" %}
[Data Streaming](/docs/gridgain/gridgain-9/gridgain9-development/accessing-data/data-streaming.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Load large volumes of data into a GridGain 9 cluster with the Data Streamer API, configure batching and flushing, use receivers, and track failed entries.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/OumVvvi1Ph4WL7EKivSv" %}
[Data Archiving](/docs/gridgain/gridgain-9/gridgain9-development/accessing-data/data-archiving.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
How data archiving in GridGain 9 removes aged data from primary storage after moving it to secondary storage for HTAP workloads.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/qQ4gTYzmkrFV1JHJBaX7" %}
[Using the REST API](/docs/gridgain/gridgain-9/gridgain9-development/accessing-data/rest-api.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Use the GridGain 9 REST API to monitor and manage a cluster over HTTP, run SQL statements and scripts, page through results, and generate a Java client.
{% endcolumn %}
{% endcolumns %}