Datastores

Datastores define a destination for data loaded into a workspace by pipelines. The default datastore for a workspace is its own PostgreSQL database hosted by Meltano Cloud, but this can be changed at any time to another datastore with your own credentials (see our supported dataplugins of type LOADER).

Objects

Datastore

Path	JSON Type	Format	Description
`id`	`string`	Version 4 UUID	The datastore ID
`created`	`string`	ISO 8601 timestamp	The instant at which the datastore was created
`lastModified`	`string`	ISO 8601 timestamp	The instant at which the datastore was last modified
`name`	`string`		The datastore name
`dataPlugin`	`string`		Create / update with dataplugin `fullyQualifiedName`
`workspace`	`string`	Version 4 UUID	The datastore workspace `id`
`jdbcUrl`	`string`	JDBC URL	The datastore JDBC URL
`properties`	`object`	`Properties`	The datastore properties

Properties

For each setting s in the dataplugin settings:

Path	Type	Description
`s.name`	`s.kind`	Refer to `s.description`

Requests

View all datastores in a workspace

GET /api/workspaces/{workspace-id}/datastores

Returns the datastores in the workspace {workspace-id}.

Prerequisites

Workspace {workspace-id} must exist

Examples

cURL
Python (requests)

curl -H "Authorization: Bearer $ACCESS_TOKEN" 'https://app.matatika.com/api/workspaces/6911bc8c-c6ae-4581-b82c-d43aaa403d92/datastores' -i -X GET

import requests

url = "https://app.matatika.com/api/workspaces/6911bc8c-c6ae-4581-b82c-d43aaa403d92/datastores"

headers = {
  'Authorization': ACCESS_TOKEN
}

response = requests.request("GET", url, headers=headers)

print(response.text.encode('utf8'))

Response

200 OK

Datastore collection with HAL links.

{
  "_embedded" : {
    "datastores" : [ {
      "id" : "579889db-6c66-4231-9a2b-b8e8097dbe7e",
      "created" : "2026-04-23T13:07:12.072835",
      "lastModified" : "2026-04-23T13:07:12.072836",
      "name" : "Warehouse",
      "properties" : {
        "password" : "yxB2Il9J_g0xW9AfD_2Eg5oQjR",
        "dbname" : "nltnimw",
        "default_target_schema" : "analytics",
        "port" : "5432",
        "host" : "sharp-banana2.postgres.database.azure.com",
        "user" : "nltnimw"
      },
      "commands" : { },
      "dataPlugin" : "loaders/target-postgres--matatika",
      "dataPluginType" : "loader",
      "dataPluginLogoUrl" : "/assets/logos/loaders/postgres.png",
      "logoUrl" : "/assets/logos/loaders/postgres.png",
      "workspace" : "6911bc8c-c6ae-4581-b82c-d43aaa403d92",
      "jdbcUrl" : "jdbc:postgresql://sharp-banana2.postgres.database.azure.com:5432/nltnimw",
      "draft" : false,
      "managed" : true,
      "_links" : {
        "self" : {
          "href" : "https://app.matatika.com/api/datastores/579889db-6c66-4231-9a2b-b8e8097dbe7e"
        },
        "dataplugin" : {
          "href" : "https://app.matatika.com/api/dataplugins/c5c5897e-7a9a-4ab7-bef4-a3392eb7dbe8"
        }
      }
    } ]
  },
  "_links" : {
    "self" : {
      "href" : "https://app.matatika.com/api/workspaces/6911bc8c-c6ae-4581-b82c-d43aaa403d92/datastores?page=0&size=20"
    }
  },
  "page" : {
    "size" : 20,
    "totalElements" : 1,
    "totalPages" : 1,
    "number" : 0
  }
}

View a datastore

GET /api/datastores/{datastore-id}

Returns the datastore {datastore-id}.

Prerequisites

Datastore {datastore-id} must exist

Examples

cURL
Python (requests)

curl -H "Authorization: Bearer $ACCESS_TOKEN" 'https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb' -i -X GET

import requests

url = "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"

headers = {
  'Authorization': ACCESS_TOKEN
}

response = requests.request("GET", url, headers=headers)

print(response.text.encode('utf8'))

Response

200 OK

Datastore with HAL links.

