Arcwise Documentation
English
English
  • 👋Welcome to Arcwise!
  • 📘Arcwise setup
    • ⚙ïļUser & Role Management
    • 🌐Add to Google Workspace
    • 🔌Connect Data Warehouse
      • ðŸ“ŦArcwise Fixed IP Address
      • ❄ïļSnowflake
      • 🔍BigQuery
      • 🐘Postgres
      • ðŸ§ąDatabricks
      • ðŸŠķAthena
      • ðŸŠĢS3
    • ðŸ’ŧConnecting data tools
      • 🎆Connect to dbt
      • 🔎Connect to Looker
      • 🧊Connect to Cube
    • 📜Audit logging
    • ☁ïļIntegrations
      • Overview
      • Hubspot
      • Salesforce
    • ❔FAQ
  • 🔐Google Login Errors
  • 📜Product Changelog
  • Connecting data
    • âœĻConnecting Data
    • ðŸ’ŋData Warehouse
    • ⮆ïļUploading CSV Files
    • ðŸ”ĻImporting Data from Other Tools
    • ðŸĪ–Selecting Spreadsheet Data for AI Analysis
  • Using Arcwise in sheets
    • â–ķïļArcwise Connected Data
      • Adding Columns
      • Filtering
      • Sorting
    • 🗃ïļWorking With Large Data
    • 🧊Using Formulas in Sheets
    • 🟰Supported Formulas
    • 📊Pivot Tables
    • 📉Creating Manual Visualizations
  • Using Arcwise AI Analyst
    • ðŸĪ–AI Analyst Overview
    • ❇ïļUsing AI Analyst in Sheets
    • 📂Getting Data Using AI
    • 📈Creating a Visual
    • ðŸ’ĄGenerating an Insight
    • 📃Using AI Analyst on Spreadsheet Data
    • Embedding the AI Analyst Chat
  • Using Arcwise AI Formulas
    • ðŸĪ–GPT Formulas Overview
    • ✔ïļGPT Formula Basics
    • 📖GPT Formula Reference
Powered by GitBook
On this page
  • Example Prompts
  • Saving Data to the Sheet
  1. Using Arcwise AI Analyst

Getting Data Using AI

PreviousUsing AI Analyst in SheetsNextCreating a Visual

Last updated 1 year ago

There are several ways Arcwise AI can be used to retrieve data. Below are some example prompts as well as instructions for saving it to the sheet.

Example Prompts

Get me a table of all transactions last year

This prompt can be executed from a blank sheet and will recover a table of transactions from your data warehouse, or other connected data source. This could be millions of rows but you will still be able to save it to the sheet and work with the data, both with normal spreadsheet tools and with AI: Working With Large Data.

Get me a list of our stores, the total sales at those stores last year, and the YoY change in sales

This prompt can be executed from a blank sheet and will recover a table of transactions from your data warehouse, or other connected data source. It can also be executed after manually connecting the correct data source: Connecting Data. This data is likely to be small.

If Arcwise is connected to your data warehouse then you can retrieve tables from an empty sheet. If Arcwise is not connected to your data warehouse, or your administrator has not given the AI access to the data warehouse then you must add tables using the traditional flows: Connecting data.

Saving Data to the Sheet

After asking the AI analyst for data you can save it to the sheet with the Save button.

📂