Matia

https://docs.matia.io
Admin
Matia is a unified DataOps platform that combines ETL, Reverse ETL, Data Observability, and a Data...
Tokens:109,322
Snippets:1,906
Trust Score:6.8
Update:2 months ago
Show doc for...
Tokens:
Raw
### CURL Request Example

Source: https://docs.matia.io/docs/matia-api/get-the-details-of-a-specific-tag

Example command to retrieve tag details using cURL.

```bash
curl -L 'https://api.matia.io/v1/tags/:id' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>'
```

--------------------------------

### Run Sync via cURL

Source: https://docs.matia.io/docs/matia-api/run-a-sync-for-a-specific-integration

Example command to trigger an integration sync using cURL.

```bash
curl -L -X POST 'https://api.matia.io/v1/integrations/:id/run' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>'
```

--------------------------------

### List all users with cURL

Source: https://docs.matia.io/docs/matia-api/list-all-users

Example request using cURL to fetch the user list.

```bash
curl -L 'https://api.matia.io/v1/users' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>'
```

--------------------------------

### Create Integration via cURL

Source: https://docs.matia.io/docs/matia-api/create-a-new-integration

Example command to create a new integration using the cURL utility.

```bash
curl -L 'https://api.matia.io/v1/integrations' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>' \
-d '{
  "destinationId": "string",
  "destinationSchema": "string",
  "replicationFrequency": "string",
  "onSchemaUpdate": "string",
  "enabled": true,
  "sourceConfig": {
    "type": "postgres",
    "name": "string",
    "authMethod": "string",
    "connection": {
      "username": "string",
      "password": "string",
      "hostname": "string",
      "port": 0,
      "database": "string",
      "slot": "string",
      "publication": "string"
    },
    "connectionType": "string",
    "owners": [
      "string"
    ]
  },
  "sourceSettings": {
    "max_clients": 0,
    "incremental_mode": "string"
  }
}'
```

--------------------------------

### List all tags using cURL

Source: https://docs.matia.io/docs/matia-api/list-all-tags

Example command to list all tags using the cURL utility.

```bash
curl -L 'https://api.matia.io/v1/tags' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>'
```

--------------------------------

### CURL Request Example

Source: https://docs.matia.io/docs/matia-api/edit-specific-tag-by-id

Example command to update a tag using cURL.

```bash
curl -L -X PUT 'https://api.matia.io/v1/tags/:id' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>' \
-d '{
  "name": "string",
  "description": "string",
  "owner": "string"
}'
```

--------------------------------

### Request Body Example

Source: https://docs.matia.io/docs/matia-api/create-a-tag

The JSON payload required for the POST request.

```json
{
  "name": "string",
  "description": "string",
  "owner": "string"
}
```

--------------------------------

### Example MongoDB Document Structure

Source: https://docs.matia.io/docs/connectors/etl/mongodb/setup-guide

Sample document used to illustrate the difference between Dynamic and Static schema modes.

```json
{
    "_id": 1,
    "foo": "2",
    "nested": {
      "bar": 3
    }
}
```

--------------------------------

### Update Integration via cURL

Source: https://docs.matia.io/docs/matia-api/update-integration

Example command to update an integration status using cURL.

```bash
curl -L -X PATCH 'https://api.matia.io/v1/integrations/:id' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>' \
-d '{
  "paused": true
}'
```

--------------------------------

### Create a Tag via cURL

Source: https://docs.matia.io/docs/matia-api/create-a-tag

Example request using cURL to create a tag with the required headers and body.

```bash
curl -L 'https://api.matia.io/v1/tags' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>' \
-d '{
  "name": "string",
  "description": "string",
  "owner": "string"
}'
```

--------------------------------

### Retrieve Integration Run Status via cURL

Source: https://docs.matia.io/docs/matia-api/get-the-status-of-a-specific-integration-run

Example command to fetch integration run status using cURL.

```bash
curl -L 'https://docs.matia.io/integrations/:id/runs/:runId' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>'
```

--------------------------------

### List audit logs via cURL

Source: https://docs.matia.io/docs/matia-api/list-audit-logs

