Overview

Monterey AI can connect to and pull data from your data warehouse of choice. Currently, we support Snowflake, but are always looking to expand our integrations.

Snowflake

To connect with Snowflake, you can request our account details and use Secure Data Sharing. Secure data sharing allows you to give us the targeted access to just the data you want to share.

Schemas

We support several schemas and relationships between tables.

Regular Feedback

Regular feedback are singular items of feedback, such as a review or a single response to a question.

Field NameRequiredTypeDescription
idYesSTRINGUnique identifier for the feedback record
descriptionYesSTRINGThe main feedback content
created_atYesSTRINGWhen the feedback was created
updated atYesSTRINGWhen the feedback was last updated
titleNoSTRINGOptional title for the feedback
contact_idNoSTRINGOptional identifier linking to a contact

Conversation

A conversation is a collection of conversational feedback messages. For example, a chat log between a support agent and a user.

Field NameRequiredTypeDescription
idYesSTRINGUnique identifier for the conversation
titleNoSTRINGOptional title for the conversation
created_atYesSTRINGWhen the conversation was created
updated_atNoSTRINGWhen the conversation was last updated

Conversation Message

These are the individual messages within a conversation, and should be linked to a conversation by the conversation_id field.

Field NameRequiredTypeDescription
idYesSTRINGUnique identifier for the message
created_atYesSTRINGWhen the message was sent
updated_atNoSTRINGWhen the message was last updated
conversation_idYesSTRINGID of the conversation this message belongs to
contentYesSTRINGThe message content
incomingYesBOOLEANWhether the message was sent by an external user
contact_idNoSTRINGOptional identifier linking to a contact

Contacts

Contacts are the users of your product.

Field NameRequiredTypeDescription
idYesSTRINGUnique identifier for the contact
nameYesSTRINGThe contact’s full name
emailYesSTRINGThe contact’s email address
account_idYesSTRINGThe account the contact belongs to

Accounts

Accounts are the companies that your contacts belong to.

Field NameRequiredTypeDescription
idYesSTRINGUnique identifier for the account
nameYesSTRINGThe account’s name
domainYesSTRINGThe account’s domain
contract_valueNoNUMBERThe account’s contract value