{
  "id" : "2ce41208-7fe7-4cac-a054-00d5365033cb",
  "created" : "2026-04-23T13:08:44.931499",
  "lastModified" : "2026-04-23T13:08:49.893368",
  "name" : "Test datastore (updated)",
  "properties" : {
    "password" : "yxB2Il9J_g0xW9AfD_2Eg5oQjR",
    "dbname" : "nltnimw",
    "default_target_schema" : "analytics",
    "host" : "sharp-banana2.postgres.database.azure.com",
    "user" : "nltnimw"
  },
  "commands" : { },
  "dataPlugin" : "loaders/target-postgres--matatika",
  "dataPluginType" : "loader",
  "dataPluginLogoUrl" : "/assets/logos/loaders/postgres.png",
  "logoUrl" : "/assets/logos/loaders/postgres.png",
  "workspace" : "6911bc8c-c6ae-4581-b82c-d43aaa403d92",
  "jdbcUrl" : "jdbc:postgresql://sharp-banana2.postgres.database.azure.com:5432/nltnimw",
  "draft" : false,
  "managed" : false,
  "_links" : {
    "self" : {
      "href" : "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"
    },
    "update datastore" : {
      "href" : "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"
    },
    "delete datastore" : {
      "href" : "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"
    },
    "make-default" : {
      "href" : "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb/default"
    },
    "dataplugin" : {
      "href" : "https://app.matatika.com/api/dataplugins/c5c5897e-7a9a-4ab7-bef4-a3392eb7dbe8"
    }
  }
}

Set a datastore as the workspace default

PUT /api/datastores/{datastore-id}/default

Sets the datastore {datastore-id} as the workspace default.

Prerequisites

Datastore {datastore-id} must exist

Examples

cURL
Python (requests)

curl -H "Authorization: Bearer $ACCESS_TOKEN" 'https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb/default' -i -X PUT \
    -H 'Content-Type: application/json'

import requests

url = "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb/default"

headers = {
  'Authorization': ACCESS_TOKEN
}

response = requests.request("PUT", url, headers=headers)

print(response.text.encode('utf8'))

Response

200 OK

No response body provided.

Initialise a new datastore in a workspace

POST /api/workspaces/{workspace-id}/datastores

Initialises a new datastore in the workspace {workspace-id}.

Prerequisites

Workspace {workspace-id} must exist

Examples

cURL
Python (requests)

curl -H "Authorization: Bearer $ACCESS_TOKEN" 'https://app.matatika.com/api/workspaces/6911bc8c-c6ae-4581-b82c-d43aaa403d92/datastores' -i -X POST \
    -H 'Content-Type: application/json'

import requests

url = "https://app.matatika.com/api/workspaces/6911bc8c-c6ae-4581-b82c-d43aaa403d92/datastores"

headers = {
  'Authorization': ACCESS_TOKEN
}

response = requests.request("POST", url, headers=headers)

print(response.text.encode('utf8'))

Response

200 OK

Datastore with HAL links.

{
  "id" : "2ce41208-7fe7-4cac-a054-00d5365033cb",
  "created" : "2026-04-23T13:08:44.784244882",
  "lastModified" : "2026-04-23T13:08:44.784245282",
  "properties" : { },
  "commands" : { },
  "workspace" : "6911bc8c-c6ae-4581-b82c-d43aaa403d92",
  "draft" : false,
  "managed" : false,
  "_links" : {
    "self" : {
      "href" : "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"
    },
    "create datastore" : {
      "href" : "https://app.matatika.com/api/workspaces/6911bc8c-c6ae-4581-b82c-d43aaa403d92/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"
    }
  }
}

Create or update a datastore in a workspace

PUT /api/workspaces/{workspace-id}/datastores/{datastore-id}

Creates or updates the datastore {datastore-id} in the workspace {workspace-id}.

Prerequisites

Workspace {workspace-id} must exist

Body

Datastore resource.

{
  "name" : "Test datastore",
  "dataPlugin" : "loaders/target-postgres",
  "properties" : {
    "dbname" : "nltnimw",
    "default_target_schema" : "analytics",
    "user" : "nltnimw",
    "host" : "sharp-banana2.postgres.database.azure.com",
    "password" : "yxB2Il9J_g0xW9AfD_2Eg5oQjR"
  }
}

Examples

cURL
Python (requests)

