Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

2.3 KB
Raw Blame
- description: Query information_schema.tables
  statement: SELECT * FROM information_schema.tables
  defaultDatabase: testdb
  metadata: '{}'
  querySpan:
    type: 3
    results: []
    sourcecolumns:
        - server: ""
          database: information_schema
          schema: ""
          table: tables
          column: ""
    predicatecolumns: []
- description: Query information_schema.columns with WHERE clause
  statement: SELECT table_name, column_name FROM information_schema.columns WHERE table_schema = 'testdb'
  defaultDatabase: testdb
  metadata: '{}'
  querySpan:
    type: 3
    results: []
    sourcecolumns:
        - server: ""
          database: information_schema
          schema: ""
          table: columns
          column: ""
    predicatecolumns: []
- description: Query _statistics_ database
  statement: SELECT * FROM _statistics_.table_statistics
  defaultDatabase: testdb
  metadata: '{}'
  querySpan:
    type: 3
    results: []
    sourcecolumns:
        - server: ""
          database: _statistics_
          schema: ""
          table: table_statistics
          column: ""
    predicatecolumns: []
- description: Query sys metadatabase (StarRocks system db; Doris has no sys, and StarRocks has no mysql/__internal_schema)
  statement: SELECT * FROM sys.grants_to_roles
  defaultDatabase: testdb
  metadata: '{}'
  querySpan:
    type: 3
    results: []
    sourcecolumns:
        - server: ""
          database: sys
          schema: ""
          table: grants_to_roles
          column: ""
    predicatecolumns: []
- description: Query user table
  statement: SELECT * FROM users
  defaultDatabase: testdb
  metadata: |-
    {
      "name": "testdb",
      "schemas": [
        {
          "name": "",
          "tables": [
            {
              "name": "users",
              "columns": [
                {
                  "name": "id",
                  "position": 1
                },
                {
                  "name": "name",
                  "position": 2
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results: []
    sourcecolumns:
        - server: ""
          database: testdb
          schema: ""
          table: users
          column: ""
    predicatecolumns: []