Create a dynamic table

POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/dynamic-tables?createMode=errorIfExists

Create a dynamic table, with standard create modifiers as query parameters. See the Dynamic Table component definition for what is required to be provided in the request body.

Request Params

• 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. |

Request Body

{"name"=>"<string>", "target_lag"=>{"type"=>"<string>"}, "warehouse"=>"<string>", "query"=>"<string>", "kind"=>"PERMANENT", "columns"=>[{"name"=>"<string>", "datatype"=>"<string>", "comment"=>"<string>"}, {"name"=>"<string>", "datatype"=>"<string>", "comment"=>"<string>"}], "refresh_mode"=>"INCREMENTAL", "initialize"=>"ON_SCHEDULE", "cluster_by"=>["<string>", "<string>"], "data_retention_time_in_days"=>"<integer>", "max_data_extension_time_in_days"=>"<integer>", "comment"=>"<string>", "created_on"=>"<dateTime>", "database_name"=>"<string>", "schema_name"=>"<string>", "rows"=>"<long>", "bytes"=>"<long>", "scheduling_state"=>"RUNNING", "automatic_clustering"=>"<boolean>", "owner"=>"<string>", "owner_role_type"=>"<string>", "budget"=>"<string>"}

HEADERS

RESPONSES

status: OK

{"status":"\u003cstring\u003e"}