Example request to retrieve audit logs using the x-api-key header.

```bash
curl -L 'https://api.matia.io/v1/audit-logs' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>'
```

--------------------------------

### Success response schema

Source: https://docs.matia.io/docs/matia-api/list-all-users

Example JSON structure for a successful 200 OK response.

```json
{
  "code": "string",
  "message": "string",
  "data": {
    "items": [
      {
        "id": "string",
        "email": "string",
        "name": "string",
        "createdAt": "2024-07-29T15:51:28.071Z"
      }
    ]
  }
}
```

--------------------------------

### Snowflake Setup Script

Source: https://docs.matia.io/docs/connectors/data-warehouses/snowflake/setup-guide

SQL script to create the required Snowflake entities for Matia. Ensure you replace placeholders with your specific configuration.

```sql
    --  
    -- Snowflake Destination Setup Script  
    --  
    begin;  
  
    -- Create variables for:  
    -- User / password / role / warehouse / database (use UPPERCASE)  
    set role_name = 'MATIA_ETL_ROLE';  
    set user_name = 'MATIA_ETL_USER';  
    -- Remove this line if you're using key-pair authentication  
    set user_password = '{PLEASE SET A PASSWORD}';  
    set warehouse_name = 'MATIA_ETL_WAREHOUSE';  
    set database_name = '{Provide the database to store the output data}';  
  
    -- Change role to securityadmin for user / role steps  
    use role securityadmin;  
  
    -- Create role for Matia  
    create role if not exists identifier($role_name);  
    grant role identifier($role_name) to role SYSADMIN;  
  
    -- Create a user for Matia -  
    -- NOTE! Depending on the authentication method remove one of the following 2 commands  
  
    -- -- For key-pair authentication use the following command  
    create user if not exists identifier($user_name)  
    rsa_public_key = <PUBLIC_KEY> -- e.g randomandomKeyExample89012345keyDATA6789exampleKEYabcdanotherLineOfKeyDataToSimulateTheFormatAndLengthUsedInRealKeys=  
    default_role = $role_name  
    default_warehouse = $warehouse_name;  
  
    -- -- For password authentication use the following command  
    create user if not exists identifier($user_name)  
    TYPE = LEGACY_SERVICE  
    password = $user_password  
    default_role = $role_name  
    default_warehouse = $warehouse_name;  
  
    grant role identifier($role_name) to user identifier($user_name);  
  
    -- Set binary_input_format to BASE64  
    ALTER USER identifier($user_name) SET BINARY_INPUT_FORMAT = 'BASE64';  
  
    -- Change role to sysadmin for warehouse / database steps  
    use role sysadmin;  
  
    -- Create a warehouse for Matia  
    create warehouse if not exists identifier($warehouse_name)  
    warehouse_size = xsmall  
    warehouse_type = standard  
    auto_suspend = 60  
    auto_resume = true  
    initially_suspended = true  
    MIN_CLUSTER_COUNT = 1 -- recommended, remove if not on enterprise  
    MAX_CLUSTER_COUNT = 4 -- recommended, remove if not on enterprise  
    COMMENT = 'Matia ETL warehouse';  
  
    -- Create database for Matia  
    create database if not exists identifier($database_name);  
  
    -- Grant Matia role access to warehouse  
    grant USAGE  
    on warehouse identifier($warehouse_name)  
            to role identifier($role_name);  
  
    -- Grant Matia access to database  
    grant CREATE SCHEMA, MONITOR, USAGE  
    on database identifier($database_name)  
            to role identifier($role_name);  
  
    -- Change role to ACCOUNTADMIN for STORAGE INTEGRATION support (only needed for Snowflake on GCP)  
    use role ACCOUNTADMIN;  
    grant CREATE INTEGRATION on account to role identifier($role_name);  
    use role sysadmin;  
  
    commit;
```

--------------------------------

### Example Data Format

Source: https://docs.matia.io/docs/connectors/etl/webhook/setup-guide

The raw JSON structure used to demonstrate how Matia processes incoming webhook data.

```json
{
  "foo": 1,
  "nested": {
    "bar": 2
  }
}
```

--------------------------------

