List dynamic tables
GET {{baseUrl}}/api/v2/databases/:database/schemas/:schema/dynamic-tables?like=<string>&startsWith=<string>&showLimit=<integer>&fromName=<string>&deep=<boolean>
Lists the dynamic tables under the database and schema.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
like | string | Query parameter to filter the command output by resource name. Uses case-insensitive pattern matching, with support for SQL wildcard characters. | |
startsWith | string | Query parameter to filter the command output based on the string of characters that appear at the beginning of the object name. Uses case-sensitive pattern matching. | |
showLimit | string | Query parameter to limit the maximum number of rows returned by a command. | |
fromName | string | Query parameter to enable fetching rows only following the first row whose object name matches the specified string. Case-sensitive and does not have to be the full name. | |
deep | string | Optionally includes dependency information of the dynamic table. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Accept | string |
RESPONSES
status: OK
[{"name":"\u003cstring\u003e","target_lag":{"type":"\u003cstring\u003e"},"warehouse":"\u003cstring\u003e","query":"\u003cstring\u003e","kind":"PERMANENT","columns":[{"name":"\u003cstring\u003e","datatype":"\u003cstring\u003e","comment":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","datatype":"\u003cstring\u003e","comment":"\u003cstring\u003e"}],"refresh_mode":"FULL","initialize":"ON_CREATE","cluster_by":["\u003cstring\u003e","\u003cstring\u003e"],"data_retention_time_in_days":"\u003cinteger\u003e","max_data_extension_time_in_days":"\u003cinteger\u003e","comment":"\u003cstring\u003e","created_on":"\u003cdateTime\u003e","database_name":"\u003cstring\u003e","schema_name":"\u003cstring\u003e","rows":"\u003clong\u003e","bytes":"\u003clong\u003e","scheduling_state":"SUSPENDED","automatic_clustering":"\u003cboolean\u003e","owner":"\u003cstring\u003e","owner_role_type":"\u003cstring\u003e","budget":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","target_lag":{"type":"\u003cstring\u003e"},"warehouse":"\u003cstring\u003e","query":"\u003cstring\u003e","kind":"PERMANENT","columns":[{"name":"\u003cstring\u003e","datatype":"\u003cstring\u003e","comment":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","datatype":"\u003cstring\u003e","comment":"\u003cstring\u003e"}],"refresh_mode":"FULL","initialize":"ON_SCHEDULE","cluster_by":["\u003cstring\u003e","\u003cstring\u003e"],"data_retention_time_in_days":"\u003cinteger\u003e","max_data_extension_time_in_days":"\u003cinteger\u003e","comment":"\u003cstring\u003e","created_on":"\u003cdateTime\u003e","database_name":"\u003cstring\u003e","schema_name":"\u003cstring\u003e","rows":"\u003clong\u003e","bytes":"\u003clong\u003e","scheduling_state":"RUNNING","automatic_clustering":"\u003cboolean\u003e","owner":"\u003cstring\u003e","owner_role_type":"\u003cstring\u003e","budget":"\u003cstring\u003e"}]