main-concepts

No menu items for this category
OpenMetadata Documentation

Table Usage Count

This model is the linking between the usage stage and bulk sink steps

  • table (string): Name of the table.
  • date (string): Date of execution of SQL query.
  • databaseName (string): Database associated with the table in the query.
  • count (integer): Usage count of table. Default: 1.
  • databaseSchema (string): Database schema of the associated with table.
  • sqlQueries (array): List of SQL Queries associated with table.
    • Items: Refer to ../api/data/createQuery.json.
  • joins (array): List of joins associated with table.
    • Items: Refer to #/definitions/tableColumnJoin.
  • serviceName (string): Name that identifies this database service.
  • tableColumn (object): Cannot contain additional properties.
    • table (string): Name of the table.
    • column (string): Name of the column.
  • tableColumnJoin (object): Cannot contain additional properties.
    • tableColumn: Source table column. Refer to #/definitions/tableColumn.
    • joinedWith (array): List of table columns with which the table is joined with.
      • Items: Refer to #/definitions/tableColumn.
  • queryCostWrapper (object): Cannot contain additional properties.
    • cost (number): Avg query cost per execution.
    • count (number): Number of times the query was executed.
    • date (string): Date of execution of SQL query.
    • queryHash (string): Hash of the query.
    • query (string): SQL query.
    • dialect (string): SQL dialect.
    • totalDuration (number): Total duration of the query.

Documentation file automatically generated at 2025-08-12 05:39:47.683420+00:00.