Imports API

Import an Oracle dataset into a Greenplum/Postgres schema

POST /api/schemas/:schema_id/imports

Parameters

Name Description
dataset_id Id of the source dataset
to_table Table name of the destination table
truncate True/false: truncate into existing table (only if new_table is false)
new_table True/false: if true, import into new table. Otherwise, import into existing table.
sample_count Maximum number of rows to import

Request

Headers

Host: example.org
Content-Type: application/x-www-form-urlencoded
Cookie: _session_id=S25KOVpuRVF0WnFIL3J4Q1BMWHhGQkVBZko3eHpjaGhFOUxod055L0U5cmVkZFdReXZtZzRpUmhUTVplM3B4a3hIYmsrRDd2d1d0a1FkOVVoSXFtM0x0Tzk5eUdrL3Z1SVJ0TmVoWXgzV3JRSUpNNld3R3g1TUZ5ZGZIU0RiVVR3UjlaZUtTYWlnWm9nTGdHTUVlR2JvMFZldk5OQm9vL1orb2FvUFhjeTJtcXFBK2RXMHg3NGxZQXpHakNTc29IQjZ1dXg1ejFaYy9nK29tQk5DeWY3MEdNVUsxbDYyc1B2Q2I2OFJDTlp4QXNFRFlNdjBZOC9vTkVKMExzZ2tVWnVlbjlLc1owVU8rR2J2T1ptNWpqeENkY0MxR3ZseTdMRVpsOFY2U1p5bzhTUmhUenVFL20xL29yamZUbHRQRjdSVWNUQmF6eEJpWWc0L1lsNFFIK29vSlhyVi91M3dRTURHYlVWNGh2MEowQVBZNXRhbmxkNDluQ2NrazVBQno5dHpJZVBTSnVTNVBKUVN0b1RWYUlEeEhxbDBIUjJqMjExU3Fzc2dOQ1g2WT0tLXpqRGw2SkdLc3FFbjBIZndIVTY4YUE9PQ%3D%3D--896caedafc8c8eb62f9bba95da28bf0c7806110e

Route

POST /api/schemas/1000006/imports

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/"99914b932bd37a50b983c5e7c90ae93b"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=NnBIRjFlTVdtcUtnYjMzeE5DQXlKZk5ycUR3ZWpWRmtsWm9DTVNnTFVuN1dUUlJwY095Y3ZlN04yMjdqMWsyV2ZEMUN4Vm1OSnp5SUwvKytSWlBGU0F0U1ZQZVlZNkRWazJodzRMNUpMTGtJSHI5K3lCamM3TTlMUkJXazV5WTB5K1Y5dTFyWmFORm95WE9JNVpZc2hxY2J6YjdrUUlYYW40R2x0OFl0TUZFQ1RDaUZrN3JBVXpFN2NFSUJEaEFvNEN5SUZybm9RcHNFeEFJd3haeGNwTHhGaFBWOTgrdXZjNWxNY1JKUFltQ3pGOHlLLzN6S3hqT3Vld21KcWdKaS8vazVxNnZocDAwSTlFYXJ4cUJ6NUJPc0krdkFTTC9aMk9zYkUzUmM2Y1VUNGpoekJyVi9zWWx6OTNrME94dit1SllGWUNRQnBJSjlNdlZPZmwxSGdtcVQvUU5pOVB1QTdSdnlJeTM2WXpUNFVSM0dhTEFFNDB4TkFGVlZUOW5wZjN6VkVNWjM4b3MvMWVvQjJJeHRJVGZOVzFSYXR5eWtOa0krdmUzeHZPMUV3WVYva2h3alJ5M3FLMGF4ZmhMTC0tNjhGSk5XcFh5eGlYbXR6VTdMdnZiQT09--3146a0f2055fad7b4115979400f17798fe60c804; path=/; HttpOnly
X-Request-Id: 703b6051-062d-4f90-9533-25ea9112139a
X-Runtime: 0.130947
Content-Length: 2

Status

201 Created

Body