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"
  }
]