Skip to content
Book a demoStart free
Connectors

GIPHY connector

Set up the GIPHY connector in Kaivo: authentication, configuration, the 6 BigQuery tables it syncs, and answers to common questions.

GIPHY connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your GIPHY data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your data from GIPHY instead of moving it.

Sync your GIPHY search results and categories into BigQuery with Kaivo to analyse trending GIFs and content by tag and channel.

CategoryOther
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your GIPHY account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key
Your GIPHY API Key. Create and find your API key in the GIPHY Developer Dashboard at https://developers.giphy.com/dashboard/.

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

| | Query for Search Endpoints |

Search term for the autocomplete tag and channel search streams.

| | Query for GIF Search |

Search term for the GIF search stream.

| | Query for Sticker Search |

Search term for the sticker search stream.

|

Kaivo syncs 6 tables from GIPHY into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

autocomplete_tags (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
analytics_response_payload STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
categories (156 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gif__type STRING
gif__alt_text STRING
gif__analytics__onclick__url STRING
gif__analytics__onload__url STRING
gif__analytics__onsent__url STRING
gif__analytics_response_payload STRING
gif__bitly_gif_url STRING
gif__bitly_url STRING
gif__content_url STRING
gif__embed_url STRING
gif__id STRING
gif__images___480w_still__height STRING
gif__images___480w_still__size STRING
gif__images___480w_still__url STRING
gif__images___480w_still__width STRING
gif__images__downsized__height STRING
gif__images__downsized__size STRING
gif__images__downsized__url STRING
gif__images__downsized__width STRING
gif__images__downsized_large__height STRING
gif__images__downsized_large__size STRING
gif__images__downsized_large__url STRING
gif__images__downsized_large__width STRING
gif__images__downsized_medium__height STRING
gif__images__downsized_medium__size STRING
gif__images__downsized_medium__url STRING
gif__images__downsized_medium__width STRING
gif__images__downsized_small__height STRING
gif__images__downsized_small__mp4 STRING
gif__images__downsized_small__mp4_size STRING
gif__images__downsized_small__width STRING
gif__images__downsized_still__height STRING
gif__images__downsized_still__size STRING
gif__images__downsized_still__url STRING
gif__images__downsized_still__width STRING
gif__images__fixed_height__height STRING
gif__images__fixed_height__mp4 STRING
gif__images__fixed_height__mp4_size STRING
gif__images__fixed_height__size STRING
gif__images__fixed_height__url STRING
gif__images__fixed_height__webp STRING
gif__images__fixed_height__webp_size STRING
gif__images__fixed_height__width STRING
gif__images__fixed_height_downsampled__height STRING
gif__images__fixed_height_downsampled__size STRING
gif__images__fixed_height_downsampled__url STRING
gif__images__fixed_height_downsampled__webp STRING
gif__images__fixed_height_downsampled__webp_size STRING
gif__images__fixed_height_downsampled__width STRING
gif__images__fixed_height_small__height STRING
gif__images__fixed_height_small__mp4 STRING
gif__images__fixed_height_small__mp4_size STRING
gif__images__fixed_height_small__size STRING
gif__images__fixed_height_small__url STRING
gif__images__fixed_height_small__webp STRING
gif__images__fixed_height_small__webp_size STRING
gif__images__fixed_height_small__width STRING
gif__images__fixed_height_small_still__height STRING
gif__images__fixed_height_small_still__size STRING
gif__images__fixed_height_small_still__url STRING
gif__images__fixed_height_small_still__width STRING
gif__images__fixed_height_still__height STRING
gif__images__fixed_height_still__size STRING
gif__images__fixed_height_still__url STRING
gif__images__fixed_height_still__width STRING
gif__images__fixed_width__height STRING
gif__images__fixed_width__mp4 STRING
gif__images__fixed_width__mp4_size STRING
gif__images__fixed_width__size STRING
gif__images__fixed_width__url STRING
gif__images__fixed_width__webp STRING
gif__images__fixed_width__webp_size STRING
gif__images__fixed_width__width STRING
gif__images__fixed_width_downsampled__height STRING
gif__images__fixed_width_downsampled__size STRING
gif__images__fixed_width_downsampled__url STRING
gif__images__fixed_width_downsampled__webp STRING
gif__images__fixed_width_downsampled__webp_size STRING
gif__images__fixed_width_downsampled__width STRING
gif__images__fixed_width_small__height STRING
gif__images__fixed_width_small__mp4 STRING
gif__images__fixed_width_small__mp4_size STRING
gif__images__fixed_width_small__size STRING
gif__images__fixed_width_small__url STRING
gif__images__fixed_width_small__webp STRING
gif__images__fixed_width_small__webp_size STRING
gif__images__fixed_width_small__width STRING
gif__images__fixed_width_small_still__height STRING
gif__images__fixed_width_small_still__size STRING
gif__images__fixed_width_small_still__url STRING
gif__images__fixed_width_small_still__width STRING
gif__images__fixed_width_still__height STRING
gif__images__fixed_width_still__size STRING
gif__images__fixed_width_still__url STRING
gif__images__fixed_width_still__width STRING
gif__images__hd__height STRING
gif__images__hd__mp4 STRING
gif__images__hd__mp4_size STRING
gif__images__hd__width STRING
gif__images__looping__mp4 STRING
gif__images__looping__mp4_size STRING
gif__images__original__frames STRING
gif__images__original__hash STRING
gif__images__original__height STRING
gif__images__original__mp4 STRING
gif__images__original__mp4_size STRING
gif__images__original__size STRING
gif__images__original__url STRING
gif__images__original__webp STRING
gif__images__original__webp_size STRING
gif__images__original__width STRING
gif__images__original_mp4__height STRING
gif__images__original_mp4__mp4 STRING
gif__images__original_mp4__mp4_size STRING
gif__images__original_mp4__width STRING
gif__images__original_still__height STRING
gif__images__original_still__size STRING
gif__images__original_still__url STRING
gif__images__original_still__width STRING
gif__images__preview__height STRING
gif__images__preview__mp4 STRING
gif__images__preview__mp4_size STRING
gif__images__preview__width STRING
gif__images__preview_gif__height STRING
gif__images__preview_gif__size STRING
gif__images__preview_gif__url STRING
gif__images__preview_gif__width STRING
gif__images__preview_webp__height STRING
gif__images__preview_webp__size STRING
gif__images__preview_webp__url STRING
gif__images__preview_webp__width STRING
gif__import_datetime STRING
gif__is_sticker FLOAT64
gif__rating STRING
gif__slug STRING
gif__source STRING
gif__source_post_url STRING
gif__source_tld STRING
gif__title STRING
gif__trending_datetime STRING
gif__url STRING
gif__user__description STRING
gif__user__avatar_url STRING
gif__user__banner_image STRING
gif__user__banner_url STRING
gif__user__display_name STRING
gif__user__instagram_url STRING
gif__user__is_verified BOOL
gif__user__profile_url STRING
gif__user__username STRING
gif__user__website_url STRING
gif__username STRING
name STRING
name_encoded STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
name_encoded STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
channel_search (209 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
analytics_response_payload STRING
banner_image STRING
content_type STRING
display_name STRING
featured_gif__type STRING
featured_gif__alt_text STRING
featured_gif__analytics__onclick__url STRING
featured_gif__analytics__onload__url STRING
featured_gif__analytics__onsent__url STRING
featured_gif__analytics_response_payload STRING
featured_gif__bitly_gif_url STRING
featured_gif__bitly_url STRING
featured_gif__content_url STRING
featured_gif__embed_url STRING
featured_gif__id STRING
featured_gif__images___480w_still__height STRING
featured_gif__images___480w_still__size STRING
featured_gif__images___480w_still__url STRING
featured_gif__images___480w_still__width STRING
featured_gif__images___4k__height STRING
featured_gif__images___4k__mp4 STRING
featured_gif__images___4k__mp4_size STRING
featured_gif__images___4k__width STRING
featured_gif__images__downsized__height STRING
featured_gif__images__downsized__size STRING
featured_gif__images__downsized__url STRING
featured_gif__images__downsized__width STRING
featured_gif__images__downsized_large__height STRING
featured_gif__images__downsized_large__size STRING
featured_gif__images__downsized_large__url STRING
featured_gif__images__downsized_large__width STRING
featured_gif__images__downsized_medium__height STRING
featured_gif__images__downsized_medium__size STRING
featured_gif__images__downsized_medium__url STRING
featured_gif__images__downsized_medium__width STRING
featured_gif__images__downsized_small__height STRING
featured_gif__images__downsized_small__mp4 STRING
featured_gif__images__downsized_small__mp4_size STRING
featured_gif__images__downsized_small__width STRING
featured_gif__images__downsized_still__height STRING
featured_gif__images__downsized_still__size STRING
featured_gif__images__downsized_still__url STRING
featured_gif__images__downsized_still__width STRING
featured_gif__images__fixed_height__height STRING
featured_gif__images__fixed_height__mp4 STRING
featured_gif__images__fixed_height__mp4_size STRING
featured_gif__images__fixed_height__size STRING
featured_gif__images__fixed_height__url STRING
featured_gif__images__fixed_height__webp STRING
featured_gif__images__fixed_height__webp_size STRING
featured_gif__images__fixed_height__width STRING
featured_gif__images__fixed_height_downsampled__height STRING
featured_gif__images__fixed_height_downsampled__size STRING
featured_gif__images__fixed_height_downsampled__url STRING
featured_gif__images__fixed_height_downsampled__webp STRING
featured_gif__images__fixed_height_downsampled__webp_size STRING
featured_gif__images__fixed_height_downsampled__width STRING
featured_gif__images__fixed_height_small__height STRING
featured_gif__images__fixed_height_small__mp4 STRING
featured_gif__images__fixed_height_small__mp4_size STRING
featured_gif__images__fixed_height_small__size STRING
featured_gif__images__fixed_height_small__url STRING
featured_gif__images__fixed_height_small__webp STRING
featured_gif__images__fixed_height_small__webp_size STRING
featured_gif__images__fixed_height_small__width STRING
featured_gif__images__fixed_height_small_still__height STRING
featured_gif__images__fixed_height_small_still__size STRING
featured_gif__images__fixed_height_small_still__url STRING
featured_gif__images__fixed_height_small_still__width STRING
featured_gif__images__fixed_height_still__height STRING
featured_gif__images__fixed_height_still__size STRING
featured_gif__images__fixed_height_still__url STRING
featured_gif__images__fixed_height_still__width STRING
featured_gif__images__fixed_width__height STRING
featured_gif__images__fixed_width__mp4 STRING
featured_gif__images__fixed_width__mp4_size STRING
featured_gif__images__fixed_width__size STRING
featured_gif__images__fixed_width__url STRING
featured_gif__images__fixed_width__webp STRING
featured_gif__images__fixed_width__webp_size STRING
featured_gif__images__fixed_width__width STRING
featured_gif__images__fixed_width_downsampled__height STRING
featured_gif__images__fixed_width_downsampled__size STRING
featured_gif__images__fixed_width_downsampled__url STRING
featured_gif__images__fixed_width_downsampled__webp STRING
featured_gif__images__fixed_width_downsampled__webp_size STRING
featured_gif__images__fixed_width_downsampled__width STRING
featured_gif__images__fixed_width_small__height STRING
featured_gif__images__fixed_width_small__mp4 STRING
featured_gif__images__fixed_width_small__mp4_size STRING
featured_gif__images__fixed_width_small__size STRING
featured_gif__images__fixed_width_small__url STRING
featured_gif__images__fixed_width_small__webp STRING
featured_gif__images__fixed_width_small__webp_size STRING
featured_gif__images__fixed_width_small__width STRING
featured_gif__images__fixed_width_small_still__height STRING
featured_gif__images__fixed_width_small_still__size STRING
featured_gif__images__fixed_width_small_still__url STRING
featured_gif__images__fixed_width_small_still__width STRING
featured_gif__images__fixed_width_still__height STRING
featured_gif__images__fixed_width_still__size STRING
featured_gif__images__fixed_width_still__url STRING
featured_gif__images__fixed_width_still__width STRING
featured_gif__images__hd__height STRING
featured_gif__images__hd__mp4 STRING
featured_gif__images__hd__mp4_size STRING
featured_gif__images__hd__width STRING
featured_gif__images__looping__mp4 STRING
featured_gif__images__looping__mp4_size STRING
featured_gif__images__original__frames STRING
featured_gif__images__original__hash STRING
featured_gif__images__original__height STRING
featured_gif__images__original__mp4 STRING
featured_gif__images__original__mp4_size STRING
featured_gif__images__original__size STRING
featured_gif__images__original__url STRING
featured_gif__images__original__webp STRING
featured_gif__images__original__webp_size STRING
featured_gif__images__original__width STRING
featured_gif__images__original_mp4__height STRING
featured_gif__images__original_mp4__mp4 STRING
featured_gif__images__original_mp4__mp4_size STRING
featured_gif__images__original_mp4__width STRING
featured_gif__images__original_still__height STRING
featured_gif__images__original_still__size STRING
featured_gif__images__original_still__url STRING
featured_gif__images__original_still__width STRING
featured_gif__images__preview__height STRING
featured_gif__images__preview__mp4 STRING
featured_gif__images__preview__mp4_size STRING
featured_gif__images__preview__width STRING
featured_gif__images__preview_gif__height STRING
featured_gif__images__preview_gif__size STRING
featured_gif__images__preview_gif__url STRING
featured_gif__images__preview_gif__width STRING
featured_gif__images__preview_webp__height STRING
featured_gif__images__preview_webp__size STRING
featured_gif__images__preview_webp__url STRING
featured_gif__images__preview_webp__width STRING
featured_gif__import_datetime STRING
featured_gif__is_sticker FLOAT64
featured_gif__rating STRING
featured_gif__slug STRING
featured_gif__source STRING
featured_gif__source_post_url STRING
featured_gif__source_tld STRING
featured_gif__title STRING
featured_gif__trending_datetime STRING
featured_gif__url STRING
featured_gif__user__description STRING
featured_gif__user__avatar_url STRING
featured_gif__user__banner_image STRING
featured_gif__user__banner_url STRING
featured_gif__user__display_name STRING
featured_gif__user__instagram_url STRING
featured_gif__user__is_verified BOOL
featured_gif__user__profile_url STRING
featured_gif__user__username STRING
featured_gif__user__website_url STRING
featured_gif__username STRING
featured_gif__video__description STRING
featured_gif__video__assets___1080p__height STRING
featured_gif__video__assets___1080p__url STRING
featured_gif__video__assets___1080p__width STRING
featured_gif__video__assets___360p__height STRING
featured_gif__video__assets___360p__url STRING
featured_gif__video__assets___360p__width STRING
featured_gif__video__assets___480p__height STRING
featured_gif__video__assets___480p__url STRING
featured_gif__video__assets___480p__width STRING
featured_gif__video__assets___720p__height STRING
featured_gif__video__assets___720p__url STRING
featured_gif__video__assets___720p__width STRING
featured_gif__video__dash_manifest_url STRING
featured_gif__video__duration FLOAT64
featured_gif__video__hls_manifest_url STRING
featured_gif__video__previews__fixed_height__height STRING
featured_gif__video__previews__fixed_height__mp4 STRING
featured_gif__video__previews__fixed_height__url STRING
featured_gif__video__previews__fixed_height__webp STRING
featured_gif__video__previews__fixed_height__width STRING
featured_gif__video__previews__fixed_width__height STRING
featured_gif__video__previews__fixed_width__mp4 STRING
featured_gif__video__previews__fixed_width__url STRING
featured_gif__video__previews__fixed_width__webp STRING
featured_gif__video__previews__fixed_width__width STRING
has_children BOOL
id FLOAT64
is_live BOOL
is_private BOOL
is_visible BOOL
metadata_description STRING
num_children FLOAT64
screensaver_gif_id STRING
slug STRING
url STRING
user__description STRING
user__avatar_url STRING
user__banner_image STRING
user__banner_url STRING
user__display_name STRING
user__instagram_url STRING
user__is_verified BOOL
user__profile_url STRING
user__username STRING
user__website_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
emoji (158 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
alt_text STRING
analytics__onclick__url STRING
analytics__onload__url STRING
analytics__onsent__url STRING
analytics_response_payload STRING
bitly_gif_url STRING
bitly_url STRING
content_url STRING
embed_url STRING
emoji_group_id FLOAT64
id STRING
images___480w_still__height STRING
images___480w_still__size STRING
images___480w_still__url STRING
images___480w_still__width STRING
images__downsized__height STRING
images__downsized__size STRING
images__downsized__url STRING
images__downsized__width STRING
images__downsized_large__height STRING
images__downsized_large__size STRING
images__downsized_large__url STRING
images__downsized_large__width STRING
images__downsized_medium__height STRING
images__downsized_medium__size STRING
images__downsized_medium__url STRING
images__downsized_medium__width STRING
images__downsized_small__height STRING
images__downsized_small__mp4 STRING
images__downsized_small__mp4_size STRING
images__downsized_small__width STRING
images__downsized_still__height STRING
images__downsized_still__size STRING
images__downsized_still__url STRING
images__downsized_still__width STRING
images__fixed_height__height STRING
images__fixed_height__mp4 STRING
images__fixed_height__mp4_size STRING
images__fixed_height__size STRING
images__fixed_height__url STRING
images__fixed_height__webp STRING
images__fixed_height__webp_size STRING
images__fixed_height__width STRING
images__fixed_height_downsampled__height STRING
images__fixed_height_downsampled__size STRING
images__fixed_height_downsampled__url STRING
images__fixed_height_downsampled__webp STRING
images__fixed_height_downsampled__webp_size STRING
images__fixed_height_downsampled__width STRING
images__fixed_height_small__height STRING
images__fixed_height_small__mp4 STRING
images__fixed_height_small__mp4_size STRING
images__fixed_height_small__size STRING
images__fixed_height_small__url STRING
images__fixed_height_small__webp STRING
images__fixed_height_small__webp_size STRING
images__fixed_height_small__width STRING
images__fixed_height_small_still__height STRING
images__fixed_height_small_still__size STRING
images__fixed_height_small_still__url STRING
images__fixed_height_small_still__width STRING
images__fixed_height_still__height STRING
images__fixed_height_still__size STRING
images__fixed_height_still__url STRING
images__fixed_height_still__width STRING
images__fixed_width__height STRING
images__fixed_width__mp4 STRING
images__fixed_width__mp4_size STRING
images__fixed_width__size STRING
images__fixed_width__url STRING
images__fixed_width__webp STRING
images__fixed_width__webp_size STRING
images__fixed_width__width STRING
images__fixed_width_downsampled__height STRING
images__fixed_width_downsampled__size STRING
images__fixed_width_downsampled__url STRING
images__fixed_width_downsampled__webp STRING
images__fixed_width_downsampled__webp_size STRING
images__fixed_width_downsampled__width STRING
images__fixed_width_small__height STRING
images__fixed_width_small__mp4 STRING
images__fixed_width_small__mp4_size STRING
images__fixed_width_small__size STRING
images__fixed_width_small__url STRING
images__fixed_width_small__webp STRING
images__fixed_width_small__webp_size STRING
images__fixed_width_small__width STRING
images__fixed_width_small_still__height STRING
images__fixed_width_small_still__size STRING
images__fixed_width_small_still__url STRING
images__fixed_width_small_still__width STRING
images__fixed_width_still__height STRING
images__fixed_width_still__size STRING
images__fixed_width_still__url STRING
images__fixed_width_still__width STRING
images__hd__height STRING
images__hd__mp4 STRING
images__hd__mp4_size STRING
images__hd__width STRING
images__looping__mp4 STRING
images__looping__mp4_size STRING
images__original__frames STRING
images__original__hash STRING
images__original__height STRING
images__original__mp4 STRING
images__original__mp4_size STRING
images__original__size STRING
images__original__url STRING
images__original__webp STRING
images__original__webp_size STRING
images__original__width STRING
images__original_mp4__height STRING
images__original_mp4__mp4 STRING
images__original_mp4__mp4_size STRING
images__original_mp4__width STRING
images__original_still__height STRING
images__original_still__size STRING
images__original_still__url STRING
images__original_still__width STRING
images__preview__height STRING
images__preview__mp4 STRING
images__preview__mp4_size STRING
images__preview__width STRING
images__preview_gif__height STRING
images__preview_gif__size STRING
images__preview_gif__url STRING
images__preview_gif__width STRING
images__preview_webp__height STRING
images__preview_webp__size STRING
images__preview_webp__url STRING
images__preview_webp__width STRING
import_datetime STRING
is_low_contrast BOOL
is_sticker FLOAT64
rating STRING
slug STRING
source STRING
source_post_url STRING
source_tld STRING
title STRING
trending_datetime STRING
url STRING
user__description STRING
user__avatar_url STRING
user__banner_image STRING
user__banner_url STRING
user__display_name STRING
user__instagram_url STRING
user__is_verified BOOL
user__profile_url STRING
user__username STRING
user__website_url STRING
username STRING
variation STRING
variation_count FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
gifs_search (158 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
alt_text STRING
analytics__onclick__url STRING
analytics__onload__url STRING
analytics__onsent__url STRING
analytics_response_payload STRING
bitly_gif_url STRING
bitly_url STRING
content_url STRING
embed_url STRING
id STRING
images___480w_still__height STRING
images___480w_still__size STRING
images___480w_still__url STRING
images___480w_still__width STRING
images___4k__height STRING
images___4k__mp4 STRING
images___4k__mp4_size STRING
images___4k__width STRING
images__downsized__height STRING
images__downsized__size STRING
images__downsized__url STRING
images__downsized__width STRING
images__downsized_large__height STRING
images__downsized_large__size STRING
images__downsized_large__url STRING
images__downsized_large__width STRING
images__downsized_medium__height STRING
images__downsized_medium__size STRING
images__downsized_medium__url STRING
images__downsized_medium__width STRING
images__downsized_small__height STRING
images__downsized_small__mp4 STRING
images__downsized_small__mp4_size STRING
images__downsized_small__width STRING
images__downsized_still__height STRING
images__downsized_still__size STRING
images__downsized_still__url STRING
images__downsized_still__width STRING
images__fixed_height__height STRING
images__fixed_height__mp4 STRING
images__fixed_height__mp4_size STRING
images__fixed_height__size STRING
images__fixed_height__url STRING
images__fixed_height__webp STRING
images__fixed_height__webp_size STRING
images__fixed_height__width STRING
images__fixed_height_downsampled__height STRING
images__fixed_height_downsampled__size STRING
images__fixed_height_downsampled__url STRING
images__fixed_height_downsampled__webp STRING
images__fixed_height_downsampled__webp_size STRING
images__fixed_height_downsampled__width STRING
images__fixed_height_small__height STRING
images__fixed_height_small__mp4 STRING
images__fixed_height_small__mp4_size STRING
images__fixed_height_small__size STRING
images__fixed_height_small__url STRING
images__fixed_height_small__webp STRING
images__fixed_height_small__webp_size STRING
images__fixed_height_small__width STRING
images__fixed_height_small_still__height STRING
images__fixed_height_small_still__size STRING
images__fixed_height_small_still__url STRING
images__fixed_height_small_still__width STRING
images__fixed_height_still__height STRING
images__fixed_height_still__size STRING
images__fixed_height_still__url STRING
images__fixed_height_still__width STRING
images__fixed_width__height STRING
images__fixed_width__mp4 STRING
images__fixed_width__mp4_size STRING
images__fixed_width__size STRING
images__fixed_width__url STRING
images__fixed_width__webp STRING
images__fixed_width__webp_size STRING
images__fixed_width__width STRING
images__fixed_width_downsampled__height STRING
images__fixed_width_downsampled__size STRING
images__fixed_width_downsampled__url STRING
images__fixed_width_downsampled__webp STRING
images__fixed_width_downsampled__webp_size STRING
images__fixed_width_downsampled__width STRING
images__fixed_width_small__height STRING
images__fixed_width_small__mp4 STRING
images__fixed_width_small__mp4_size STRING
images__fixed_width_small__size STRING
images__fixed_width_small__url STRING
images__fixed_width_small__webp STRING
images__fixed_width_small__webp_size STRING
images__fixed_width_small__width STRING
images__fixed_width_small_still__height STRING
images__fixed_width_small_still__size STRING
images__fixed_width_small_still__url STRING
images__fixed_width_small_still__width STRING
images__fixed_width_still__height STRING
images__fixed_width_still__size STRING
images__fixed_width_still__url STRING
images__fixed_width_still__width STRING
images__hd__height STRING
images__hd__mp4 STRING
images__hd__mp4_size STRING
images__hd__width STRING
images__looping__mp4 STRING
images__looping__mp4_size STRING
images__original__frames STRING
images__original__hash STRING
images__original__height STRING
images__original__mp4 STRING
images__original__mp4_size STRING
images__original__size STRING
images__original__url STRING
images__original__webp STRING
images__original__webp_size STRING
images__original__width STRING
images__original_mp4__height STRING
images__original_mp4__mp4 STRING
images__original_mp4__mp4_size STRING
images__original_mp4__width STRING
images__original_still__height STRING
images__original_still__size STRING
images__original_still__url STRING
images__original_still__width STRING
images__preview__height STRING
images__preview__mp4 STRING
images__preview__mp4_size STRING
images__preview__width STRING
images__preview_gif__height STRING
images__preview_gif__size STRING
images__preview_gif__url STRING
images__preview_gif__width STRING
images__preview_webp__height STRING
images__preview_webp__size STRING
images__preview_webp__url STRING
images__preview_webp__width STRING
import_datetime STRING
is_sticker FLOAT64
rating STRING
slug STRING
source STRING
source_post_url STRING
source_tld STRING
title STRING
trending_datetime STRING
url STRING
user__description STRING
user__avatar_url STRING
user__banner_image STRING
user__banner_url STRING
user__display_name STRING
user__instagram_url STRING
user__is_verified BOOL
user__profile_url STRING
user__username STRING
user__website_url STRING
username STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
stickers_search (160 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
alt_text STRING
analytics__onclick__url STRING
analytics__onload__url STRING
analytics__onsent__url STRING
analytics_response_payload STRING
bitly_gif_url STRING
bitly_url STRING
content_url STRING
embed_url STRING
id STRING
images___480w_still__height STRING
images___480w_still__size STRING
images___480w_still__url STRING
images___480w_still__width STRING
images___4k__height STRING
images___4k__mp4 STRING
images___4k__mp4_size STRING
images___4k__width STRING
images__downsized__height STRING
images__downsized__size STRING
images__downsized__url STRING
images__downsized__width STRING
images__downsized_large__height STRING
images__downsized_large__size STRING
images__downsized_large__url STRING
images__downsized_large__width STRING
images__downsized_medium__height STRING
images__downsized_medium__size STRING
images__downsized_medium__url STRING
images__downsized_medium__width STRING
images__downsized_small__height STRING
images__downsized_small__mp4 STRING
images__downsized_small__mp4_size STRING
images__downsized_small__width STRING
images__downsized_still__height STRING
images__downsized_still__size STRING
images__downsized_still__url STRING
images__downsized_still__width STRING
images__fixed_height__height STRING
images__fixed_height__mp4 STRING
images__fixed_height__mp4_size STRING
images__fixed_height__size STRING
images__fixed_height__url STRING
images__fixed_height__webp STRING
images__fixed_height__webp_size STRING
images__fixed_height__width STRING
images__fixed_height_downsampled__height STRING
images__fixed_height_downsampled__size STRING
images__fixed_height_downsampled__url STRING
images__fixed_height_downsampled__webp STRING
images__fixed_height_downsampled__webp_size STRING
images__fixed_height_downsampled__width STRING
images__fixed_height_small__height STRING
images__fixed_height_small__mp4 STRING
images__fixed_height_small__mp4_size STRING
images__fixed_height_small__size STRING
images__fixed_height_small__url STRING
images__fixed_height_small__webp STRING
images__fixed_height_small__webp_size STRING
images__fixed_height_small__width STRING
images__fixed_height_small_still__height STRING
images__fixed_height_small_still__size STRING
images__fixed_height_small_still__url STRING
images__fixed_height_small_still__width STRING
images__fixed_height_still__height STRING
images__fixed_height_still__size STRING
images__fixed_height_still__url STRING
images__fixed_height_still__width STRING
images__fixed_width__height STRING
images__fixed_width__mp4 STRING
images__fixed_width__mp4_size STRING
images__fixed_width__size STRING
images__fixed_width__url STRING
images__fixed_width__webp STRING
images__fixed_width__webp_size STRING
images__fixed_width__width STRING
images__fixed_width_downsampled__height STRING
images__fixed_width_downsampled__size STRING
images__fixed_width_downsampled__url STRING
images__fixed_width_downsampled__webp STRING
images__fixed_width_downsampled__webp_size STRING
images__fixed_width_downsampled__width STRING
images__fixed_width_small__height STRING
images__fixed_width_small__mp4 STRING
images__fixed_width_small__mp4_size STRING
images__fixed_width_small__size STRING
images__fixed_width_small__url STRING
images__fixed_width_small__webp STRING
images__fixed_width_small__webp_size STRING
images__fixed_width_small__width STRING
images__fixed_width_small_still__height STRING
images__fixed_width_small_still__size STRING
images__fixed_width_small_still__url STRING
images__fixed_width_small_still__width STRING
images__fixed_width_still__height STRING
images__fixed_width_still__size STRING
images__fixed_width_still__url STRING
images__fixed_width_still__width STRING
images__hd__height STRING
images__hd__mp4 STRING
images__hd__mp4_size STRING
images__hd__width STRING
images__looping__mp4 STRING
images__looping__mp4_size STRING
images__original__frames STRING
images__original__hash STRING
images__original__height STRING
images__original__mp4 STRING
images__original__mp4_size STRING
images__original__size STRING
images__original__url STRING
images__original__webp STRING
images__original__webp_size STRING
images__original__width STRING
images__original_mp4__height STRING
images__original_mp4__mp4 STRING
images__original_mp4__mp4_size STRING
images__original_mp4__width STRING
images__original_still__height STRING
images__original_still__size STRING
images__original_still__url STRING
images__original_still__width STRING
images__preview__height STRING
images__preview__mp4 STRING
images__preview__mp4_size STRING
images__preview__width STRING
images__preview_gif__height STRING
images__preview_gif__size STRING
images__preview_gif__url STRING
images__preview_gif__width STRING
images__preview_webp__height STRING
images__preview_webp__size STRING
images__preview_webp__url STRING
images__preview_webp__width STRING
import_datetime STRING
is_low_contrast BOOL
is_sticker FLOAT64
rating STRING
slug STRING
source STRING
source_post_url STRING
source_tld STRING
title STRING
trending_datetime STRING
url STRING
user__description STRING
user__avatar_url STRING
user__banner_image STRING
user__banner_url STRING
user__display_name STRING
user__instagram_url STRING
user__is_verified BOOL
user__profile_url STRING
user__username STRING
user__website_url STRING
username STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where GIPHY supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for GIPHY?

Section titled “How long does the initial sync take for GIPHY?”

It depends on how much history is in your GIPHY account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when GIPHY’s schema changes?

Section titled “What happens when GIPHY’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in GIPHY, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in GIPHY instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the GIPHY connector in Kaivo and all of its synced data is deleted with it.

Use gifs_search and stickers_search results to see what content appears for your queries.

Report on categories and autocomplete_tags to understand how content is labelled.

Use channel_search to track channels and their featured content.

Bring search results into BigQuery to build a searchable record of assets.

Once GIPHY data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with GIPHY data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for GIPHY connector pricing and plan details.