Chorus Views API

Create a Chorus View

POST /api/chorus_views

Parameters

Name	Description
source_object_id	Id of the source dataset/workfile
source_object_type	'dataset' or 'workfile'
object_name	Name of the Chorus View to be created
schema_id	Id of the schema to run the view in
workspace_id	Id of the workspace the Chorus View belongs to
query	SQL statement for the Chorus View, must start with SELECT or WITH

Request

Headers

Host: example.org
Content-Type: application/x-www-form-urlencoded
Cookie: _session_id=Q0FWMHZYYzh2QVMzQXM5aHk3ZjBSVWlPMERlbTBiRnVPNHNNWmxHajNhcisrZHZ0NG5kN2daOUJIVkVkL3ZsbVV2ZG1Gd2RFKytLcGl4WGtBcFVFaVB1ZHkwV1NiSG9KcVRSL3laNWdHWE9VTmQrOHJHb2p1OURzVDZCSmE0anJJWVk3WUtwOGFQbld2MzRwa1RLZk0xZGxlc203YjBwZEJkdGUxYkFGdERNaGRYZzBEVDF0OU8xWnNEdFRERG5ielRIRFAvUWhBVDBXSFJ5K2JoNWVJdzFKQ01HTmRxQ0grOE1Bb3NHRXpUWjIwVG5EUEUrZTRGS3MxaktrYjNtYnJCbUtYZUZWS0d6bEJRUk9sWjdXWTUvelZiWmxkaTBLM29Kd0dnQnNtaS9NangrTzUwRkc0cFBPZU00UDJMSUtEbzlUcUxKbXR0NFdieDhSOURvQVlCbkFRd3RLU2p2YkhtQVp4WHQwaXZ3WFErdHRpSlBrNi9RVEtIcXJ3ejdUam1uZmRPMHBGaXEyZ0syYnF4NVNjVjBNZFA3czZ6Q3JFSi9WbFBvUjVFaz0tLXY4elJRQmxtNmJuYWsvMzFrd1NpNmc9PQ%3D%3D--0a01b615c4f8eabcad00005ad76f72ce823a3041

Route

POST /api/chorus_views

Body

Response

Headers

X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
X-Content-Type-Options: nosniff
Content-Type: application/json; charset=utf-8
ETag: W/"d1dfbbc96ac77f702c98d9a99e91b9d5"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=VVJiTUJ0YW95bjVMeFp1TzRSbnVSNnpOVFd4d2NtQnlVb3FWaFlXUFVieXZXdXRqVFpqYktmcXlDeUxVWTFjV3F1WTZ3MDVMYUN3bkhtbDJJaG9iSlpETk9pV0xqUlZmN0ZSai9zVllZcWtjQ3Rtd2tTNTliZnZ4RkI0Ulpsa0crK0N2NDhJalg2Vm1oRFBGL2tEbXFTZjh5YzlFUEJuRVgvZENHZUdvbFZwZWR3SVIxNnQvdkxDbmpvbUxtVVBKbEhwc2J3clNtc1lWeVNKdlZkU0pUY0NwUmNjUzJpZ2RmbmxJMW5CdG5Qdks1c3dDWGNQemRXMzhOemdOcHIzMEpObGE4blp2M0FtTWtnMmRaQWdRMkNUTEljVnNuOGFhRCsraUFDWVlaNCtZWVplcTNqUW53eU9oMEszRmpLbTB1UHBJeW1DY2RFNktNQkprRTJsUCthQldHdjNabW1tWC9OQ1pzMVJLTllYa2N4TERpT3M2NU1ieTNkdFFSY0NRTng3Z2Vod0puQ0NuY1RDV3ZROXpaeXdDSUxKWUVpU09wWU1haGw5cXdQOTVlbGZMVXRpd1RnYXFGUFlIYkVXTC0tM3YzNnFaL1ZqWTQ5YlN3RTQ3bGJhQT09--112f43d2c9429e6c51a8238c13a123eaf473d42c; path=/; HttpOnly
X-Request-Id: 047f0f47-d94f-474f-a4b5-e3472b916eda
X-Runtime: 0.440615
Content-Length: 3314

Status

201 Created

Body

{"response":{"recent_comments":[],"comment_count":0,"id":1000032,"object_name":"MyChorusView","schema":{"id":1000006,"name":"default","dataset_count":0,"refreshed_at":"2019-04-03T22:09:24Z","entity_type":"gpdb_schema","is_deleted":null,"stale":false,"database":{"id":1000001,"name":"default","data_source":{"id":1000002,"name":"Owners","entity_type":"gpdb_data_source","is_deleted":null,"shared":false,"owner_id":1000006,"version":"9.1.2 - FactoryVersion","is_hawq":null,"state":"online","public":false},"entity_type":"gpdb_database","complete_json":true},"complete_json":true},"entity_type":"dataset","entity_subtype":"CHORUS_VIEW","stale":false,"stale_at":null,"is_deleted":false,"associated_workspaces":[],"workspace":{"id":1000008,"name":"Public","is_deleted":null,"entity_type":"workspace","archived":false,"public":true,"archived_at":null,"summary":"searchquery","permission":["admin","create_workflow"],"datasets_count":13,"members_count":2,"workfiles_count":17,"insights_count":1,"recent_insights_count":1,"recent_comments_count":9,"has_recent_comments":true,"has_milestones":true,"workspace_stage":{"default":true,"id":1000000,"name":"Define","position":0,"description_long":"Define the essential components of the project.","description_short":"Define the two essential components of a machine learning project. What business problem are we solving? How should the solution change the way our business operates? Locate or acquire all necessary data.","complete_json":true},"workspace_stage_id":1000000,"archiver":null,"image":{"original":"","icon":"","entity_type":"image","complete_json":true},"tags":[],"has_added_member":false,"has_added_workfile":true,"has_added_sandbox":true,"has_changed_settings":false,"sandbox_info":{"id":1000006,"name":"default","dataset_count":0,"refreshed_at":"2019-04-03T22:09:24Z","entity_type":"gpdb_schema","is_deleted":null,"stale":false,"database":{"id":1000001,"name":"default","data_source":{"id":1000002,"name":"Owners","entity_type":"gpdb_data_source","is_deleted":null,"shared":false,"owner_id":1000006,"version":"9.1.2 - FactoryVersion","is_hawq":null,"state":"online","public":false},"entity_type":"gpdb_database","complete_json":true},"complete_json":true},"show_sandbox_datasets":true,"owner":{"id":1000006,"username":"owner","first_name":"searchquery","last_name":"User_1","image":{"original":"/paperclip/users/images/001/000/006/original/User.png?1554329366","icon":"/paperclip/users/images/001/000/006/icon/User.png?1554329366","entity_type":"image","complete_json":true},"is_deleted":null,"auth_method":"internal","ldap_group_id":null,"user_type":"analytics_developer","entity_type":"user","using_default_image":false,"active_license":true,"is_siteadmin":false,"roles":["data_admin"],"email":"chorususer282295@alpinenow.com","title":"Chief Data Scientist","dept":"Corporation Corp., Inc.","notes":"One of our top performers","admin":false,"subscribed_to_emails":true,"tags":[],"deactivated_at":null,"complete_json":true},"is_member":true,"is_project":true,"project_status":"on_track","project_status_reason":null,"milestone_count":3,"milestone_completed_count":0,"project_target_date":"2019-04-28T00:00:00Z","complete_json":true},"has_credentials":true,"tableau_workbooks":[],"tags":[],"object_type":"CHORUS_VIEW","query":"select 1;","complete_json":true}}