# Choosing the Right BigQuery Insert Operation for Your Use Case with CData

**URL:** <https://community.cdata.com/t/choosing-the-right-bigquery-insert-operation-for-your-use-case-with-cdata/1088>\
**Category:** CData Drivers\
**Tags:** sql, discussion, driver, bigquery\
**Created:** [May 9, 2025, 4:15pm UTC](https://community.cdata.com/t/choosing-the-right-bigquery-insert-operation-for-your-use-case-with-cdata/1088 "2025-05-09T16:15:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohsin](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Post date:** [May 9, 2025, 4:15pm UTC](https://community.cdata.com/t/choosing-the-right-bigquery-insert-operation-for-your-use-case-with-cdata/1088/1 "2025-05-09T16:15:56Z")

</div>

When inserting data into BigQuery, choosing the right method is critical for performance, cost, and data freshness. Our latest article dives deep into the three main insert options supported by the **CData BigQuery Driver** :

- 🔹 **Streaming Inserts:** &nbsp;Send real-time data to BigQuery with near-instant availability — perfect for live dashboards and IoT use cases. Higher costs and temporary update restrictions apply.
- 🔹 **DML (Data Manipulation Language):**&nbsp;Insert, update, or delete records with full transactional integrity using SQL. Best for small, critical updates where data consistency matters.
- 🔹 **Bulk Loading:** &nbsp;Move large datasets cost-efficiently using batch loads. Ideal for ETL jobs and historical imports where immediate query access isn’t critical.

We compare the three methods across:

- **Performance**
- **Update timing**
- **Cost**
- **Best use cases**

Plus, learn how to control the insert strategy directly from your connection string with the CData BigQuery JDBC Driver.

🔗 **Read the full article here:**  
👉 [Comparing Insert Methods in BigQuery: Streaming, DML, and Bulk Loading](http://cdata.com/kb/articles/bigquery-insert-operations.rst)

Optimize your BigQuery workflows with the method that fits your needs best!