SQL Table Reference
Which tables appear depends on the dataset’s media type and when it was ingested. Run SHOW TABLES to see the tables for your dataset.
This page lists the columns in each SQL table Coactive creates for a dataset, so you can write queries without running DESCRIBE first. To run queries, see Getting Started with the Query Engine.
Dynamic tag views (dt_*) are documented separately in Dynamic Tag Tables.
Core tables
coactive_table
To read a metadata value, see Read metadata values.
coactive_table_adv
An advanced version of coactive_table. It includes every column in coactive_table, plus additional metadata and a pair of columns for each concept:
For example queries, see Analyzing Concepts with SQL.
coactive_table_video
To read a metadata value, see Read metadata values.
coactive_table_keyframe
coactive_table_transcription
Concept tables
concept_[concept name]
Each concept gets its own table, for example concept_beach_scenes.
Video structure tables
Video structure tables describe how a video is divided into time ranges. They support native video understanding.
coactive_table_slice
A slice is a time range in a video with a specific property.
coactive_table_composite
A composite, such as a shot or a scene, is made of slices.
Ad segments are stored in coactive_table_composite as rows where type = 'ad-segment'. For a query that uses them, see Find ad segments.
coactive_table_shot
Legacy. Appears only on older datasets. Use dt_[group]_shot joined to coactive_table_slice instead.