### Create Productboard Connection Request

Source: https://docs.matia.io/docs/connectors/etl/productboard/api-configuration

Use this POST request to initialize a new Productboard connection in the Matia platform.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "productboard",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/learn-upon/api-configuration

Creates a new LearnUpon connection configuration.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the LearnUpon service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - Must be set to "learn_upon"
- **config** (object) - Required - Configuration parameters for the LearnUpon service

### Authorization
- **clientIdAndSecret**
```

--------------------------------

### GET https://api.matia.io/v1/users

Source: https://docs.matia.io/docs/matia-api/list-all-users

Retrieves a list of all users registered in the system.

```APIDOC
## GET https://api.matia.io/v1/users

### Description
Retrieves a list of all users registered in the system.

### Method
GET

### Endpoint
https://api.matia.io/v1/users

### Authorization
- **x-api-key** (header) - Required - API key for authentication.

### Response
#### Success Response (200)
- **code** (string) - Status code.
- **message** (string) - Success message.
- **data** (object) - Container for user items.
  - **items** (array) - List of user objects.
    - **id** (string) - User ID.
    - **email** (string) - User email address.
    - **name** (string) - User name.
    - **createdAt** (string) - ISO 8601 date-time string.

#### Response Example
{
  "code": "string",
  "message": "string",
  "data": {
    "items": [
      {
        "id": "string",
        "email": "string",
        "name": "string",
        "createdAt": "2024-07-29T15:51:28.071Z"
      }
    ]
  }
}

#### Error Response (400)
- **code** (string) - Error code.
- **message** (string) - Error description.
```

--------------------------------

### GET https://api.matia.io/v1/tags

Source: https://docs.matia.io/docs/matia-api/list-all-tags

Retrieves a list of all tags available in the system.

```APIDOC
## GET https://api.matia.io/v1/tags

### Description
List all tags available in the Matia API.

### Method
GET

### Endpoint
https://api.matia.io/v1/tags

### Authorization
- **x-api-key** (header) - Required

### Response
#### Success Response (200)
- **code** (string) - Status code
- **data** (object) - Response data containing items
- **items** (array) - List of tag objects
  - **id** (string) - Tag ID
  - **name** (string) - Tag name
  - **description** (string) - Tag description
  - **owner** (string) - Tag owner
  - **origin** (string) - Tag origin
  - **createdAt** (string) - Creation timestamp
  - **lastUpdatedAt** (string) - Last update timestamp

#### Response Example
{
  "code": "string",
  "data": {
    "items": [
      {
        "id": "string",
        "name": "string",
        "description": "string",
        "owner": "string",
        "origin": "string",
        "createdAt": "2024-07-29T15:51:28.071Z",
        "lastUpdatedAt": "2024-07-29T15:51:28.071Z"
      }
    ]
  }
}
```

--------------------------------

### Create LaunchDarkly Connection Request

Source: https://docs.matia.io/docs/connectors/etl/launchdarkly/api-configuration

Use this POST request to initialize a new LaunchDarkly connection in the Matia platform.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "launchdarkly",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### Generate Dbt documentation files

Source: https://docs.matia.io/docs/connectors/orchestration-tools/dbt-core/setup-guide

Command to create the required catalog.json and manifest.json files in the target directory.

```bash
dbt docs generate
```

--------------------------------

### GET https://api.matia.io/v1/tags/:id

Source: https://docs.matia.io/docs/matia-api/get-the-details-of-a-specific-tag

Retrieves the details of a specific tag by its ID.

```APIDOC
## GET https://api.matia.io/v1/tags/:id

### Description
Retrieves the details of a specific tag by its ID.

### Method
GET

### Endpoint
https://api.matia.io/v1/tags/:id

### Parameters
#### Path Parameters
- **id** (string) - Required - ID of the tag

### Authorization
- **x-api-key** (apiKey) - Header

### Response
#### Success Response (200)
- **code** (string)
- **data** (object)
  - **id** (string)
  - **name** (string)
  - **description** (string)
  - **owner** (string)
  - **origin** (string)
  - **createdAt** (string) - date-time
  - **lastUpdatedAt** (string) - date-time
  - **taggedResources** (object[])

