curl --request PUT \
  --url https://api.usedatabrain.com/api/v2/data-app/datamarts \
  --header 'Authorization: Bearer dbn_live_abc123...' \
  --header 'Content-Type: application/json' \
  --data '{
    "datamartName": "demo-sales-default-1",
    "tableList": [
      {
        "schemaName": "databrain_dev2",
        "name": "demo_sales",
        "clientColumn": "client id",
        "isHide": false,
        "columns": [
          {
            "name": "client id",
            "alias": "id",
            "isHide": true
          },
          {
            "name": "client name",
            "alias": "name",
            "isHide": true,
            "defaultSort": "ASC"
          },
          {
            "name": "profit",
            "alias": "profit",
            "allowAggregate": true,
            "defaultAggregation": "SUM"
          }
        ]
      }
    ]
  }'

curl --request PUT \
  --url https://api.usedatabrain.com/api/v2/data-app/datamarts \
  --header 'Authorization: Bearer dbn_live_abc123...' \
  --header 'Content-Type: application/json' \
  --data '{
    "datamartName": "sales-analytics",
    "tenancySettings": {
      "tenancyLevel": "TABLE",
      "clientColumnType": "STRING",
      "schemaName": "public",
      "tableName": "clients",
      "tableClientNameColumn": "client_name",
      "tablePrimaryKeyColumn": "id"
    }
  }'

curl --request PUT \
  --url https://api.usedatabrain.com/api/v2/data-app/datamarts \
  --header 'Authorization: Bearer dbn_live_abc123...' \
  --header 'Content-Type: application/json' \
  --data '{
    "datamartName": "sales-analytics",
    "tenancySettings": {
      "tenancyLevel": "MULTI_DATABASE",
      "primaryDatabase": "core_analytics"
    }
  }'

curl --request PUT \
  --url https://api.usedatabrain.com/api/v2/data-app/datamarts \
  --header 'Authorization: Bearer dbn_live_abc123...' \
  --header 'Content-Type: application/json' \
  --data '{
    "datamartName": "sales-analytics",
    "tableList": [
      {
        "schemaName": "public",
        "name": "orders",
        "clientColumn": "tenant_id",
        "isHide": false,
        "columns": [
          {"name": "order_id", "alias": "id", "isHide": false},
          {"name": "customer_id", "isHide": false}
        ]
      }
    ],
    "tenancySettings": {
      "tenancyLevel": "TABLE",
      "clientColumnType": "NUMBER",
      "schemaName": "public",
      "tableName": "client_mapping",
      "tableClientNameColumn": "client_id",
      "tablePrimaryKeyColumn": "id"
    },
    "relationships": [
      {
        "parentTableName": "orders",
        "parentColumnName": "customer_id",
        "childTableName": "customers",
        "childColumnName": "id",
        "relationshipName": "orders_to_customers",
        "cardinality": "ManyToOne",
        "join": "LEFT JOIN"
      }
    ]
  }'

curl --request PUT \
  --url https://api.usedatabrain.com/api/v2/data-app/datamarts \
  --header 'Authorization: Bearer dbn_live_abc123...' \
  --header 'Content-Type: application/json' \
  --data '{
    "datamartName": "sales-analytics",
    "relationships": [
      {
        "parentTableName": "orders",
        "parentColumnName": "customer_id",
        "childTableName": "customers",
        "childColumnName": "id",
        "relationshipName": "orders_to_customers",
        "cardinality": "ManyToOne",
        "join": "LEFT JOIN"
      }
    ]
  }'

