Ingest targeted data from Snowflake, BigQuery and other data warehouses to Reforge Insights for consolidation and analysis
Snowflake
BigQuery
bigquery.jobUser
(BigQuery
Job User) role. This will allow us to run queries on your behalf.bigquery.dataViewer
(BigQuery Data Viewer) role. This will provide us with read-only access to the datasets
you want to share.Amazon Redshift
Field | Example |
---|---|
Datashare ARN | arn:aws:redshift:us-east-1:111122223333:datashare:ingest_share |
Redshift namespace ARN (only if you have multiple clusters/workgroups) | arn:aws:redshift:us-east-1:111122223333:namespace:prod-ns-1 |
List of schemas / tables / views included | public.conversations, public.latest_tickets_v |
Field Name | Required | Type | Description |
---|---|---|---|
id | Yes | STRING | Unique identifier for the feedback record |
description | Yes | STRING | The main feedback content |
created_at | Yes | STRING | When the feedback was created |
updated_at | Yes | DATE | When the feedback was last updated |
source | No | STRING | The source of the feedback, e.g. “HUBSPOT” |
title | No | STRING | Optional title for the feedback |
contact_id | No | STRING | Optional identifier linking to a contact |
Field Name | Required | Type | Description |
---|---|---|---|
id | Yes | STRING | Unique identifier for the conversation |
title | No | STRING | Optional title for the conversation |
source | No | STRING | The source of the feedback, e.g. “HUBSPOT” |
created_at | Yes | STRING | When the conversation was created |
updated_at | No | DATE | When the conversation was last updated |
conversation_id
field.
Field Name | Required | Type | Description |
---|---|---|---|
id | Yes | STRING | Unique identifier for the message |
created_at | Yes | DATE | When the message was sent |
updated_at | No | DATE | When the message was last updated |
conversation_id | Yes | STRING | ID of the conversation this message belongs to |
content | Yes | STRING | The message content |
incoming | Yes | BOOLEAN | Whether the message was sent by an external user |
contact_id | No | STRING | Optional identifier linking to a contact |
Field Name | Required | Type | Description |
---|---|---|---|
id | Yes | STRING | Unique identifier for the contact |
name | Yes | STRING | The contact’s full name |
Yes | STRING | The contact’s email address | |
account_id | Yes | STRING | The account the contact belongs to |
created_at | Yes | DATE | When the contact was created |
updated_at | Yes | DATE | When the contact was last updated |
Field Name | Required | Type | Description |
---|---|---|---|
id | Yes | STRING | Unique identifier for the account |
name | Yes | STRING | The account’s name |
domain | Yes | STRING | The account’s domain |
contract_value | No | NUMBER | The account’s contract value |
created_at | Yes | DATE | When the account was created |
updated_at | Yes | DATE | When the account was last updated |
Column Name | Column Type | Description |
---|---|---|
org_id | STRING | The unique identifier for the organization |
org_name | STRING | The name of the organization (maps to account name) |
org_website | STRING | The organization’s website domain (maps to account domain) |
annual_revenue | NUMBER | The organization’s annual contract value |
creation_date | DATE | When the organization was created (maps to account created_at) |
last_modified | DATE | When the organization was last updated (maps to account updated_at) |
Column Name | Column Type | Description |
---|---|---|
user_id | STRING | The unique identifier for the user (maps to contact id) |
full_name | STRING | The user’s full name (maps to contact name) |
user_email | STRING | The user’s email address (maps to contact email) |
org_id | STRING | Foreign key to client_organizations (maps to account_id) |
signup_date | DATE | When the user was created (maps to contact created_at) |
profile_updated | DATE | When the user profile was last updated (maps to contact updated_at) |
Column Name | Column Type | Description |
---|---|---|
ticket_id | STRING | Unique identifier for the support ticket (maps to conversation id) |
opened_at | DATE | When the ticket was created (maps to conversation created_at) |
closed_at | DATE | When the ticket was closed (maps to conversation updated_at) |
user_id | STRING | User who opened the ticket (maps to contact_id) |
org_id | STRING | Organization the ticket belongs to |
status | STRING | Current status of the ticket |
priority | STRING | Priority level of the ticket |
Column Name | Column Type | Description |
---|---|---|
message_id | STRING | Unique identifier for the message (maps to message id) |
ticket_id | STRING | Foreign key to support_tickets (maps to conversation_id) |
message_text | STRING | The content of the message (maps to message content) |
sent_time | DATE | When the message was sent (maps to message created_at) |
edited_time | DATE | When the message was edited (maps to message updated_at) |
from_customer | BOOLEAN | Whether the message was from the customer (maps to incoming) |
user_id | STRING | User who sent the message (maps to contact_id) |