#### Response Example
{
  "code": "string",
  "data": {
    "id": "string",
    "name": "string",
    "description": "string",
    "owner": "string",
    "origin": "string",
    "createdAt": "2024-07-29T15:51:28.071Z",
    "lastUpdatedAt": "2024-07-29T15:51:28.071Z",
    "taggedResources": [
      {
        "id": "string"
      }
    ]
  }
}

#### Error Response (400)
- **code** (string)
- **message** (string) - Required
```

--------------------------------

### Configure Zendesk v2 Connection

Source: https://docs.matia.io/docs/connectors/etl/zendesk-v2/api-configuration

Use this POST request to initialize a connection to the Zendesk v2 service.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "zendesk_v2",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### Delete Integration via cURL

Source: https://docs.matia.io/docs/matia-api/delete-integration

Example request to delete an integration using cURL.

```bash
curl -L -X DELETE 'https://api.matia.io/v1/integrations/:id' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>'
```

--------------------------------

### Create Quickbooks Connection Request

Source: https://docs.matia.io/docs/connectors/etl/quickbooks/api-configuration

Use this POST request to initialize a new Quickbooks connection in the Matia platform.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "quickbooks",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### Delete Relation via cURL

Source: https://docs.matia.io/docs/matia-api/delete-a-relation-between-a-tag-and-a-resource

Example request using cURL to delete a relation.

```bash
curl -L -X DELETE 'https://api.matia.io/v1/tags/:id/relation' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>' \
-d '{
  "resourceId": "string",
  "resourceType": "string"
}'
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/quickbox/api-configuration

Creates a new connection for the Quickbox service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the Quickbox service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service name, must be "quickbox".
- **config** (object) - Required - Configuration parameters for the connection.

### Request Example
{
  "service": "quickbox",
  "config": {}
}

### Authorization
- **accessToken**
```

--------------------------------

### Edit Asset via cURL

Source: https://docs.matia.io/docs/matia-api/edit-an-existing-asset

Example command to update an asset using the PATCH method.

```bash
curl -L -X PATCH 'https://docs.matia.io/assets/:id' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>'
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/launchdarkly/api-configuration

Creates a new connection to the LaunchDarkly service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection to the LaunchDarkly service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service name, must be "launchdarkly".
- **config** (object) - Required - Configuration parameters for the LaunchDarkly connection.

### Authorization
- **accessToken** - Required
```

--------------------------------

### Configure MySQL Server Settings

Source: https://docs.matia.io/docs/connectors/etl/mysql-v2/setup-guide

Required configuration for enabling ROW format binary log replication.

```ini
[mysqld]
binlog-format=ROW
log-bin=mysql-binlog
server-id=123456789
expire-logs-days=7
log-slave-updates=1
```

--------------------------------

### Create Relation via cURL

Source: https://docs.matia.io/docs/matia-api/create-a-relation-between-a-tag-and-a-resource

Example request using cURL to create a tag-resource relation.

```bash
curl -L 'https://api.matia.io/v1/tags/:id/relation' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>' \
-d '{
  "resourceId": "string",
  "resourceType": "string",
  "taggedBy": "string"
}'
```

--------------------------------

### GET https://api.matia.io/v1/audit-logs

Source: https://docs.matia.io/docs/matia-api/list-audit-logs

Retrieves a list of audit logs based on provided query parameters.

```APIDOC
## GET https://api.matia.io/v1/audit-logs

### Description
List audit logs from the system. This endpoint supports pagination, sorting, and time-based filtering.

### Method
GET

### Endpoint
https://api.matia.io/v1/audit-logs

### Parameters
#### Query Parameters
- **limit** (integer) - Optional - Max number of audit logs to return (<= 100). Default: 20.
- **offset** (integer) - Optional - Number of audit logs to skip for pagination. Default: 0.
- **sortBy** (string) - Optional - The field to sort by (timestamp). Default: timestamp.
- **sortOrder** (string) - Optional - The direction of the sort (asc, desc). Default: desc.
- **startAt** (date-time) - Optional - Filter for audit logs AFTER this timestamp (inclusive).
- **endAt** (date-time) - Optional - Filter for audit logs BEFORE this timestamp (exclusive).