curl -H "Authorization: Bearer $ACCESS_TOKEN" 'https://app.matatika.com/api/workspaces/6911bc8c-c6ae-4581-b82c-d43aaa403d92/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb' -i -X PUT \
    -H 'Content-Type: application/json' \
    -d '{
  "name" : "Test datastore",
  "dataPlugin" : "loaders/target-postgres",
  "properties" : {
    "dbname" : "nltnimw",
    "default_target_schema" : "analytics",
    "user" : "nltnimw",
    "host" : "sharp-banana2.postgres.database.azure.com",
    "password" : "yxB2Il9J_g0xW9AfD_2Eg5oQjR"
  }
}'

import requests

url = "https://app.matatika.com/api/workspaces/6911bc8c-c6ae-4581-b82c-d43aaa403d92/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"

data = {
  "name" : "Test datastore",
  "dataPlugin" : "loaders/target-postgres",
  "properties" : {
    "dbname" : "nltnimw",
    "default_target_schema" : "analytics",
    "user" : "nltnimw",
    "host" : "sharp-banana2.postgres.database.azure.com",
    "password" : "yxB2Il9J_g0xW9AfD_2Eg5oQjR"
  }
}
headers = {
  'Authorization': ACCESS_TOKEN
}

response = requests.request("PUT", url, headers=headers, data=data)

print(response.text.encode('utf8'))

Response

200 OK / 201 Created

Datastore with HAL links.

{
  "id" : "2ce41208-7fe7-4cac-a054-00d5365033cb",
  "created" : "2026-04-23T13:08:44.931499125",
  "lastModified" : "2026-04-23T13:08:44.931500125",
  "name" : "Test datastore",
  "properties" : {
    "dbname" : "nltnimw",
    "default_target_schema" : "analytics",
    "user" : "nltnimw",
    "host" : "sharp-banana2.postgres.database.azure.com",
    "password" : "yxB2Il9J_g0xW9AfD_2Eg5oQjR"
  },
  "commands" : { },
  "dataPlugin" : "loaders/target-postgres--matatika",
  "dataPluginType" : "loader",
  "dataPluginLogoUrl" : "/assets/logos/loaders/postgres.png",
  "logoUrl" : "/assets/logos/loaders/postgres.png",
  "workspace" : "6911bc8c-c6ae-4581-b82c-d43aaa403d92",
  "jdbcUrl" : "jdbc:postgresql://sharp-banana2.postgres.database.azure.com:5432/nltnimw",
  "draft" : false,
  "managed" : false,
  "_links" : {
    "self" : {
      "href" : "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"
    },
    "update datastore" : {
      "href" : "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"
    },
    "delete datastore" : {
      "href" : "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"
    },
    "make-default" : {
      "href" : "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb/default"
    },
    "dataplugin" : {
      "href" : "https://app.matatika.com/api/dataplugins/c5c5897e-7a9a-4ab7-bef4-a3392eb7dbe8"
    }
  }
}

Delete a datastore

DELETE /api/datastores/{datastore-id}

Deletes the datastore {datastore-id}.

Prerequisites

Datastore {datastore-id} must exist

Examples

cURL
Python (requests)

curl -H "Authorization: Bearer $ACCESS_TOKEN" 'https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb' -i -X DELETE

import requests

url = "https://app.matatika.com/api/datastores/2ce41208-7fe7-4cac-a054-00d5365033cb"

headers = {
  'Authorization': ACCESS_TOKEN
}

response = requests.request("DELETE", url, headers=headers)

print(response.text.encode('utf8'))

Response

204 No Content

No response body provided.

Objects​

Datastore​

Properties​

Requests​

View all datastores in a workspace​

Prerequisites​

Examples

Response​

View a datastore​

Prerequisites​

Examples

Response​

Set a datastore as the workspace default​

Prerequisites​

Examples

Response​

Initialise a new datastore in a workspace​

Prerequisites​

Examples

Response​

Create or update a datastore in a workspace​

Prerequisites​

Body​

Examples

Response​

Delete a datastore​

Prerequisites​

Examples

Response​

See Also​

Objects

Datastore

Properties

Requests

View all datastores in a workspace

Prerequisites

Response

View a datastore

Prerequisites

Response

Set a datastore as the workspace default

Prerequisites

Response

Initialise a new datastore in a workspace

Prerequisites

Response

Create or update a datastore in a workspace

Prerequisites

Body

Response

Delete a datastore

Prerequisites

Response

See Also