curl --request PUT \
  --url https://api.usedatabrain.com/api/v2/data-app/datamarts \
  --header 'Authorization: Bearer dbn_live_abc123...' \
  --header 'Content-Type: application/json' \
  --data '{
    "datamartName": "sales-analytics",
    "tableList": [
      {
        "schemaName": "public",
        "name": "orders",
        "label": "Customer Orders",
        "columns": [
          {
            "name": "order_id",
            "alias": "id",
            "label": "Order ID"
          },
          {
            "name": "quantity",
            "label": "Quantity"
          },
          {
            "name": "unit_price",
            "alias": "total_revenue",
            "label": "Total Revenue",
            "isCustomColumn": true,
            "sql": "quantity * unit_price"
          },
          {
            "name": "order_date",
            "alias": "order_year",
            "label": "Order Year",
            "isCustomColumn": true,
            "sql": "EXTRACT(YEAR FROM order_date)"
          },
          {
            "name": "created_at",
            "label": "Created At",
            "isApplyTimezone": true
          }
        ]
      }
    ]
  }'

const response = await fetch('https://api.usedatabrain.com/api/v2/data-app/datamarts', {
  method: 'PUT',
  headers: {
    'Authorization': 'Bearer dbn_live_abc123...',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({
    datamartName: 'sales-analytics',
    tableList: [
      {
        schemaName: 'public',
        name: 'orders',
        label: 'Customer Orders',
        clientColumn: 'tenant_id',
        columns: [
          { name: 'order_id', alias: 'id', label: 'Order ID' },
          { name: 'customer_id', label: 'Customer' },
          { name: 'order_date', alias: 'date', label: 'Order Date' }
        ]
      }
    ]
  })
});

const result = await response.json();

if (result.error) {
  console.error('Update failed:', result.error.message);
} else {
  console.log('Datamart updated:', result.id);
}

import requests

response = requests.put(
    'https://api.usedatabrain.com/api/v2/data-app/datamarts',
    headers={
        'Authorization': 'Bearer dbn_live_abc123...',
        'Content-Type': 'application/json'
    },
    json={
        'datamartName': 'sales-analytics',
        'tableList': [
            {
                'schemaName': 'public',
                'name': 'orders',
                'label': 'Customer Orders',
                'clientColumn': 'tenant_id',
                'columns': [
                    {'name': 'order_id', 'alias': 'id', 'label': 'Order ID'},
                    {'name': 'customer_id', 'label': 'Customer'}
                ]
            }
        ],
        'tenancySettings': {
            'tenancyLevel': 'TABLE',
            'clientColumnType': 'STRING',
            'schemaName': 'public',
            'tableName': 'client_mapping',
            'tableClientNameColumn': 'client_id',
            'tablePrimaryKeyColumn': 'id'
        },
        'relationships': [
            {
                'parentTableName': 'orders',
                'parentColumnName': 'customer_id',
                'childTableName': 'customers',
                'childColumnName': 'id',
                'relationshipName': 'orders_to_customers',
                'cardinality': 'ManyToOne',
                'join': 'LEFT JOIN'
            }
        ]
    }
)

result = response.json()

if result.get('error'):
    print(f"Update failed: {result['error']['message']}")
else:
    print(f"Datamart updated: {result['id']}")

require 'net/http'
require 'json'

uri = URI('https://api.usedatabrain.com/api/v2/data-app/datamarts')
http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = true

request = Net::HTTP::Put.new(uri)
request['Authorization'] = 'Bearer dbn_live_abc123...'
request['Content-Type'] = 'application/json'
request.body = {
  datamartName: 'sales-analytics',
  tableList: [
    {
      schemaName: 'public',
      name: 'orders',
      label: 'Customer Orders',
      columns: [
        { name: 'order_id', alias: 'id', label: 'Order ID' },
        { name: 'customer_id', label: 'Customer' }
      ]
    }
  ]
}.to_json

response = http.request(request)
result = JSON.parse(response.body)

if result['error']
  puts "Update failed: #{result['error']['message']}"
else
  puts "Datamart updated: #{result['id']}"
end

package main

import (
    "bytes"
    "encoding/json"
    "fmt"
    "net/http"
)

type UpdateDatamartRequest struct {
    DatamartName    string          `json:"datamartName"`
    TableList       []TableInfo     `json:"tableList,omitempty"`
    TenancySettings *TenancySettings `json:"tenancySettings,omitempty"`
}

type TableInfo struct {
    SchemaName string       `json:"schemaName,omitempty"`
    Name       string       `json:"name"`
    Label      string       `json:"label,omitempty"`
    Columns    []ColumnInfo `json:"columns"`
}

type ColumnInfo struct {
    Name   string `json:"name"`
    Alias  string `json:"alias,omitempty"`
    Label  string `json:"label,omitempty"`
    IsHide bool   `json:"isHide,omitempty"`
}

type TenancySettings struct {
    TenancyLevel           string `json:"tenancyLevel,omitempty"`
    ClientColumnType       string `json:"clientColumnType,omitempty"`
    SchemaName             string `json:"schemaName,omitempty"`
    TableName              string `json:"tableName,omitempty"`
    TableClientNameColumn  string `json:"tableClientNameColumn,omitempty"`
    TablePrimaryKeyColumn  string `json:"tablePrimaryKeyColumn,omitempty"`
}

func main() {
    reqData := UpdateDatamartRequest{
        DatamartName: "sales-analytics",
        TableList: []TableInfo{
            {
                SchemaName: "public",
                Name:       "orders",
                Label:      "Customer Orders",
                Columns: []ColumnInfo{
                    {Name: "order_id", Alias: "id", Label: "Order ID"},
                    {Name: "customer_id", Label: "Customer"},
                },
            },
        },
    }
    
    jsonData, _ := json.Marshal(reqData)
    
    req, _ := http.NewRequest("PUT", 
        "https://api.usedatabrain.com/api/v2/data-app/datamarts", 
        bytes.NewBuffer(jsonData))
    req.Header.Set("Authorization", "Bearer dbn_live_abc123...")
    req.Header.Set("Content-Type", "application/json")
    
    client := &http.Client{}
    resp, _ := client.Do(req)
    defer resp.Body.Close()
    
    fmt.Println("Datamart updated successfully")
}

<?php
$url = 'https://api.usedatabrain.com/api/v2/data-app/datamarts';
$data = [
    'datamartName' => 'sales-analytics',
    'tableList' => [
        [
            'schemaName' => 'public',
            'name' => 'orders',
            'label' => 'Customer Orders',
            'columns' => [
                [
                    'name' => 'order_id',
                    'alias' => 'id',
                    'label' => 'Order ID'
                ],
                [
                    'name' => 'customer_id',
                    'label' => 'Customer'
                ]
            ]
        ]
    ]
];

$options = [
    'http' => [
        'header' => [
            'Authorization: Bearer dbn_live_abc123...',
            'Content-Type: application/json'
        ],
        'method' => 'PUT',
        'content' => json_encode($data)
    ]
];

$context = stream_context_create($options);
$response = file_get_contents($url, false, $context);
$result = json_decode($response, true);

if (isset($result['error'])) {
    echo "Update failed: " . $result['error']['message'];
} else {
    echo "Datamart ID: " . $result['id'];
}
?>

{
  "id": "sales-analytics"
}

{
  "error": {
    "code": "INVALID_DATAMART",
    "message": "invalid datamart name."
  }
}

{
  "error": {
    "code": "INVALID_REQUEST_BODY",
    "message": "Invalid table or column structure"
  }
}

{
  "error": {
    "code": "INVALID_REQUEST_BODY",
    "message": "Invalid schema or table name"
  }
}

{
  "error": {
    "code": "INVALID_REQUEST_BODY",
    "message": "Invalid column names in table"
  }
}

{
  "error": {
    "code": "INVALID_REQUEST_BODY",
    "message": "\"datamartName\" is required"
  }
}

{
  "error": {
    "code": "INVALID_DATA_APP_API_KEY",
    "message": "invalid or expired API KEY, data app not found"
  }
}

{
  "error": {
    "code": "INTERNAL_SERVER_ERROR",
    "message": "Internal Server Error"
  }
}