### Response
#### Success Response (200)
- **code** (string) - Response code.
- **data** (object) - Contains totalItems and items array.
- **totalItems** (integer) - Total number of audit logs matching the filters.
- **items** (object[]) - List of audit log entries.

#### Response Example
{
  "code": "string",
  "data": {
    "totalItems": 1250,
    "items": [
      {
        "id": "550e8400-e29b-41d4-a716-446655440000",
        "timestamp": "2025-12-27T16:20:00Z",
        "event": "User logged in",
        "actor": {
          "type": "user",
          "email": "user@email.com"
        },
        "context": {
          "ipAddress": "192.168.1.1",
          "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7)..."
        }
      }
    ]
  }
}
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/productboard/api-configuration

Creates a new connection to the Productboard service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection to the Productboard service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service name, set to "productboard".
- **config** (object) - Required - Configuration parameters for the connection.

### Request Example
{
  "service": "productboard",
  "config": {}
}

### Authorization
- **accessToken**
```

--------------------------------

### GET https://api.matia.io/v1/integrations/:id/runs/:runId

Source: https://docs.matia.io/docs/matia-api/get-the-status-of-a-specific-integration-run

Retrieves the status and metadata for a specific integration run.

```APIDOC
## GET https://api.matia.io/v1/integrations/:id/runs/:runId

### Description
Get the status of a specific integration run.

### Method
GET

### Endpoint
https://api.matia.io/v1/integrations/:id/runs/:runId

### Parameters
#### Path Parameters
- **id** (string) - Required - The ID of the integration run

### Response
#### Success Response (200)
- **code** (string) - Status code
- **message** (string) - Response message
- **data** (object) - Integration run details
  - **id** (string) - Run ID
  - **integrationId** (string) - Integration ID
  - **status** (string) - Current status
  - **startTime** (string) - Start time (date-time)
  - **endTime** (string) - End time (date-time)
  - **committedRecords** (integer) - Number of committed records
  - **emittedRecords** (integer) - Number of emitted records
  - **size** (integer) - Size of the run

#### Response Example
{
  "code": "string",
  "message": "string",
  "data": {
    "id": "string",
    "integrationId": "string",
    "status": "string",
    "startTime": "2024-07-29T15:51:28.071Z",
    "endTime": "2024-07-29T15:51:28.071Z",
    "committedRecords": 0,
    "emittedRecords": 0,
    "size": 0
  }
}
```

--------------------------------

### Create Stackadapt Connection Request

Source: https://docs.matia.io/docs/connectors/etl/stackadapt/api-configuration

Use this POST request to initialize a new Stackadapt connection in the Matia platform.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "stackadapt",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### Create GitHub Connection Request

Source: https://docs.matia.io/docs/connectors/etl/github/api-configuration

Use this endpoint to initialize a new GitHub connection. Replace the config object with your specific authentication and sync parameters.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "github",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### Delete tag via cURL

Source: https://docs.matia.io/docs/matia-api/delete-a-tag-by-id

Example request to delete a tag using the cURL command-line tool.

```bash
curl -L -X DELETE 'https://docs.matia.io/tags/:id' \
-H 'Accept: application/json' \
-H 'x-api-key: <x-api-key>'
```

--------------------------------

### Create LearnUpon Connection Request

Source: https://docs.matia.io/docs/connectors/etl/learn-upon/api-configuration

The endpoint and payload structure required to initialize a new LearnUpon connection.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "learn_upon",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### HTTP Request Payload Format

Source: https://docs.matia.io/docs/connectors/reverse-etl/http-request/setup-guide

Example of the JSON object structure sent to the configured endpoint for each record.

```json
{
    "user_id": "123456",
    "email": "user@example.com",
    "last_active": "2023-06-15T14:30:00Z",
    "subscription_status": "active"
}
```

--------------------------------

### Configure incident.io connection request

Source: https://docs.matia.io/docs/connectors/etl/incident-io/api-configuration

Use this POST request to initialize a connection to incident.io with the required configuration parameters.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "incident_io",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/quickbooks/api-configuration

Establishes a new connection to the Quickbooks service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection to the Quickbooks service using the specified configuration.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - Must be set to "quickbooks"
- **config** (object) - Required - Configuration parameters for the Quickbooks connection

### Request Example
{
  "service": "quickbooks",
  "config": {}
}
```

