Machine Overview

• Machine Name : Metadata Extractor
• Title : Metadata Extractor
• Short Description :
  Metadata Extractor connects to a database using a connection string and extracts its metadata. It supports multiple database types.
• Detail Description : Metadata Extractor is a tool that retrieves metadata from databases by establishing a connection using a provided connection string. It supports multiple database types, allowing users to extract schema details such as tables, columns, data types, and relationships.
• Machine Document : -

Classification

• Industry : IT
• Category : GenAI
• Sub Category : -

Compatibility and Dependencies

• Dependent Machines : -
• Compatible Machines : -
• Version : 1.0.4

Specifications

• Input Specification : Download

  No inputs required.

• Output Specification : Download

  Metadata extracted from a database including table information, columns, and relationships.

  Metadata (Object): Contains information about the database structure.

  • Database (String): Name of the database.
  • Tables (Array): List of tables in the database.
  • TablesDetail (Object): Detailed metadata for each table.
    • table_name (Object): Name of a specific table containing detailed metadata.
      • columns (Object): Dictionary where keys are column names and values are data types.
        • column1 (String): Data type of column1.
        • column2 (String): Data type of column2.
      • total_rows (Number): Total number of rows in the table.
      • duplicate_rows (Number): Number of duplicate rows in the table.
      • null_counts (Object): Null value counts per column.
        • column1 (Number): Number of nulls in column1.
        • column2 (Number): Number of nulls in column2.
  • Relationship (Object): Contains foreign key relationships between tables.
    • table_name (Object): Table participating in the relationship.
      • column1 (Array): List of related tables where this column appears.

Infrastructure Requirement

• OS Requirement : Linux
• CPU : 2
• Cloud : AWS
• RAM : 4Gi

Usage Stats

• Total OnBoarded : -
• Active OnBoarding : -