workspace_input


Description

External tables that workspace transforms consume from source databases

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique integer identifier for this workspace input row.”,“why”:“Uniquely identifies each row for joins and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.596994591+00:00”}

workspace_id int4 10 null
workspace.id fk_workspace_input_workspace_id C

{“what”:“ID of the workspace that owns this input.”,“why”:“Scopes inputs to a workspace; without it, inputs from different workspaces mix.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.613755905+00:00”}

db_id int4 10 null

{“what”:“ID of the database connection this input queries.”,“why”:“Determines which database to access; without it, the source database is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.624663958+00:00”}

schema varchar 254 √ null

{“what”:“Database schema name (e.g., public) for the input table; null if not specified.”,“why”:“Disambiguates tables with the same name across schemas.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.634204565+00:00”}

table varchar 254 null

{“what”:“Name of the table or view in the database that this input reads.”,“why”:“Specifies the data source; without it, no table to query.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.646342366+00:00”}

table_id int4 10 √ null
metabase_table.id fk_workspace_input_table_id N

{“what”:“Optional identifier for the table in a metadata catalog; null if not linked.”,“why”:“Links to table metadata for validation; without it, only the name is available.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.657502190+00:00”}

ref_id bpchar 36 null

{“what”:“Unique reference string (e.g., UUID) for this input, used externally.”,“why”:“Provides a stable identifier for API calls; without it, external systems cannot refer to this input.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.668802568+00:00”}

access_granted bool 1 false

{“what”:“Whether the workspace has been granted access to this input; defaults to false.”,“why”:“Controls visibility/usage; without it, access state is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.680864393+00:00”}

transform_version int8 19 0

{“what”:“Version number of the transform applied to this input; starts at 0.”,“why”:“Tracks transform changes to invalidate caches; without it, stale data may be used.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.690036993+00:00”}

created_at timestamptz 35,6 null

{“what”:“Timestamp when this input was created, in UTC.”,“why”:“Audits creation time; without it, cannot track when the input was added.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.702315339+00:00”}

updated_at timestamptz 35,6 null

{“what”:“Timestamp of the last update to this input, in UTC.”,“why”:“Tracks modifications for concurrency; without it, stale updates are undetectable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.714962390+00:00”}

Indexes

Constraint Name Type Sort Column(s)
workspace_input_pkey Primary key Asc id
idx_workspace_input_ref_id Performance Asc/Asc workspace_id + ref_id
idx_workspace_input_table_id Performance Asc table_id
idx_workspace_input_workspace_id Performance Asc workspace_id
uq_workspace_input_versioned Must be unique Asc/Asc/Asc/Asc/Asc/Asc workspace_id + ref_id + db_id + schema + table + transform_version

Relationships