Connectors

/

Looker

Data replication

Sync Looker data anywhere.

Looker is a Google-Cloud-based enterprise platform that provides information and insights to help move businesses forward. Looker reveals data in clear and understandable formats that enable companies to build data applications and create data experiences tailored specifically to their own organization. Looker’s capabilities for data applications, business intelligence, and embedded analytics make it helpful for anyone requiring data to perform their job—from data analysts and data scientists to business executives and partners.

  • Standard
  • Alpha
  • 41 streams
Sync Looker dataRead the docs
Looker

One connector

Everything Looker can do in Airbyte

  • Sync to your warehouse

    Land 41 Looker tables in 50+ destinations on a schedule you control.

  • One authorization

    Authenticate Looker once and Airbyte keeps every scheduled sync running on it.

  • Cloud or self-hosted

    Run the Looker connector on Cloud, Self-Managed Enterprise.

Specifications

What to know before you sync Looker

  • Support levelStandard
  • Available onCloud, Self-Managed Enterprise
  • Connector version1.0.34
  • Release stageAlpha

Sync capabilities

  • Full Refresh SyncSupported
  • NamespacesNot supported
  • Destinations50+ Airbyte connectors

Set up in 11 steps

  1. Open Looker and navigate to the Admin panel.
  2. Click on "Connections" and then "New Connection".
  3. Select "Airbyte" as the type of connection.
  4. Enter a name for the connection and the URL for the Airbyte instance.
  5. In the "Authentication" section, select "OAuth2" as the authentication method.
  6. Enter the Client ID and Client Secret provided by Airbyte.
  7. In the "Advanced" section, set the "API Version" to "v1".
  8. Click "Test" to ensure the connection is successful.
  9. Save the connection and navigate to the "Explore" panel.
  10. Select the Airbyte connection as the data source and choose the relevant tables to explore.
  11. Note: It is important to ensure that the Airbyte instance is properly configured and the necessary connectors are installed before attempting to connect to Looker. Additionally, the specific steps for adding credentials may vary depending on the version of Looker being used.

41 streams

Every table you can sync from Looker

  • Boards

  • Board Items

  • Board Sections

  • Color Collections

  • Connections

  • Content Metadata

  • Content Metadata Access

  • Dashboards

  • Dashboard Elements

  • Dashboard Filters

  • Dashboard Layout Components

  • Dashboard Layouts

  • Datagroups

  • Folders

  • Folder Ancestors

  • Groups

  • Integration Hubs

  • Integrations

  • Legacy Features

  • Lookml Models

  • Looks

  • Run Looks

  • Projects

  • Project Files

  • Git Branches

  • Primary Homepage Sections

  • Query History

  • Roles

  • Model Sets

  • Permission Sets

  • Permissions

  • Role Groups

  • Scheduled Plans

  • User Attributes

  • User Attribute Group Values

  • User Login Lockouts

  • Users

  • User Attribute Values

  • User Sessions

  • Versions

  • Workspaces

Authentication

Authenticate Looker once

  • Client Secret

    The Client Secret is second part of an API3 key.

Explore

Related connectors

MetabaseProduct AnalyticsStandard Sources cloudself-managed-enterprise
MixpanelProduct AnalyticsStandard Sources cloudself-managed-enterprise
MuxProduct AnalyticsStandard Sources cloudself-managed-enterprise
PendoProduct AnalyticsStandard Sources cloudself-managed-enterprise
PlausibleProduct AnalyticsStandard Sources cloudself-managed-enterprise
PostHogProduct AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Looker's API provides access to a wide range of data categories, including:

1. User and account data: This includes information about users and their accounts, such as user IDs, email addresses, and account settings.

2. Query and report data: Looker's API allows users to retrieve data from queries and reports, including metadata about the queries and reports themselves.

3. Dashboard and visualization data: Users can access data about dashboards and visualizations, including the layout and configuration of these elements.

4. Data model and schema data: Looker's API provides access to information about the data model and schema, including tables, fields, and relationships between them.

5. Data access and permissions data: Users can retrieve information about data access and permissions, including which users have access to which data and what level of access they have.

6. Integration and extension data: Looker's API allows users to integrate and extend Looker with other tools and platforms, such as custom applications and third-party services.

Overall, Looker's API provides a comprehensive set of data categories that enable users to access and manipulate data in a variety of ways.

1. Open Looker and navigate to the Admin panel.

2. Click on "Connections" and then "New Connection".

3. Select "Airbyte" as the type of connection.

4. Enter a name for the connection and the URL for the Airbyte instance.

5. In the "Authentication" section, select "OAuth2" as the authentication method.

6. Enter the Client ID and Client Secret provided by Airbyte.

7. In the "Advanced" section, set the "API Version" to "v1".

8. Click "Test" to ensure the connection is successful.

9. Save the connection and navigate to the "Explore" panel.

10. Select the Airbyte connection as the data source and choose the relevant tables to explore.

Note: It is important to ensure that the Airbyte instance is properly configured and the necessary connectors are installed before attempting to connect to Looker. Additionally, the specific steps for adding credentials may vary depending on the version of Looker being used.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Looker data today

Free for 14 days on Airbyte Cloud. Set up the Looker connector once and let Airbyte keep it in sync.

Try it freeTalk to sales