--------------------------------

### Create Audit Schema and Grant Permissions

Source: https://docs.matia.io/docs/connectors/etl/databricks/setup-guide

SQL commands to initialize the audit schema and assign necessary privileges to the service user.

```sql
CREATE SCHEMA IF NOT EXISTS MATIA_AUDIT_RETL;  
  
-- For personal access tokens, use an email address:  
GRANT USE SCHEMA, SELECT, CREATE TABLE, MODIFY ON SCHEMA [your_default_catalog].MATIA_AUDIT_RETL TO `user_you_plan_use_with_pat@yourcompany.com`;
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/sftp/api-configuration

Creates a new SFTP connection configuration.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the SFTP service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - Must be set to "sftp"
- **config** (object) - Required - Configuration parameters for the SFTP connection

### Authorization
- passwordOrKeyPair
- ssh
```

--------------------------------

### Configure Snowflake resources for Matia

Source: https://docs.matia.io/docs/connectors/etl/snowflake/setup-guide

Execute these SQL commands in your Snowflake account to create the necessary roles, warehouse, user, and permissions. Ensure you replace placeholders like '<strong, unique password>' and database/schema names before running.

```sql
CREATE ROLE IF NOT EXISTS MATIA_RETL_ROLE;  
  
-- Ensure the sysadmin role inherits any privileges the Matia role is granted. Note that this does not grant sysadmin privileges to the matia role  
GRANT ROLE MATIA_RETL_ROLE TO ROLE SYSADMIN;  
  
-- Create a warehouse for the Matia role, optimizing for cost over performance  
CREATE WAREHOUSE IF NOT EXISTS MATIA_WAREHOUSE WITH WAREHOUSE_SIZE = XSMALL AUTO_SUSPEND = 60 AUTO_RESUME = TRUE INITIALLY_SUSPENDED = FALSE;  
GRANT USAGE ON WAREHOUSE MATIA_WAREHOUSE TO ROLE MATIA_RETL_ROLE;  
GRANT OPERATE ON WAREHOUSE MATIA_WAREHOUSE TO ROLE MATIA_RETL_ROLE;  
GRANT MONITOR ON WAREHOUSE MATIA_WAREHOUSE TO ROLE MATIA_RETL_ROLE;  
  
-- Create the matia user  
-- Do not set DEFAULT_WORKSPACE, this will impact which tables are visible to MATIA_RETL  
CREATE USER IF NOT EXISTS MATIA_RETL WITH DEFAULT_ROLE = MATIA_RETL_ROLE TYPE = LEGACY_SERVICE DEFAULT_WAREHOUSE = MATIA_WAREHOUSE PASSWORD = '<strong, unique password>';  
ALTER USER MATIA_RETL SET PREVENT_UNLOAD_TO_INLINE_URL = FALSE;  
GRANT ROLE MATIA_RETL_ROLE TO USER MATIA_RETL;  
  
-- Let the matia user read the data you want to sync  
GRANT USAGE ON DATABASE "<your database>" TO ROLE MATIA_RETL_ROLE;  
GRANT USAGE ON SCHEMA "<your database>"."<your schema>" TO ROLE MATIA_RETL_ROLE;  
GRANT SELECT ON ALL TABLES IN SCHEMA "<your database>"."<your schema>" TO ROLE MATIA_RETL_ROLE;  
GRANT SELECT ON FUTURE TABLES IN SCHEMA "<your database>"."<your schema>" TO ROLE MATIA_RETL_ROLE;  
GRANT SELECT ON ALL VIEWS IN SCHEMA "<your database>"."<your schema>" TO ROLE MATIA_RETL_ROLE;  
GRANT SELECT ON FUTURE VIEWS IN SCHEMA "<your database>"."<your schema>" TO ROLE MATIA_RETL_ROLE;  
GRANT USAGE ON ALL FUNCTIONS IN SCHEMA "<your database>"."<your schema>" TO ROLE MATIA_RETL_ROLE;  
GRANT USAGE ON FUTURE FUNCTIONS IN SCHEMA "<your database>"."<your schema>" TO ROLE MATIA_RETL_ROLE;  
  
--  Create a private bookkeeping database where Matia stores sync state,  
--  perform unloads, and keep Warehouse Writeback logs  
  
CREATE DATABASE IF NOT EXISTS "MATIA_AUDIT";  
GRANT ALL PRIVILEGES ON DATABASE "MATIA_AUDIT" TO ROLE MATIA_RETL_ROLE;  
CREATE SCHEMA IF NOT EXISTS "MATIA_AUDIT"."RETL";  
GRANT ALL PRIVILEGES ON SCHEMA "MATIA_AUDIT"."RETL" TO ROLE MATIA_RETL_ROLE;  
GRANT CREATE STAGE ON SCHEMA "MATIA_AUDIT"."RETL" TO ROLE MATIA_RETL_ROLE;
```

