Projects dataset

Projects by Brand

Stores details of all active projects in Monterosa Studio within the customer Organisation.

Table name: customer_schema.silver_projects

Data source: Monterosa Control API

Update method: Batch

Update frequency: TBD

See Monterosa Identifiers for details of the IDs used in this dataset

Column

Type

Description

Example

project_id

string

Unique project identifier

[uuid]

brand_id

string

Unique brand identifier

[uuid]

project_name

string

Name of project in Monterosa Studio

Your project name

env_type

string

Type of environment - β€˜staging’ or β€˜production’

staging

Sample data in CSV format:

"project_id","brand_id","project_name","env_type"
"3e5f63c1-2b8f-4f28-b2e4-0a3097c6c153","1d0497a9-11f4-46e6-82f0-9059c674153d","Project A","production"
"45c3a076-2643-4a2b-9c02-9f67b9e5c18d","7b2959ea-8dce-4c56-a4f3-6c48c7f8c7e1","Project B","staging"
"88a7d5ed-9833-47b9-8667-1d14c1e864c4","8a22eef9-e154-4c63-9a2b-72ab5f0e652e","Project C","production"
"4c4ce4b3-589a-49d3-8966-2f57b4a41c2a","4d9ed0dd-8bb9-4e9b-a95e-593f6955a8c7","Project D","staging"
"feb18ef4-2c7c-498f-86ab-86ed564b7c1e","f86ea21e-6c1c-4659-a6b6-2518c6c1c4ad","Project E","production"

Sample data in JSON format:

[
  {
    "project_id": "3e5f63c1-2b8f-4f28-b2e4-0a3097c6c153",
    "brand_id": "1d0497a9-11f4-46e6-82f0-9059c674153d",
    "project_name": "Project A",
    "env_type": "production"
  },
  {
    "project_id": "45c3a076-2643-4a2b-9c02-9f67b9e5c18d",
    "brand_id": "7b2959ea-8dce-4c56-a4f3-6c48c7f8c7e1",
    "project_name": "Project B",
    "env_type": "staging"
  },
  {
    "project_id": "88a7d5ed-9833-47b9-8667-1d14c1e864c4",
    "brand_id": "8a22eef9-e154-4c63-9a2b-72ab5f0e652e",
    "project_name": "Project C",
    "env_type": "production"
  },
  {
    "project_id": "4c4ce4b3-589a-49d3-8966-2f57b4a41c2a",
    "brand_id": "4d9ed0dd-8bb9-4e9b-a95e-593f6955a8c7",
    "project_name": "Project D",
    "env_type": "staging"
  },
  {
    "project_id": "feb18ef4-2c7c-498f-86ab-86ed564b7c1e",
    "brand_id": "f86ea21e-6c1c-4659-a6b6-2518c6c1c4ad",
    "project_name": "Project E",
    "env_type": "production"
  }
]