Partnerstack

Tables in the Partnerstack connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	partnerships	14		Full Refresh		API Reference
2	leads	13		Full Refresh		API Reference
3	deals	20		Full Refresh		API Reference
4	groups	8		Full Refresh		API Reference
5	customers	15		Full Refresh		API Reference
6	transactions	12		Full Refresh		API Reference
7	rewards	13		Full Refresh		API Reference

Table: partnerships

No	Column Name	Type	Notes
1	manager	VARCHAR
2	created_at	INTEGER
3	last_name	VARCHAR
4	team	VARCHAR
5	tags	VARCHAR
6	joined_at	INTEGER
7	updated_at	INTEGER
8	m_data	VARCHAR
9	stats	VARCHAR
10	partner_key	VARCHAR
11	first_name	VARCHAR
12	email	VARCHAR
13	key	VARCHAR
14	group	VARCHAR

Table: leads

No	Column Name	Type	Notes
1	amount	INTEGER
2	external_key	VARCHAR
3	created_at	INTEGER
4	approved	BOOLEAN
5	updated_at	INTEGER
6	field_data	VARCHAR
7	meta	VARCHAR
8	partner_key	VARCHAR
9	mold_key	VARCHAR
10	fields	VARCHAR
11	key	VARCHAR
12	group_key	VARCHAR
13	status	VARCHAR

Table: deals

No	Column Name	Type	Notes
1	amount	INTEGER
2	close_date	VARCHAR
3	external_key	VARCHAR
4	team_member	VARCHAR
5	created_at	INTEGER
6	source	VARCHAR
7	team	VARCHAR
8	lost_reason	VARCHAR
9	updated_at	INTEGER
10	stage	VARCHAR
11	field_data	VARCHAR
12	meta	VARCHAR
13	partner_key	VARCHAR
14	account_name	VARCHAR
15	mold_key	VARCHAR
16	contact_last_name	VARCHAR
17	fields	VARCHAR
18	contact_first_name	VARCHAR
19	key	VARCHAR
20	group_key	VARCHAR

Table: groups

No	Column Name	Type	Notes
1	archived	BOOLEAN
2	features	VARCHAR
3	default	BOOLEAN
4	updated_at	INTEGER
5	name	VARCHAR
6	created_at	INTEGER
7	key	VARCHAR
8	slug	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	test	BOOLEAN
2	created_at	INTEGER
3	source_type	VARCHAR
4	partnership_key	VARCHAR
5	customer_key	VARCHAR
6	updated_at	INTEGER
7	field_data	VARCHAR
8	meta	VARCHAR
9	partner_key	VARCHAR
10	name	VARCHAR
11	provider_key	VARCHAR
12	fields	VARCHAR
13	email	VARCHAR
14	key	VARCHAR
15	source_key	VARCHAR

Table: transactions

No	Column Name	Type	Notes
1	customer_key	VARCHAR
2	amount	INTEGER
3	approved	BOOLEAN
4	category_key	VARCHAR
5	extension	VARCHAR
6	product_key	VARCHAR
7	updated_at	INTEGER
8	amount_usd	INTEGER
9	created_at	INTEGER
10	currency	VARCHAR
11	key	VARCHAR
12	customer	VARCHAR

Table: rewards

No	Column Name	Type	Notes
1	amount	INTEGER
2	partnership	VARCHAR
3	created_at	INTEGER
4	description	VARCHAR
5	trigger	VARCHAR
6	offer	VARCHAR
7	updated_at	INTEGER
8	action	VARCHAR
9	invoice	VARCHAR
10	reward_status	VARCHAR
11	key	VARCHAR
12	transaction	VARCHAR
13	customer	VARCHAR

External Resources

• Partnerstack Api
• Partnerstack Docs

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.