Get File Metadata

Obter metadados detalhados de um arquivo

Get File Metadata

Retorna metadados detalhados de um arquivo específico no storage.

Endpoint

GET /storage-explorer/storage/metadata

Permissões Requeridas

  • STORAGE_EXPLORER.READ

Query Parameters

ParâmetroTipoObrigatórioDescrição
file_pathstringSimCaminho completo do arquivo

Exemplo de Requisição

curl -X GET "https://maestro.dadosfera.ai/storage-explorer/storage/metadata?file_path=/raw/sales/orders_2024_01.csv" \
  -H "Authorization: <JWT_TOKEN>"

Exemplo de Resposta - CSV

Success (200 OK):

{
  "file_path": "/raw/sales/orders_2024_01.csv",
  "file_name": "orders_2024_01.csv",
  "file_format": "csv",
  "file_size_bytes": 524288,
  "file_size_human": "512 KB",
  "created_at": "2024-01-15T10:30:00Z",
  "modified_at": "2024-01-15T10:30:00Z",
  "uploaded_by": "[email protected]",
  "upload_id": "upl_m1n2o3p4",
  "dataset_id": "ds_x1y2z3",
  "content_type": "text/csv",
  "encoding": "UTF-8",
  "row_count": 5420,
  "column_count": 5,
  "columns": [
    "order_id",
    "customer_id",
    "order_date",
    "total_amount",
    "status"
  ],
  "parsing_options": {
    "delimiter": ",",
    "header_row": true,
    "quote_char": "\""
  },
  "checksum": {
    "md5": "5d41402abc4b2a76b9719d911017c592",
    "sha256": "2c26b46b68ffc68ff99b453c1d30413413422d706483bfa0f98a5e886266e7ae"
  },
  "storage_class": "STANDARD",
  "linked_tables": [
    {
      "table_id": "tbl_a1b2c3d4e5f6",
      "table_name": "customer_orders",
      "schema_name": "RAW_DATA"
    }
  ]
}

Exemplo de Resposta - Excel

Success (200 OK):

{
  "file_path": "/raw/sales/products_jan.xlsx",
  "file_name": "products_jan.xlsx",
  "file_format": "excel",
  "file_size_bytes": 153600,
  "file_size_human": "150 KB",
  "created_at": "2024-01-15T10:30:00Z",
  "modified_at": "2024-01-15T10:30:00Z",
  "dataset_id": "ds_a2b3c4",
  "content_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
  "row_count": 850,
  "column_count": 8,
  "sheets": [
    {
      "sheet_name": "Products",
      "row_count": 850,
      "column_count": 8
    },
    {
      "sheet_name": "Categories",
      "row_count": 25,
      "column_count": 3
    }
  ],
  "checksum": {
    "md5": "098f6bcd4621d373cade4e832627b4f6"
  }
}

Exemplo de Resposta - Parquet

Success (200 OK):

{
  "file_path": "/processed/analytics/events.parquet",
  "file_name": "events.parquet",
  "file_format": "parquet",
  "file_size_bytes": 2048576,
  "file_size_human": "2 MB",
  "created_at": "2024-01-16T08:00:00Z",
  "modified_at": "2024-01-16T08:00:00Z",
  "dataset_id": "ds_c4d5e6",
  "content_type": "application/octet-stream",
  "row_count": 125000,
  "column_count": 15,
  "columns": [
    "event_id",
    "user_id",
    "event_type",
    "event_timestamp",
    "properties"
  ],
  "compression": "snappy",
  "parquet_metadata": {
    "version": "2.6",
    "created_by": "parquet-mr version 1.12.0",
    "num_row_groups": 4
  }
}

Response Fields

CampoTipoDescrição
file_pathstringCaminho completo do arquivo
file_namestringNome do arquivo
file_formatstringFormato do arquivo
file_size_bytesintegerTamanho em bytes
file_size_humanstringTamanho formatado
created_atstringData de criação
modified_atstringData de modificação
dataset_idstringID do dataset (se existir)
row_countintegerNúmero de linhas
column_countintegerNúmero de colunas
checksumobjectChecksums do arquivo
linked_tablesarrayTabelas vinculadas

Códigos de Status

CódigoDescrição
200Metadados retornados com sucesso
400file_path não fornecido
401Não autenticado
403Sem permissão STORAGE_EXPLORER.READ
404Arquivo não encontrado