Instagram

Tables in the Instagram connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	stories	14	id	Full Refresh		API Reference
2	user_lifetime_insights	5		Full Refresh
3	media	17	id	Full Refresh		API Reference
4	story_insights	9	id	Full Refresh
5	user_insights	16		Full Refresh, Incremental	date
6	users	11	id	Full Refresh
7	media_insights	17	id	Full Refresh

Table: stories

No	Column Name	Type	Notes
1	owner	VARCHAR
2	like_count	INTEGER
3	caption	VARCHAR
4	ig_id	VARCHAR
5	shortcode	VARCHAR
6	thumbnail_url	VARCHAR
7	media_url	VARCHAR
8	page_id	VARCHAR
9	media_type	VARCHAR
10	business_account_id	VARCHAR
11	id	VARCHAR	Primary Key
12	permalink	VARCHAR
13	timestamp	VARCHAR
14	username	VARCHAR

Table: user_lifetime_insights

No	Column Name	Type	Notes
1	date	VARCHAR
2	page_id	VARCHAR
3	metric	VARCHAR
4	business_account_id	VARCHAR
5	value	INTEGER

Table: media

No	Column Name	Type	Notes
1	owner	VARCHAR
2	like_count	INTEGER
3	caption	VARCHAR
4	ig_id	VARCHAR
5	shortcode	VARCHAR
6	thumbnail_url	VARCHAR
7	media_url	VARCHAR
8	is_comment_enabled	BOOLEAN
9	page_id	VARCHAR
10	media_type	VARCHAR
11	children	VARCHAR
12	comments_count	INTEGER
13	business_account_id	VARCHAR
14	id	VARCHAR	Primary Key
15	permalink	VARCHAR
16	timestamp	VARCHAR
17	username	VARCHAR

Table: story_insights

No	Column Name	Type	Notes
1	page_id	VARCHAR
2	exits	INTEGER
3	taps_back	INTEGER
4	replies	INTEGER
5	reach	INTEGER
6	business_account_id	VARCHAR
7	id	VARCHAR	Primary Key
8	impressions	INTEGER
9	taps_forward	INTEGER

Table: user_insights

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	online_followers	VARCHAR
3	reach	INTEGER
4	impressions	INTEGER
5	impressions_week	INTEGER
6	get_directions_clicks	INTEGER
7	website_clicks	INTEGER
8	reach_days_28	INTEGER
9	follower_count	INTEGER
10	page_id	VARCHAR
11	text_message_clicks	INTEGER
12	impressions_days_28	INTEGER
13	profile_views	INTEGER
14	reach_week	INTEGER
15	business_account_id	VARCHAR
16	phone_call_clicks	INTEGER

Table: users

No	Column Name	Type	Notes
1	page_id	VARCHAR
2	website	VARCHAR
3	media_count	INTEGER
4	followers_count	INTEGER
5	profile_picture_url	VARCHAR
6	follows_count	INTEGER
7	name	VARCHAR
8	id	VARCHAR	Primary Key
9	biography	VARCHAR
10	ig_id	INTEGER
11	username	VARCHAR

Table: media_insights

No	Column Name	Type	Notes
1	total_interactions	INTEGER
2	engagement	INTEGER
3	carousel_album_impressions	INTEGER
4	comments	INTEGER
5	plays	INTEGER
6	saved	INTEGER
7	reach	INTEGER
8	impressions	INTEGER
9	carousel_album_reach	INTEGER
10	carousel_album_saved	INTEGER
11	shares	INTEGER
12	page_id	VARCHAR
13	carousel_album_engagement	INTEGER
14	video_views	INTEGER
15	business_account_id	VARCHAR
16	id	VARCHAR	Primary Key
17	likes	INTEGER

External Resources

• Meta For Developers Account
• Instagram Business Account
• Instagram Graph Api
• Access Token
• Facebook Ad Account Id Number
• Instagram_basic
• Instagram_manage_insights
• Pages_show_list
• Pages_read_engagement
• Instagram Public Content Access
• User Insights
• Instagram Insights Api Documentation
• User
• Media Insights
• Story Insights
• Documentation On Rate Limiting

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.