Schemas API

Get a specific schema

GET /api/schemas/:id

Parameters

Name	Description
id	Greenplum schema id
workspace_id	Retrieve the correct DataSourceAccount if Schema is scoped inside a Workspace (optional)

Request

Headers

Host: example.org
Cookie: _session_id=NDNWbWRaZzdYSkVNUFczcVZvc29sZmxBOURmd2orTk40OCtXNGVwaEg0Snp3Y3Q4ZU5nMTJQbXJRbzIxN1FhN1IwdUVCWjFqc0l2cnN3dkZidjlXVjQvWmNSQmpxemhpVFV3SzVGS0NZNXJCTmNLNjVKS0JVd01IUkpIVDNsU1AwRGV1aHlFTitDSUgyR1JLVEIvbDdCeDQ5cUdQZEc0WXB2M3VNMUl0ZWR3VVVWamFNU1hybEhQY20yRW1BemVPdGJ6OGcxNnd4WWFPWEp1REdBNXVCRlFGUy84bzF1YkR2c2cxM091RTRPNmxlSGZhblBZQUhwZ3pFYTY2bkVyaGxCYmNqLzltVE55Z3hLcjJWa3UxWjh0L0V3NTNNS09TWUhCK3pteUtMbm10amlNRk1vNThvK2RkTHBWUWs3Wi8xckFHRitYdkxmbHA4N2JLYVJUcWRhOGk4cEJQUnBrUmJTQU1ueXk2QkZYSHhSZ2U0YzhsSy9HWDluaEJFMGRYMWdKd0FRcURuWGI0VWI5ME8vZHFQUVRjK3p1b0RvWGYySCtlSUQzZjg0QT0tLVU5REF6ay9WM1R0blhQNGowZW01OUE9PQ%3D%3D--9d9a84752b459750ebe02afba5e9e9aa5d421d4a

Route

GET /api/schemas/1000006

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/"5b22578dc82414cd650c9595990d47b8"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=Ym9wNVBxVTRlVHNkZzZrcUI4RnJ3M3dIaVRVbFlJS0RPYm9hTDhWRmdiWHZmbnlYL0dyZTBwRGpQb1JRaVAzbHhVWE12WUpNa2NpV21pZGpoUjhURTRSUmpUakxzQWFlTjVNVVlmSkRIQVhpZHJwL3h5TVhDazRaM0lERWZXSDg3ZEZvTW1Kd2lrUHlxVWdmZll0YWVjbVRSNUpPNHVXcmJpSFhiQ0hrS3VWek44cm1FOFdTckFWcVJ5K1JJVW5Kc0lBek1nZUF5WkFqcmYwbTlHK2x2R1ZqVzNOeWhIOG5oZTBTWGdjLzVNZ2ZoTUVDWWFIcjJUYytrWGwvVzFSTzhnZ2tzc2c5azc2eFdkYVhmQ0dHVTE1czNqMHh5Qno4cDY3UUg0K0haMlRtQWpQN0dWLytWWjJWNmhUOFpnZmlIODdtUWFxOEttVlNNRFFJaHAxR2ZxUEFsTHdHZUZTeWpaQ1lmSW56VVdaKy8rM1R6NXJSbm9yeUdrVmtYdU9MUGsxeVIxK0Y3K0FUbU9EejluVjFjZ2VZMWlHaEM3THUrUmFZZEhBcUZrak1kQi9TRUZGVzJsRUhvMzQ5MmpyUy0tK1M0UjUxeFd3ZkJrMXJYRUVGamh6dz09--27b8725789efe5c9079408a24112bcf449a4c530; path=/; HttpOnly
X-Request-Id: d7c17006-cc49-43d2-bf0c-4d11d334f7c6
X-Runtime: 0.071148
Content-Length: 1480

Status

200 OK

Body

{"response":{"id":1000006,"name":"default","dataset_count":0,"refreshed_at":"2019-04-03T22:09:24Z","entity_type":"gpdb_schema","is_deleted":null,"stale":false,"has_credentials":true,"database":{"id":1000001,"name":"default","data_source":{"id":1000002,"name":"Owners","entity_type":"gpdb_data_source","is_deleted":false,"shared":false,"owner_id":1000006,"version":"9.1.2 - FactoryVersion","is_hawq":null,"state":"online","public":false,"host":"data_source.emc.com","port":5000,"ssl":false,"online":true,"db_name":"postgres","description":null,"db_username":"username","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},"tags":[],"schema_blacklist":[],"data_source_provider":"Greenplum Database","complete_json":true},"entity_type":"gpdb_database","complete_json":true},"complete_json":true}}