--------------------------------

### Create ClickUp Connection Request

Source: https://docs.matia.io/docs/connectors/etl/clickup/api-configuration

Use this endpoint to initialize a new ClickUp connection within the Matia platform.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "clickup",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### Create logical replication slot

Source: https://docs.matia.io/docs/connectors/etl/postgres/setup-guide

Initializes a replication slot used to track database changes.

```sql
SELECT pg_create_logical_replication_slot('name_of_your_slot', 'pgoutput')  
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/google-search-console/api-configuration

Creates a new connection to Google Search Console by providing the service name and configuration parameters.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the Google Search Console service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - Must be set to "google_search_console"
- **config** (object) - Required - Configuration parameters for the connection

### Authorization
- **oAuth**
```

--------------------------------

### POST https://api.matia.io/v1/destinations

Source: https://docs.matia.io/docs/connectors/reverse-etl/mixpanel/api-configuration

Creates a new Mixpanel destination configuration.

```APIDOC
## POST https://api.matia.io/v1/destinations

### Description
Creates a new destination configuration for Mixpanel.

### Method
POST

### Endpoint
https://api.matia.io/v1/destinations

### Request Body
- **service** (string) - Required - The service name, must be "mixpanel".
- **config** (object) - Required - Configuration parameters for the Mixpanel service.

### Request Example
{
  "service": "mixpanel",
  "config": {}
}
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/google-cloud-storage-source/api-configuration

Creates a new connection for the Google Cloud Storage source.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the Google Cloud Storage source.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - Must be set to "google_cloud_storage_source"
- **config** (object) - Required - Configuration parameters for the Google Cloud Storage source

### Authorization
- **serviceAccount** - Required
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/salesforce/api-configuration

Creates a new Salesforce connection by sending a configuration object to the connections endpoint.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection to the Salesforce service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - Must be set to "salesforce"
- **config** (object) - Required - Configuration parameters for the Salesforce connection

### Authorization
- **oAuth**
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/mysql-legacy/api-configuration

Creates a new connection for the mysql_legacy service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection instance for the mysql_legacy service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - Must be set to "mysql_legacy"
- **config** (object) - Required - Configuration parameters for the connection

### Authorization
- **Authentication methods**: direct, ssh
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/stackadapt/api-configuration

Creates a new connection for the Stackadapt service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection to the Stackadapt service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service name, must be "stackadapt".
- **config** (object) - Required - Configuration parameters for the connection.

### Authorization
- **accessToken** - Required
```

--------------------------------

### Create Marketo Connection Request

Source: https://docs.matia.io/docs/connectors/etl/marketo/api-configuration

Use this POST request to initialize a new Marketo connection in the Matia platform.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "marketo",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/greenhouse/api-configuration

Creates a new Greenhouse connection.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the Greenhouse service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The name of the service, which must be "greenhouse".
- **config** (object) - Required - Configuration parameters for the Greenhouse connection.

