Clone dynamic table

POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/dynamic-tables/{{name}}:clone?createMode=errorIfExists&copyGrants=false&targetDatabase=ye$tmz&targetSchema=ye$tmz

Create a new dynamic table by cloning from the specified resource

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. | | targetDatabase | string | | Database of the newly created dynamic table. Defaults to the source table's database. | | targetSchema | string | | Schema of the newly created dynamic table. Defaults to the source table's schema. |

Request Body

{"name"=>"<string>", "target_lag"=>{"type"=>"<string>"}, "warehouse"=>"<string>", "point_of_time"=>{"point_of_time_type"=>"<string>", "reference"=>"<string>"}}

HEADERS

KeyDatatypeRequiredDescription
Content-Typestring
Acceptstring

RESPONSES

status: OK

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