Tmdb
Prerequisites
Api key and movie ID is mandate for this connector to work, It could be generated using a free account at TMDb. Visit: https://www.themoviedb.org/settings/api
Just pass the generated API key and Movie ID for establishing the connection.
Tables in the Tmdb connector
Table: trending
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: movies_keywords
| No | Column Name | Type | Notes |
|---|
| 1 | keywords | VARCHAR | |
| 2 | id | INTEGER | |
Table: movies_lists
| No | Column Name | Type | Notes || --- | ----------- | ---- | ----- |
Table: search_companies
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: changes_tv
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: search_multi
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: movies_changes
| No | Column Name | Type | Notes |
|---|
| 1 | items | VARCHAR | |
| 2 | key | VARCHAR | |
Table: movies_details
| No | Column Name | Type | Notes |
|---|
| 1 | original_language | VARCHAR | |
| 2 | imdb_id | VARCHAR | |
| 3 | video | BOOLEAN | |
| 4 | title | VARCHAR | |
| 5 | backdrop_path | VARCHAR | |
| 6 | revenue | INTEGER | |
| 7 | genres | VARCHAR | |
| 8 | popularity | DOUBLE | |
| 9 | production_countries | VARCHAR | |
| 10 | id | INTEGER | |
| 11 | vote_count | INTEGER | |
| 12 | budget | INTEGER | |
| 13 | overview | VARCHAR | |
| 14 | original_title | VARCHAR | |
| 15 | runtime | INTEGER | |
| 16 | poster_path | VARCHAR | |
| 17 | spoken_languages | VARCHAR | |
| 18 | production_companies | VARCHAR | |
| 19 | release_date | VARCHAR | |
| 20 | vote_average | DOUBLE | |
| 21 | belongs_to_collection | VARCHAR | |
| 22 | tagline | VARCHAR | |
| 23 | adult | BOOLEAN | |
| 24 | homepage | VARCHAR | |
| 25 | status | VARCHAR | |
Table: movies_external_ids
| No | Column Name | Type | Notes |
|---|
| 1 | imdb_id | VARCHAR | |
| 2 | id | INTEGER | |
| 3 | twitter_id | VARCHAR | |
| 4 | facebook_id | VARCHAR | |
| 5 | instagram_id | VARCHAR | |
Table: movies_releases_dates
| No | Column Name | Type | Notes |
|---|
| 1 | id | INTEGER | |
| 2 | results | VARCHAR | |
Table: search_keywords
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: search_collections
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: movies_recommendations
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: movies_similar_movies
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: certification_movie
| No | Column Name | Type | Notes |
|---|
| 1 | certifications | VARCHAR | |
Table: movies_videos
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: search_tv_shows
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: search_movies
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: changes_movie
| No | Column Name | Type | Notes |
|---|
| 1 | page | INTEGER | |
| 2 | total_pages | INTEGER | |
| 3 | results | VARCHAR | |
| 4 | total_results | INTEGER | |
Table: movies_images
| No | Column Name | Type | Notes |
|---|
| 1 | backdrops | VARCHAR | |
| 2 | posters | VARCHAR | |
| 3 | id | INTEGER | |
External Resources
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.