### Request Example
{
  "service": "greenhouse",
  "config": {}
}
```

--------------------------------

### Create Google Play Connection Request

Source: https://docs.matia.io/docs/connectors/etl/google-play/api-configuration

Use this endpoint to initialize a new Google Play connection.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "google_play",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/front/api-configuration

Creates a new connection for the Front service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the Front service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service name, set to "front".
- **config** (object) - Required - Configuration parameters for the Front service.

### Request Example
{
  "service": "front",
  "config": {}
}

### Authorization
- oAuth
- accessToken
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/kustomer/api-configuration

Creates a new connection to the Kustomer service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection to the Kustomer service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service name, which must be "kustomer".
- **config** (object) - Required - Configuration parameters for the Kustomer connection.

### Authorization
- **accessToken** - Required
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/google-drive/api-configuration

Creates a new connection to Google Drive.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection to the Google Drive service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - Must be set to "google_drive"
- **config** (object) - Required - Configuration parameters for the Google Drive connection

### Authorization
- **serviceAccount**
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/zendesk-v2/api-configuration

Creates a new connection to the Zendesk v2 service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the Zendesk v2 service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service identifier, must be "zendesk_v2".
- **config** (object) - Required - Configuration parameters for the Zendesk connection.

### Request Example
{
  "service": "zendesk_v2",
  "config": {}
}
```

--------------------------------

### POST https://api.matia.io/v1/destinations

Source: https://docs.matia.io/docs/connectors/data-warehouses/google-cloud-storage/api-configuration

Creates a new destination for Google Cloud Storage.

```APIDOC
## POST https://api.matia.io/v1/destinations

### Description
Creates a new destination configuration for Google Cloud Storage.

### Method
POST

### Endpoint
https://api.matia.io/v1/destinations

### Request Body
- **service** (string) - Required - Must be set to "google-cloud-storage"
- **config** (object) - Required - Configuration parameters for the storage destination

### Request Example
{
  "service": "google-cloud-storage",
  "config": {}
}
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/skilljar/api-configuration

Creates a new connection for the Skilljar service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the Skilljar service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service name, which must be "skilljar".
- **config** (object) - Required - Configuration parameters for the Skilljar connection.

### Request Example
{
  "service": "skilljar",
  "config": {}
}

### Authorization
- **accessToken** - Required
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/clickup/api-configuration

Creates a new connection to the ClickUp service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection to the ClickUp service by providing the service name and configuration parameters.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The name of the service, which must be "clickup".
- **config** (object) - Required - Configuration parameters for the ClickUp connection.

### Authorization
- **accessToken** - Required
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/apple-app-store/api-configuration

Creates a new connection to the Apple App Store service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the Apple App Store service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - Must be "apple_app_store"
- **config** (object) - Required - Configuration parameters for the Apple App Store connection

### Authorization
- **accessToken**
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/app-lovin/api-configuration

Creates a new connection for the App Lovin service.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection to the App Lovin service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service name, set to "app_lovin".
- **config** (object) - Required - Configuration parameters for the App Lovin connection.

### Request Example
{
  "service": "app_lovin",
  "config": {}
}

### Authorization
- **accessToken** - Required
```

--------------------------------

### Create Snapchat Connection Request

Source: https://docs.matia.io/docs/connectors/etl/snapchat/api-configuration

Use this POST request to initialize a new Snapchat connection within the Matia platform.

```http
POST https://api.matia.io/v1/connections
```

```json
{
  "service": "snapchat",
  "config": {
    // Configuration parameters
  }
}
```

--------------------------------

### POST https://api.matia.io/v1/connections

Source: https://docs.matia.io/docs/connectors/etl/kato/api-configuration

Creates a new Kato service connection.

```APIDOC
## POST https://api.matia.io/v1/connections

### Description
Creates a new connection for the Kato service.

### Method
POST

### Endpoint
https://api.matia.io/v1/connections

### Request Body
- **service** (string) - Required - The service name, must be "kato".
- **config** (object) - Required - Configuration parameters for the Kato service.

### Request Example
{
  "service": "kato",
  "config": {}
}

### Authorization
- **accessToken**
```
Tokens:
Raw