---
schema_version: "1"
id: 444825c65d19606959b4eb7b8485f3565f3f64fe54bc5b3ab88f3d4e403bfc0b
title: SQL Commands for Tableau Hyper API
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/tableau-sql-commands/tableau-sql-commands-context.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/tableau-sql-commands-context.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: ac852144be24e3b20e941f409e048e13b8050df23989c18343649433818a38e0
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# SQL Commands for Tableau Hyper API

**Applies to:** ❌ Data 360 SQL ✅ Tableau Hyper API

Check out these SQL commands that perform write operations.

For more information about write operations in Tableau Hyper API, see [Execute SQL Commands](https://tableau.github.io/hyper-db/docs/guides/sql_commands/).

The Hyper API SQL commands can be grouped into these categories:

1. Data modification commands: Using [INSERT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/insert.md),
   [UPDATE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/update.md), [DELETE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/delete.md), and [TRUNCATE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/truncate.md),
   one can change the data stored inside a table.
   Furthermore, [COPY FROM](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/copy-from.md) copies data directly from
   an external file (e.g., a CSV or Parquet file) into a
   table.
   When combined with [SELECT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/sql-commands/select.md) queries, one can also use
   those commands to, e.g., materialize the results of complex
   analytical computations.
2. Data definition commands: Data Cloud SQL supports commands to
   [create databases](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/create-database.md), [tables](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/create-table.md) and
   modify ("alter") and delete ("drop") them.
3. Support statements for prepared statements: [PREPARE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/prepare.md)
   can pre-compile a query, including placeholder parameters. A
   prepared query can later on be executed through
   [EXECUTE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/execute.md), giving specific values for the parameters.
   [DEALLOCATE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/deallocate.md) deallocates a given query.