SQLite

Required

Fields required for a valid configuration.

Path	Type	Required	Description	Default	Constraints
required	object	Yes	—	—	no extra properties
required.database_path	string	Yes	Absolute or relative path to the SQLite database file (e.g. /data/app.db)	—	—

Masked

Sensitive fields under(secrets/credentials).

Path	Type	Required	Description	Default	Constraints
masked	object	No	SQLite has no credentials; this section is intentionally empty.	—	no extra properties

Optional

Optional configuration fields.

Path	Type	Required	Description	Default	Constraints
optional	object	No	—	—	no extra properties
optional.scope	object	No	Table selection scope.	—	no extra properties
optional.scope.include_tables	array	No	Optional table allowlist. Only tables in this list will be scanned.	—	—
optional.scope.include_tables[]	string	No	—	—	—
optional.scope.table_limit	integer	No	Optional cap on number of table assets extracted	—	min 1

Extracted Metadata

Table

Field	Type	Required	Description
database	string	Yes	Database or catalog name
table_name	string	Yes	Table name
table_type	string	Yes	Object type (TABLE/VIEW)
schema	string	No	Schema name
columns	object[]	No	Columns as {name, type} objects
row_count	integer	No	Estimated number of rows

Examples

Local file scan

Scan all tables in a local SQLite database file with random sampling

Config Payload

{
  "type": "SQLITE",
  "required": {
    "database_path": "/data/app.db"
  },
  "sampling": {
    "strategy": "AUTOMATIC",
    "rows_per_page": 50
  }
}

Schedule

{
  "enabled": false,
  "preset": "weekly",
  "cron": "0 3 * * 0",
  "timezone": "UTC"
}

Full table export

Read every row from selected tables in a SQLite database

Config Payload

{
  "type": "SQLITE",
  "required": {
    "database_path": "/data/analytics.sqlite3"
  },
  "optional": {
    "scope": {
      "include_tables": [
        "users",
        "events"
      ],
      "table_limit": 50
    }
  },
  "sampling": {
    "strategy": "AUTOMATIC",
    "rows_per_page": 100
  }
}

Schedule

{
  "enabled": true,
  "preset": "weekday_business",
  "cron": "0 9 * * 1-5",
  "timezone": "UTC"
}