# Treasure Data API Version: 3 ## Servers ``` https://api.treasuredata.com/v3 ``` ``` https://api.treasuredata.co.jp/v3 ``` ``` https://api.ap02.treasuredata.com/v3 ``` ``` https://api.eu01.treasuredata.com/v3 ``` ## Security ### ApiKeyAuth Type: http Scheme: TD1 ## Download OpenAPI description [Treasure Data API](https://api-docs.treasuredata.com/_bundle/apis/td-api-v3/public/openapi.yaml) ## Access Control - Policies ### get Access Control Policies - [GET /access_control/policies](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/getaccesscontrolpolicies.md): Retrieves a list of policies. ### Create an Access Control Policy - [POST /access_control/policies](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/createaccesscontrolpolicy.md): Creates a policy. ### Get an Access Control Policy - [GET /access_control/policies/{policy_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/getaccesscontrolpolicybyid.md): Retrieves information about the specified policy. ### Update an Access Control Policy - [PATCH /access_control/policies/{policy_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/updateaccesscontrolpolicybyid.md): Updates information related to a policy. ### Delete an Access Control Policy - [DELETE /access_control/policies/{policy_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/deleteaccesscontrolpolicybyid.md): Deletes a policy. ### get User Policies - [GET /access_control/users/{user_id}/policies](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/getaccesscontrolpoliciesbyuserid.md): Retrieves a list of policies by user. ### Update User Policies - [PATCH /access_control/users/{user_id}/policies](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/updateaccesscontrolpoliciesbyuserid.md): Updates policies by user ID. ### Attach a policy to a user. - [POST /access_control/users/{user_id}/policies/{policy_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/attachuserandpolicy.md): Attaches a policy to a user. ### Detach a Policy from a User - [DELETE /access_control/users/{user_id}/policies/{policy_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/detachuserandpolicy.md): Detaches a policy from a user. ### Attach - [POST /access_control/policies/{policy_id}/users/{user_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/attachpolicyanduser.md): This operation attaches a policy to a user. ### Detach - [DELETE /access_control/policies/{policy_id}/users/{user_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policies/detachpolicyanduser.md): Detaches a user from a policy. ## Access Control - Permissions ### get Access Control Permissions - [GET /access_control/permissions](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-permissions/getaccesscontrolpermissions.md): Retrieves a list of all permissions. ### Show Column Permissions - [GET /access_control/policies/{policy_id}/column_permissions](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-permissions/getcolumnpermissionbypolicyid.md): Shows column permission by policy ID. ### Update Column Permissions - [PATCH /access_control/policies/{policy_id}/column_permissions](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-permissions/updatecolumnpermissionbypolicyid.md): Updates column permissions by policy ID. ### Show Policy Permissions - [GET /access_control/policies/{policy_id}/permissions](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-permissions/gerpermissionbypolicyid.md): Shows policy permissions by policy ID. ### Update Policy Permissions - [PATCH /access_control/policies/{policy_id}/permissions](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-permissions/updatepermissionbypolicyid.md): Updates policy permissions. ### get Access Control Permissions for a User - [GET /access_control/users/{user_id}/permissions](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-permissions/getaccesscontroluserspermissions.md): Retrieves a list of all permissions for a User. ## Access Control - Users ### Get Access Control users. - [GET /access_control/users](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-users/getaccesscontrolusers.md): Retrieves a list of users and their permissions. ### Get Access Control User - [GET /access_control/users/{user_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-users/getaccesscontroluserbyid.md): Retrieves the specified user. ### Update Access Control User Permissions - [PATCH /access_control/users/{user_id}/permissions](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-users/updateaccesscontroluserpermissions.md): Updates a user's permissions. ### Get Policy users - [GET /access_control/policies/{policy_id}/users](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-users/getaccesscontrolpolicyusers.md): Retrieves a list of users attached to a policy. ### Update Policy Users - [PATCH /access_control/policies/{policy_id}/users](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-users/updateaccesscontrolpolicyusers.md): Updates users attached to a policy. ## Access Control - Policy Groups ### get Access Control Policy Groups - [GET /access_control/policy_groups](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policy-groups/getaccesscontrolpolicygroups.md): Retrieves a list of policy groups. ### Create an Access Control Policy Group - [POST /access_control/policy_groups](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policy-groups/createaccesscontrolpolicygroup.md): Creates a policy group. ### Get an Access Control Policy Group - [GET /access_control/policy_groups/{policy_group_id_or_taggable_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policy-groups/getaccesscontrolpolicygroupbyid.md): Retrieves information about the specified policy group. ### Update an Access Control Policy Group - [PATCH /access_control/policy_groups/{policy_group_id_or_taggable_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policy-groups/updateaccesscontrolpolicygroupbyid.md): Updates information related to a policy group. ### Delete an Access Control Policy Group - [DELETE /access_control/policy_groups/{policy_group_id_or_taggable_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policy-groups/deleteaccesscontrolpolicygroupbyid.md): Deletes a policy group. ### Get an Access Control Policy Group's Policies - [GET /access_control/policy_groups/{policy_group_id_or_taggable_name}/policies](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policy-groups/getaccesscontrolpolicygrouppoliciesbyid.md): Retrieves the list of the specified policy group's policies. ### Update an Access Control Policy Group's Policies - [PATCH /access_control/policy_groups/{policy_group_id_or_taggable_name}/policies](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/access-control-policy-groups/updateaccesscontrolpolicygrouppolicies.md): Updates the policies attached to a policy group. ## Accounts ### List accounts with encryption - [GET /account/list_encryption_accounts](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/accounts/listencriptionaccounts.md): Retrieves a list of accounts with encryption. ### List paying accounts - [GET /account/list_paying_accounts](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/accounts/listpayingaccounts.md): Retrieves a list of paying accounts. ### get account - [GET /account/show](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/accounts/getaccount.md): Retrieves an account. ### update encrypt start at - [PUT /account/{account_id}/encrypt_start_at](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/accounts/updateencryptstartat.md): Updates encrypt start at. ## Api Keys ### Get user's api-keys - [GET /user/apikey/list/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/api-keys/getapikeysbyuseremail.md): Returns an array of user's API keys. ### Create an api-key - [POST /user/apikey/add/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/api-keys/createapikeybyuseremail.md): Creates an API key. ### Remove an api-key - [POST /user/apikey/remove/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/api-keys/removeapikeybyuseremail.md): Removes the API key for a specified user. ## Bulk Imports ### Get bulk imports - [GET /bulk_import/list](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/getbulkimports.md): This operation lists bulk imports. ### Create bulk import - [POST /bulk_import/create/{bulk_import_name}/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/createbulkimport.md): Enables the bulk importing of data to the targeted database and table and stores it in the default resource pool. ### Get bulk import by name - [GET /bulk_import/show/{bulk_import_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/getbulkimportbyname.md): Shows the specified bulk import information. ### Delete bulk import - [POST /bulk_import/delete/{bulk_import_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/deletebulkimportbyname.md): Deletes the specified bulk import information. ### Freeze bulk import - [POST /bulk_import/freeze/{bulk_import_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/freezebulkimportbyname.md): Freezes the specified bulk import. ### Unfreeze bulk import - [POST /bulk_import/unfreeze/{bulk_import_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/unfreezebulkimportbyname.md): Unfreezes the specified bulk import. ### Perform bulk import - [POST /bulk_import/perform/{bulk_import_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/performbulkimportbyname.md): Executes a job to perform bulk import. ### Commit bulk import - [POST /bulk_import/commit/{bulk_import_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/commitbulkimportbyname.md): Commits the bulk import information having the specified name. ### Get bulk import error records - [GET /bulk_import/error_records/{bulk_import_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/getbulkimporterrorrecordsbyname.md): Retrieves bulk import error records by name. ### Upload bulk import part - [PUT /bulk_import/upload_part/{bulk_import_name}/{bulk_import_part_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/uploadbulkimportpart.md): Uploads the specified part of the specified bulk import. ### Get all bulk import parts - [GET /bulk_import/list_parts/{bulk_import_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/getallbulkimportparts.md): Retrieves a list of bulk import parts from a specified bulk import. ### Delete bulk import part - [POST /bulk_import/delete_part/{bulk_import_name}/{bulk_import_part_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/deletebulkimportpart.md): Deletes a specified part for specified bulk import. ### Delete all bulk import parts - [POST /bulk_import/delete_all_parts/{bulk_import_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-imports/deleteallbulkimportparts.md): Deletes all bulk import parts. ## Bulk Loads ### Bulk load guess - [POST /bulk_loads/guess](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/guessbulkload.md): Bulk load guess. ### Bulk load preview - [POST /bulk_loads/preview](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/previewbulkload.md) ### Create a bulk load session - [POST /bulk_loads](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/createbulkloadsession.md): Creates a bulk load session. ### Get bulk load sessions - [GET /bulk_loads](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/getbulkloadsessions.md): Retrieves a list of bulk load sessions. Optionally, filter by IDs or names. ### Get a bulk load session - [GET /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/getblkloadsessionbyname.md): Retrieves the bulk load session information for the name specified. ### Update bulk load session - [PUT /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/updatebulkloadsessionbyname.md): Updates a specified bulk load session. ### Delete bulk load session - [DELETE /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/deletebulkloadsessionbyname.md): Deletes the specified bulk load session. ### Run a bulk load session - [POST /bulk_loads/{bulk_load_session_name}/jobs](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/runbulkloadsessionbyname.md): Runs the specified bulk load session. ### Get bulk load session jobs - [GET /bulk_loads/{bulk_load_session_name}/jobs](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/getbulkloadsessionjobs.md): Retrieves a list of bulk load session jobs. ### Create a bulk load session - [POST /bulk_loads](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/createbulkloadsession.md): Creates a bulk load session. ### Get bulk load sessions - [GET /bulk_loads](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/getbulkloadsessions.md): Retrieves a list of bulk load sessions. Optionally, filter by IDs or names. ### Get a bulk load session - [GET /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/getblkloadsessionbyname.md): Retrieves the bulk load session information for the name specified. ### Update bulk load session - [PUT /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/updatebulkloadsessionbyname.md): Updates a specified bulk load session. ### Delete bulk load session - [DELETE /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/deletebulkloadsessionbyname.md): Deletes the specified bulk load session. ### Run a bulk load session - [POST /bulk_loads/{bulk_load_session_name}/jobs](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/runbulkloadsessionbyname.md): Runs the specified bulk load session. ## Bulk Load Sessions ### Create a bulk load session - [POST /bulk_loads](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/createbulkloadsession.md): Creates a bulk load session. ### Get bulk load sessions - [GET /bulk_loads](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/getbulkloadsessions.md): Retrieves a list of bulk load sessions. Optionally, filter by IDs or names. ### Get a bulk load session - [GET /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/getblkloadsessionbyname.md): Retrieves the bulk load session information for the name specified. ### Update bulk load session - [PUT /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/updatebulkloadsessionbyname.md): Updates a specified bulk load session. ### Delete bulk load session - [DELETE /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/deletebulkloadsessionbyname.md): Deletes the specified bulk load session. ### Run a bulk load session - [POST /bulk_loads/{bulk_load_session_name}/jobs](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-loads/runbulkloadsessionbyname.md): Runs the specified bulk load session. ### Create a bulk load session - [POST /bulk_loads](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/createbulkloadsession.md): Creates a bulk load session. ### Get bulk load sessions - [GET /bulk_loads](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/getbulkloadsessions.md): Retrieves a list of bulk load sessions. Optionally, filter by IDs or names. ### Get a bulk load session - [GET /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/getblkloadsessionbyname.md): Retrieves the bulk load session information for the name specified. ### Update bulk load session - [PUT /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/updatebulkloadsessionbyname.md): Updates a specified bulk load session. ### Delete bulk load session - [DELETE /bulk_loads/{bulk_load_session_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/deletebulkloadsessionbyname.md): Deletes the specified bulk load session. ### Run a bulk load session - [POST /bulk_loads/{bulk_load_session_name}/jobs](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/bulk-load-sessions/runbulkloadsessionbyname.md): Runs the specified bulk load session. ## Connections ### Get connections - [GET /result/list](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/connections/getconnections.md): Retrieves a list of connections. ### Create connection - [POST /result/create/{connection_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/connections/createconnection.md): Creates a connection. ### Delete connection - [POST /result/delete/{connection_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/connections/deleteconnection.md): Deletes a connection. ### Get connection id by name - [GET /connections/lookup](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/connections/getconnectionidbyname.md): Retrieves the specified connection. ### Validate connector config - [POST /connector_configs/validate_with_connection](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/connections/validateconnectorconfig.md): Validates a connector configuration. ### Validate streaming connector config - [POST /connector_configs/validate_with_streaming_connection](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/connections/validatestreamingconnectorconfig.md): Validates a streaming connector configuration. ## Databases ### Get databases - [GET /database/list](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/databases/getdatabases.md): Retrieves a list of databases. ### Get database - [GET /database/show/{database_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/databases/getdatabasebyname.md): Retrieves a specified database. ### Create database - [POST /database/create/{database_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/databases/createdatabase.md): Creates a database. ### Delete database - [POST /database/delete/{database_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/databases/deletedatabase.md): Deletes a specified database. ## Jobs ### Get jobs - [GET /job/list](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/getjobs.md): Retrieves a list of jobs. ### Get job - [GET /job/show/{job_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/getjobbyid.md): Retrieves a list of jobs with specified job id. ### Get job status by id - [GET /job/status/{job_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/getjobstatusbyid.md): Show the status information of the given job id at last execution as well as other related information. ### Get job status by domain_key - [GET /job/status_by_domain_key/{domain_key}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/getjobstatusbydomainkey.md): Checks the status of a job using the domain key. ### Get job statistics by id - [GET /job/statistics/{job_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/getjobstatisticsbyid.md): Show the statistics of the job, including records inserted. ### Create job - [POST /job/issue/{job_type}/{database_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/createjob.md): Creates a job of a given type under a specified database. ### kill job by id - [POST /job/kill/{job_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/killjobbyid.md): Stops a specified job ID. ### Set result export - [POST /job/result_export/{job_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/setresultexport.md): Sets the results of a specified job ID. ### Create export job - [POST /export/run/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/createexportjob.md): Creates an export job. ### Get job results - [GET /job/result/{job_id}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/jobs/getjobresults.md): Retrieves job results. ## Policy Group Tags ### Get the delegated admins of a policy group - [GET /policy_group_tags/{tag}/delegated_admins](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/policy-group-tags/getpolicygrouptagsdelegatedadmins.md): Returns a list of delegated admin user ids that manage a policy group. ### Update the delegated admins of a policy group - [PATCH /policy_group_tags/{tag}/delegated_admins](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/policy-group-tags/updatepolicygrouptagsdelegatedadmins.md): Tags a list of delegated admin user ids to manage a policy group. ### Get the users of a policy group - [GET /policy_group_tags/{tag}/users](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/policy-group-tags/getpolicygrouptagsusers.md): Returns a list of user ids that are tagged with a policy group. ### Update the users of a policy group - [PATCH /policy_group_tags/{tag}/users](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/policy-group-tags/updatepolicygrouptagsusers.md): Tags a list of user ids with a policy group. ## Schedules ### Get schedules - [GET /schedule/list](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/schedules/getschedules.md): Gets a list of schedules. ### Create schedule - [POST /schedule/create/{schedule_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/schedules/createschedule.md): Creates a schedule. ### Delete schedule - [POST /schedule/delete/{schedule_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/schedules/deleteschedulebyname.md): Deletes a specified schedule. ### Update schedule - [POST /schedule/update/{schedule_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/schedules/updateschedule.md): Updates a schedule. ### Run schedule - [POST /schedule/run/{schedule_name}/{schedule_time}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/schedules/runschedule.md): Schedules a run. ### Get execution history - [GET /schedule/history/{schedule_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/schedules/getscheduleexecutionhistorybyname.md): Gets a history of scheduled executions by name. ## SSO Settings ### Get SSO Setting - [GET /account/sso_setting](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/sso-settings/getssosettingby.md): Retrieves SSO setting. ### Create SSO Setting - [POST /account/sso_setting](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/sso-settings/createssosetting.md): Creates SSO setting. ### Update SSO Setting - [PUT /account/sso_setting](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/sso-settings/updatessosetting.md): Updates SSO setting. ### Delete SSO Setting - [DELETE /account/sso_setting](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/sso-settings/deletessosetting.md): Deletes SSO setting. ## Tables ### Get tables - [GET /table/list/{database_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/gettablesbydatabasename.md): Retrieves a list of tables according to database specified. ### Get table - [GET /table/show/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/gettablebydatabasenameandtablename.md): Shows a table according to specified database and table. ### Delete table - [POST /table/delete/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/deletetable.md): Deletes specified table. ### Create table with specified type - [POST /table/create/{database_name}/{table_name}/{table_type}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/createtablewithtabletype.md): Creates a table of a specified type. Currently only 'log' is supported as table_type. This endpoint supports creating tables with schema, options, and can copy properties from existing tables. Schema can include column descriptions in the format [name, type, alias, description]. ### Create table - [POST /table/create/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/createtable.md): Creates a table with default type 'log'. This endpoint offers the same functionality as the typed endpoint but without explicitly specifying the table type. Schema can include column descriptions in the format [name, type, alias, description]. ### Update table - [POST /table/update/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/updatetable.md): Updates a table. ### Rename table - [POST /table/rename/{database_name}/{current_table_name}/{new_table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/renametable.md): Renames a specified table. ### Swap tables - [POST /table/swap/{database_name}/{table_name_1}/{table_name_2}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/swaptables.md): Swaps specified tables. ### Tail table - [GET /table/tail/{database_name}/{table_name}{path_format}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/tailtable.md): Shows the last record in a table. ### Get table distribution - [GET /table/distribution/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/gettabledistribution.md): Retrieve a table distribution. ### Change database - [POST /table/change_database/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/changetabledatabase.md): Changes to the specified table database. ### Transfer table to a different account - [POST /table/transfer/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/transfertable.md): Transfer the specified table to a different account. (Limited Access) ### Append table schema - [POST /table/append-schema/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/appendtableschema.md): Appends the specified table schema. ### Update table schema - [POST /table/update-schema/{database_name}/{table_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/tables/updatetableschema.md): Updates the specified table schema. Schema can include column descriptions in the format [name, type, alias, description]. ## Users ### Authenticate - [POST /user/authenticate](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/authenticate.md): Authenticates the specified user. ### Get users - [GET /user/list](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/getusers.md): Retrieves a list of users. ### Get current user - [GET /user/show](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/getcurrentuser.md): Shows the current user. ### Delete user by email - [POST /user/remove/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/deleteuserbyemail.md): Deletes a user. ### Create user (with email/password) - [POST /user/add/{user_first_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/createuserwithemailandpassword.md): Creates a user. ### Create user (with SSO) - [POST /user/create_with_sso/{user_first_name}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/createuserwithemailandssoidentifier.md): Creates a user using an SSO identifier. ### Enforce SSO - [POST /user/enforce_sso/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/enforcessobyemail.md): Enforces SSO. ### Enable SSO - [POST /user/enable_sso/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/enablessobyemail.md): Enables SSO. ### Disable SSO - [POST /user/disable_sso/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/disablessobyemail.md): Disables SSO. ### Destroy super user session (for development and td-system-test) - [POST /user/destroy_superuser_session](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/destroysuperusersession.md): Destroys a superuser session. ### Promote a user to a delegated Admin - [POST /user/delegated_admin/add/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/promotedelegatedadmin.md): Promotes a user to a delegated admin. ### Demote a user from a delegated admin - [POST /user/delegated_admin/remove/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/demotedelegatedadmin.md): Demotes a user from a delegated admin. ### Change another user password (deprecated) - [POST /user/password/change/{user_email}](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/changeuserpasswordbyemail.md): Changes the specified user's password. ### Change user password (deprecated) - [POST /user/password/change](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/changeuserpassword.md): Changes a user's password. ### Authenticate - [POST /user/authenticate](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/authentication/authenticate.md): Authenticates the specified user. ## Authentication ### Authenticate - [POST /user/authenticate](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/users/authenticate.md): Authenticates the specified user. ### Authenticate - [POST /user/authenticate](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/authentication/authenticate.md): Authenticates the specified user. ## Data Connector Restrictions ### Get data connector restrictions - [GET /data_connector_restrictions](https://api-docs.treasuredata.com/apis/td-api-v3/public/openapi/data-connector-restrictions/getdataconnectorrestrictions.md): Returns an object of data connector restrictions