See also

Tags

ai feature
17 Jul 2024 09:48 PM

Data Sources for AI

Before you can ask the first question or build a report, you must specify the data sources.

  • You can specify a direct connection to a connected application (e.g. Facebook)
  • Specify a spreadsheet, either by URL or by uploading and downloading a file
  • Select a workflow

You can specify several data sources at once.

Spreadsheets in Copilot

Conduit can handle data from multiple documents and tabs or from a single document. You can supply an unlimited number of data sources in a single query. Example: ask AI to use data from multiple spreadsheets and data from Shopify.

clipboard-2024-06-07-02-10-10-769Z.png

Please note that our UI allows you to clarify the meanings of specific columns and rows for the AI. This significantly enhances the AI's performance.

How does Copilot work with different tables and data sources

Our system automatically generates connections between tables, but you also have the option to define these relationships manually.

Upon integrating a data source, AI analyzes a sample of your data, outlines the fields and the links between tables. Our AI often efficiently identifies primary and foreign keys on its own.

However, if the AI misses a connection, you have the option to manually establish it using plain English. For instance, if you explain,

The Orders table lists the SKU for each product, which corresponds to the product's price in the Prices spreadsheet

the AI will then autonomously connect the tables for any query related to the product's price. This means users won't have to repeatedly instruct the system to associate specific data points.