Arcwise Documentation
Español
Español
  • 👋¡Bienvenido a Arcwise!
  • 📘Configuración de Arcwise
    • ⚙️Gestión de Usuarios y Roles
    • 🌐Añadir a Google Workspace
    • 🔌Conectar el Almacén de Datos
      • 📫Dirección IP Fija de Arcwise
      • ❄️Snowflake
      • 🔍BigQuery
      • 🐘Postgres
      • 🧱Databricks
      • 🪶Athena
      • 🪣S3
    • 💻Conexión de Herramientas de Datos
      • 🎆Conéctate a dbt
      • 🔎Conéctate a Looker
    • 📜Registro de Auditoría
    • ☁️Integraciones
      • Descripción General
      • Hubspot
      • Salesforce
    • ❔FAQ
  • 🔐Errores de Inicio de Sesión de Google
  • 📜Registro de Cambios del Producto
  • Conectando Datos
    • ✨Conectando Datos
    • 💿Almacén de Datos
    • ⬆️Subir Archivos CSV
    • 🔨Importar Datos de Otras Herramientas
    • 🤖Selección de Datos de Hoja de Cálculo Para Análisis de AI
  • Usando Arcwise en Google Sheets
    • ▶️Datos Conectados de Arcwise
      • Agregar Columnas
      • Filtración
      • Clasificación
    • 🗃️Trabajar con Grandes Datos
    • 🧪Usar Fórmulas en Hojas
    • 🟰Fórmulas Admitidas
    • 📊Tablas Dinamicas
    • 📉Crear Visualizaciones Manuales
  • Usando Arcwise IA
    • 🤖Descripción General del Analista IA
    • 📂Obtener Datos Usando IA
    • 📈Creando un Visual
    • 💡Generando una Visión
    • 📃Uso de IA en Datos de Hojas de Cálculo
Powered by GitBook
On this page
  • (Optional) Allow connection from Arcwise IP address
  • Add Athena credentials in Arcwise
  • Information about required fields
  • Checking indexed tables/views
  1. Configuración de Arcwise
  2. Conectar el Almacén de Datos

Athena

PreviousDatabricksNextS3

(Optional) Allow connection from Arcwise IP address

If you need to add a fixed IP address to your allowlist or network policy, please refer to our Dirección IP Fija de Arcwise page.

Add Athena credentials in Arcwise

  1. Log into the Arcwise Admin portal and .

  2. Go to the “Connections” tab in the Arcwise admin panel ()

  3. Click on the “+ Create” button (top-right) and select "Athena" from the Warehouse Type dropdown.

Information about required fields

  1. Name

    • A user-friendly name used for display purposes in the Arcwise interface. Can be anything you want.

  2. AWS Access Key ID / Secret Access Key

  3. Region

    • The AWS region that Athena will run in (e.g. us-west-2)

  4. Catalog

  5. S3 Staging Directory

    • Athena requires a S3 bucket path to store the results of queries. The access key / secret must have write access to this bucket. NOTE: you may want to set up the bucket lifecycle to automatically purge old query results automatically. Arcwise doesn't require past query results to be accessible.

Checking indexed tables/views

Arcwise will automatically index your data catalog upon the initial connection; our index will also automatically refresh every day at midnight PST.

An access key ID / secret pair for the role that should run the Athena queries. The IAM role must have access to Athena and S3.

The catalog (normally this should just be the default: awsdatacatalog).

Go to the in the Arcwise panel to see the list of indexed tables / views.

To manually re-index tables, you can press the "Sync" button back on the .

📘
🔌
🪶
https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_access-keys.html
https://docs.aws.amazon.com/athena/latest/ug/understanding-tables-databases-and-the-data-catalog.html
Tables page
Connections page
set up users/roles for your team first
https://admin.arcwise.app/#/warehouse_connections
Required information for Athena connections