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
  • Creating Service Account in Looker Admin
  • Configuring Service Account in Looker Admin
  • Adding Looker in Arcwise Admin
  • Form Details
  • Connection test
  1. Arcwise setup
  2. Connecting data tools

Connect to Looker

PreviousConnect to dbtNextConnect to Cube

Last updated 11 months ago

Before you Begin

If you haven’t already, add users that will require access while setting up your data warehouse connection: User & Role Management

Creating Service Account in Looker Admin

Complete the steps below to create a Service Account in Looker using a Looker admin account. This step is only necessary if you do not already have a Service Account set up in Looker. If you already do, you can skip ahead to Configuring Service Account in Looker Admin

  1. On the left-side options, select Admin > Users to go to the User Admin panel and select Add Service Accounts on the top right (see screenshot below).

  2. On the next screen, add an email for the Service Account and make sure they have the role of "Admin". After creation, you should be dropped into a User edit view, like the one shown in the section below.

Configuring Service Account in Looker Admin

  1. Go to edit the Service Account user account in Looker. If the service account doesn't already have a name, fill out the first and last name to "Arcwise Service Account" as shown below and confirm that the "Admin" role is added in the Roles section.

  1. Click on the API Keys "Edit Keys" option, highlighted with an arrow above.

  2. On the next screen, click "New API Key". This will create a new key that will be used in the following section.

Adding Looker in Arcwise Admin

  1. Click the "Create" button and select "Looker" as the integration type.

  2. Fill in the form with the required details using the API Key you created above. See below for additional details.

Form Details

Host URL

Your Looker URL is probably of the form https://yourcomany.looker.com or https://something-random.looker.app. The Host URL needed here is just the root yourcompany.looker.com or something-random.looker.app part.

Client ID

This is the Client ID associated with the API Key that was generated in Looker above.

Client Secret

This is the Client Secret associated with the API Key that was generated in Looker above. You will need to click the eye icon to the right to be able to copy/paste the Client Secret into the Arcwise admin window.

Connection test

Now, if you open the Arcwise sidebar in a Google Sheet and click "Connect Data", you should be able to paste in a Looker Look URL and import its data:

Navigate to and go to the Integrations tab.

Before the Looker connection has been saved in Arcwise, it will run a test to ensure connectivity. Please note if there are any errors. If it is able to save the record successfully, you will see it appear in .

📘
ðŸ’ŧ
🔎
https://admin.arcwise.app/
https://admin.arcwise.app/#/api_connections