Référence du connecteur Aha !

info

Bêta

Cette fonctionnalité est en version bêta. Pour l'utiliser, un administrateur du workspace doit activer Lakeflow Connect for Aha! depuis la page Previews . Consultez Gérer les aperçus Databricks.

Cette page contient des informations de référence pour le connecteur géré Aha!, y compris les tables source prises en charge et les schémas de table de destination.

Tables sources prises en charge

Le connecteur Aha! prend en charge les tables source suivantes, toutes sous le schéma source default :

Table source	Clé principale	Description	Mode de synchronisation
`ideas`	`id`	Idées soumises dans Aha!.	Incrémentiel (curseur : `updated_at`)
`idea_organizations`	`id`	Organisations associées à des idées. Nécessite un plan Aha! Ideas Advanced.	Incrémentiel (curseur : `updated_at`)
`tasks`	`id`	Éléments de tâche dans Aha!.	Incrémentiel (curseur : `updated_at`)
`products`	`id`	Produits et gammes de produits dans le workspace Aha!.	Incrémentiel (curseur : `updated_at`)
`idea_users`	`id`	Utilisateurs qui soumettent des idées via un portail des idées.	Full refresh uniquement
`idea_portals`	`id`	Portails d’idées configurés dans Aha!.	Full refresh uniquement
`idea_themes`	`id`	Thèmes utilisés pour regrouper les idées.	Full refresh uniquement
`users`	`id`	Utilisateurs du compte Aha!.	Full refresh uniquement
`integrations`	`id`	Intégrations configurées dans Aha!.	Full refresh uniquement
`idea_endorsements`	`id`	Approbations des idées.	Full refresh uniquement
`idea_comments`	`id`	Commentaires sur les idées.	Full refresh uniquement

Table source	Clé principale	Description	Mode de synchronisation
`ideas`	`id`	Idées soumises dans Aha!.	Incrémentiel (curseur : `updated_at`)
`idea_organizations`	`id`	Organisations associées à des idées. Nécessite un plan Aha! Ideas Advanced.	Incrémentiel (curseur : `updated_at`)
`tasks`	`id`	Éléments de tâche dans Aha!.	Incrémentiel (curseur : `updated_at`)
`products`	`id`	Produits et gammes de produits dans le workspace Aha!.	Incrémentiel (curseur : `updated_at`)
`idea_users`	`id`	Utilisateurs qui soumettent des idées via un portail des idées.	Full refresh uniquement
`idea_portals`	`id`	Portails d’idées configurés dans Aha!.	Full refresh uniquement
`idea_themes`	`id`	Thèmes utilisés pour regrouper les idées.	Full refresh uniquement
`users`	`id`	Utilisateurs du compte Aha!.	Full refresh uniquement
`integrations`	`id`	Intégrations configurées dans Aha!.	Full refresh uniquement
`idea_endorsements`	`id`	Approbations des idées.	Full refresh uniquement
`idea_comments`	`id`	Commentaires sur les idées.	Full refresh uniquement

Schémas de table de destination

`ideas`

Champ	Type de données
`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`

Champ	Type de données
`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`

Champ	Type de données
`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`

Champ	Type de données
`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`

Champ	Type de données
`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`

Champ	Type de données
`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`

Champ	Type de données
`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`

Champ	Type de données
`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`

Champ	Type de données
`id`	`STRING`
`name`	`STRING`
`email`	`STRING`
`created_at`	`STRING`
`idea_organizations`	`STRING`
`custom_fields`	`STRING`
`integration_fields`	`STRING`

`idea_portals`

Champ	Type de données
`id`	`STRING`
`title`	`STRING`
`portal_enabled`	`BOOLEAN`
`access_type`	`STRING`
`external_url`	`STRING`
`created_at`	`STRING`

`idea_themes`

Champ	Type de données
`id`	`STRING`
`reference_num`	`STRING`
`name`	`STRING`
`created_at`	`STRING`

`users`

Champ	Type de données
`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`

Champ	Type de données
`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`

Champ	Type de données
`id`	`STRING`
`name`	`STRING`
`service_name`	`STRING`
`created_at`	`STRING`

`idea_endorsements`

Champ	Type de données
`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`

Champ	Type de données
`id`	`STRING`
`idea_id`	`STRING`
`body`	`STRING`
`created_at`	`STRING`
`updated_at`	`STRING`
`user`	`STRING`

Options du connecteur

Le connecteur Aha! n’a aucune option de connecteur configurable.

Tables sources prises en charge​

Schémas de table de destination​

ideas​

idea_organizations​

tasks​

products​

idea_users​

idea_portals​

idea_themes​

users​

integrations​

idea_endorsements​

idea_comments​

Options du connecteur​