Enterprise Reporting
  • Introduction
  • Understanding reports with clarity (Definitions)
  • Optimizing key performance indicators (via the Groups tab)
    • Dashboard
    • Reporting section
      • Progress report
      • Adoption report
      • Engagement report
      • Content insights
        • XP
        • Courses
        • Projects
        • Tracks
      • Assessments
      • Certifications
      • Time in Learn
      • DataLab
      • Export
    • Skill Matrix
  • Integrating our data into your tools (via Data Connector 2.0)
    • Explore the data model
      • Fact tables
      • Dimension tables
      • Bridge tables
      • Metrics tables
    • Common use cases
    • Sample queries
    • Queries to recreate key reports in the Groups tab
      • Dashboard
        • Members who have earned XP
      • Reporting section
        • Progress report
        • Content insights
        • Assessments
        • Certification Insights
        • Time in Learn
    • Domain Gotchas
    • Getting started with Data Connector 2.0
      • Enable Data Connector 2.0
      • Your credentials
      • Storing your credentials
    • Using Data Connector 2.0
      • Integrating with your BI tools
        • Microsoft Power BI
        • Tableau
        • Looker
        • DataLab
      • Downloading your data
        • S3 Browser (Windows)
        • Cyberduck (Mac or Windows)
        • AWS CLI (Linux)
    • Changelog
    • Migrating from Data Connector 1.0
  • FAQ
  • Data Connector 1.0 - Documentation
    • [Data Connector 1.0] Explore Data Model
      • [Data Connector 1.0] Data Model
      • [Data Connector 1.0] Changelog
      • [Data Connector 1.0] Example queries
    • [Data Connector 1.0] Getting started
      • [Data Connector 1.0] Enabling the Data Connector
      • [Data Connector 1.0] Your Credentials
      • [Data Connector 1.0] Storing your Credentials
    • [Data Connector 1.0] Using the Data Connector
      • [Data Connector 1.0] Analyzing data
        • [Data Connector 1.0] DataLab
        • [Data Connector 1.0] Microsoft Power BI
        • [Data Connector 1.0] Tableau
      • [Data Connector 1.0] Downloading data
        • [Data Connector 1.0] S3 Browser (Windows)
        • [Data Connector 1.0] 3Hub (Mac)
        • [Data Connector 1.0] AWS CLI (Linux)
    • [Data Connector 1.0] Data Connector FAQ
      • [Data Connector 1.0] Deprecating dcdcpy and dcdcr
Powered by GitBook
On this page
  • Set up the Athena connector in Looker
  • Resources
  1. Integrating our data into your tools (via Data Connector 2.0)
  2. Using Data Connector 2.0
  3. Integrating with your BI tools

Looker

PreviousTableauNextDataLab

Last updated 8 days ago

DataCamp's Data Connector 2.0 makes it easy to analyze your data in Looker. All you need to do is set up a connection using the Looker Athena Connector and configure it using the credentials you can retrieve in the Groups tab.

Set up the Athena connector in Looker

First, make sure you have your credentials.

In the Admin section of Looker, select Connections, then Add Connection, and enter the following data:

  1. Name: Specify the name of the connection. Free to choose (e.g., DataCamp Data Connector)

  2. Dialect: Amazon Athena

  3. Host: athena.us-east-1.amazonaws.com

  4. Port: 443

  5. Database: Specify the default database that you would like modeled

  6. Username: The AWS Access Key ID from your credentials

  7. Password: The AWS Secret Access Key from your credentials

  8. Temp Database: s3://{bucketname}/tmp/looker → replace {bucketname} with the S3 Bucket Name from your credentials

To save these settings, click Connect.

Resources

  • Official Looker guide

  • Official Amazon Athena Looker documentation