Aha! connector reference

Important

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Azure Databricks previews.

This page has reference information for the managed Aha! connector, including supported source tables and destination table schemas.

Supported source tables

The Aha! connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode
ideas	id	Ideas submitted in Aha!.	Incremental (cursor: updated_at)
idea_organizations	id	Organizations associated with ideas. Requires an Aha! Ideas Advanced plan.	Incremental (cursor: updated_at)
tasks	id	Task items in Aha!.	Incremental (cursor: updated_at)
products	id	Products and product lines in the Aha! workspace.	Incremental (cursor: updated_at)
idea_users	id	Users who submit ideas through an ideas portal.	Full refresh only
idea_portals	id	Ideas portals configured in Aha!.	Full refresh only
idea_themes	id	Themes used to group ideas.	Full refresh only
users	id	Users in the Aha! account.	Full refresh only
integrations	id	Integrations configured in Aha!.	Full refresh only
idea_endorsements	id	Endorsements on ideas.	Full refresh only
idea_comments	id	Comments on ideas.	Full refresh only

Destination table schemas

ideas

Field	Data type
id	STRING
reference_num	STRING
name	STRING
score	BIGINT
created_at	STRING
updated_at	STRING
product_id	STRING
votes	BIGINT
initial_votes	BIGINT
status_changed_at	STRING
visibility	STRING
portal_restricted	BOOLEAN
url	STRING
resource	STRING
endorsements_count	BIGINT
comments_count	BIGINT
workflow_status	STRING
description	STRING
product	STRING
created_by_portal_user	STRING
created_by_idea_user	STRING
assigned_to_user	STRING
categories	STRING
tags	STRING
themes	STRING
custom_fields	STRING
workflow_status_times	STRING
score_facts	STRING

idea_organizations

Field	Data type
id	STRING
reference_num	STRING
name	STRING
description	STRING
created_at	STRING
updated_at	STRING
url	STRING
endorsements_count	BIGINT
email_domains	STRING
revenue	STRING
created_by_portal_user	STRING
created_by_idea_user	STRING
custom_fields	STRING
integration_fields	STRING

tasks

Field	Data type
id	STRING
name	STRING
body	STRING
due_date	STRING
status	STRING
position	BIGINT
created_at	STRING
updated_at	STRING
product_id	STRING
comments_count	BIGINT
url	STRING
resource	STRING
assigned_to_users	STRING
created_by_user	STRING
attachments	STRING
custom_fields	STRING
taskable	STRING

products

Field	Data type
id	STRING
reference_prefix	STRING
name	STRING
description	STRING
product_line	BOOLEAN
product_line_type	STRING
created_at	STRING
updated_at	STRING
workspace_type	STRING
color	STRING
url	STRING
resource	STRING
has_ideas	BOOLEAN
has_master_features	BOOLEAN
has_epics	BOOLEAN
capacity_planning_enabled	BOOLEAN
enhanced_capacity_planning_enabled	BOOLEAN
default_capacity_units	STRING
children	STRING
custom_fields	STRING
screen_definition_ids	STRING
screen_definitions	STRING
release_workflow	STRING
feature_workflow	STRING
initiative_workflow	STRING
epic_workflow	STRING
idea_workflow	STRING
strategic_imperative_workflow	STRING
page_workflow	STRING
requirement_workflow	STRING
key_result_workflow	STRING

idea_users

Field	Data type
id	STRING
name	STRING
email	STRING
created_at	STRING
idea_organizations	STRING
custom_fields	STRING
integration_fields	STRING

idea_portals

Field	Data type
id	STRING
title	STRING
portal_enabled	BOOLEAN
access_type	STRING
external_url	STRING
created_at	STRING

idea_themes

Field	Data type
id	STRING
reference_num	STRING
name	STRING
created_at	STRING

users

Field	Data type
id	STRING
name	STRING
email	STRING
timezone	STRING
created_at	STRING
updated_at	STRING
accessed_at	STRING
enabled	BOOLEAN
paid_seat	BOOLEAN
administrator	BOOLEAN
ideas_seat	BOOLEAN
product_roles	STRING
administrator_roles	STRING
identity_provider	STRING

integrations

Field	Data type
id	STRING
name	STRING
service_name	STRING
created_at	STRING

idea_endorsements

Field	Data type
id	STRING
idea_id	STRING
created_at	STRING
updated_at	STRING
value	STRING
link	STRING
weight	BIGINT
endorsed_by_portal_user	STRING
endorsed_by_idea_user	STRING

idea_comments

Field	Data type
id	STRING
idea_id	STRING
body	STRING
created_at	STRING
updated_at	STRING
user	STRING

Connector options

The Aha! connector has no configurable connector options.