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
  • How can I see if permissions were set properly to use Arcwise?
  • I am having trouble granting permissions to Arcwise. What can I do?
  • How and when does Arcwise use database compute?
  • What does Arcwise do with access to DBT?
  • What does Arcwise do with access to Snowflake database data?
  • What data is stored by Arcwise?
  • How does Arcwise store sensitive data securely?
  1. Arcwise setup

FAQ

How can I see if permissions were set properly to use Arcwise?

Using the ARCWISE role (or whichever role + user you have set up) run show tables in Snowflake. You should see all tables you intended to share access to listed there.

I am having trouble granting permissions to Arcwise. What can I do?

Reach out to us! Common issues include:

  • Snowflake: Granting access without including grants to FUTURE. Often times tables will be dropped and recreated by jobs. When this happens the access is removed unless FUTURE is included.

How and when does Arcwise use database compute?

Arcwise uses database compute in two ways:

  • When using Connect Data Arcwise will execute a SELECT * XXX LIMIT 1000 query to preview the data.

  • When executing an Arc formula, EG ARCCOUNT, this is translated to an SQL query that will be executed in your warehouse.

What does Arcwise do with access to DBT?

Arcwise does the following:

  • read dbt artifacts

  • read results of last dbt job

  • read semantic later proxy URL (if you have it set up)

Arcwise doesn't run any jobs. It is sufficient to grant Arcwise Job Viewer permissions.

What does Arcwise do with access to Snowflake database data?

Arcwise uses this access to read query history (SQL only, not data). This query history is used to present the most relevant tables, columns, and joins to Arcwise users.

What data is stored by Arcwise?

For basic usage of the tool we store:

  • names of tables

  • names of columns

If we are granted access to Snowflake database data we additionally store query history (SQL only, not data), usage counts of tables, usage counts of columns, and usage counts of joins.

How does Arcwise store sensitive data securely?

We use authenticated encryption to protect sensitive data, ensuring both confidentiality and integrity. Each organization has a unique encryption key. The key is securely generated using an industry-standard algorithm and is 256 bits in length, providing strong protection against unauthorized access.

This approach is used for both organization level credentials (like API keys) and data warehouse connection credentials (like keyfiles and passwords).

PreviousSalesforceNextGoogle Login Errors

Last updated 3 months ago

📘
❔