Create a table using the templates specified in staged files

POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/{{name}}:using_template?createMode=errorIfExists&copyGrants=false&query=<string>

Create a table using template.

Request Params

KeyDatatypeRequiredDescription
createModestringQuery parameter allowing support for different modes of resource creation. Possible values include:
  • errorIfExists: Throws an error if you try to create a resource that already exists.
  • orReplace: Automatically replaces the existing resource with the current one.
  • ifNotExists: Creates a new resource when an alter is requested for a non-existent resource. | | copyGrants | boolean | | Query parameter to enable copy grants when creating the object. | | query | string | | (Required) The SQL query that uses INFER_SCHEMA on staged files to set the column definitions for the new table. |

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

{&quot;status&quot;:&quot;\u003cstring\u003e&quot;}