Count
count.co
  • Getting Started
    • What is Count?
    • Count FAQ
    • Intro to your workspace
    • Example canvases
    • Getting started guides
      • Set up your workspace and projects
        • 1. Review workspace settings
        • 2. Create and organise your projects
      • Canvas orientation
      • Your first ad hoc analysis
        • 1. Examples and templates
        • 2. Build your first queries
        • 3. Create visuals
        • 4. Caching, local cells and scheduling
        • 5. Collaborating with a stakeholder
      • Your first report
        • 1. Examples and templates
        • 2. Filters and control cells
        • 3. Sharing your report
        • 4. Alerts
  • Connect your data
    • Database connection overview
      • Athena
      • Azure Synapse
      • BigQuery
      • Databricks
      • Microsoft SQL Server
      • MySQL
      • PostgreSQL
      • Redshift
      • Snowflake
    • Refresh database schema
    • Upload CSV files
    • dbt integration
      • ☁️dbt Cloud integration
      • 👩‍💻dbt Core integration
  • Import & Export
    • Import from other tools
      • Import Miro files
      • Import SQL files
      • Import Google Sheets
      • Import Jupyter notebooks
    • Export code and results
      • Export compiled SQL and Jinja-SQL
      • Export CSV files
      • Export images and PDF files
  • THE CANVAS
    • Navigating the canvas
      • Canvas tool bar
      • Data sidebar
      • Customizing the canvas
    • Canvas objects
      • Cells
      • Text and markdown
      • Shapes and tools
      • Sticky notes
      • Frames
      • Images
      • Embeds
      • Stamps
      • Grouping objects
      • Object order and alignment
      • Locking objects
      • Scaling objects
      • Shared styles
    • Overviews
    • Templates
    • Count AI
    • Alerts and subscriptions
      • Slack integration
    • Keyboard shortcuts
  • Querying data
    • Cells overview
      • Dynamic query compilation engine
    • SQL cells
      • Referencing other cells
      • Jinja templating
      • SQL formatting
    • Python cells
    • Visual and low-code cells
      • Calculations in visuals and low-code cells
      • Joins in visuals and low-code cells
    • Control cells
      • Single and multiple selects
      • Date controls
      • Text, number, and boolean controls
      • Custom control cells
    • Local DuckDB cells
      • DuckDB on the server
    • Query caching and scheduling
    • Manage queries and results
    • Troubleshooting
  • Visualizing data
    • Visualization overview
    • Templated visuals
    • Custom visuals
      • Marks
      • Facet
      • Subplots
      • Style
      • Filters
    • Formatting a visual
      • Axes
        • Secondary Axis
      • Colors and labels
      • Legends
      • Tooltips
    • Column summaries
    • Dynamic text
    • Every Visual Under the Sun
  • Presenting and Reporting
    • Reports and Slides
  • Count Metrics
    • Intro to Count Metrics
    • Build and edit a catalog
    • Views
      • Creating views
      • Customizing views
    • Datasets
      • Creating datasets
    • Save changes to the catalog
      • Catalog validation
      • Version control
    • Exposing catalogs to the workspace
    • Caching in Count Metrics
    • Using the catalog
      • Explore from cell
  • Sharing and Permissions
    • Real-time collaboration
    • Comments
    • Sharing permissions
    • Shared links
    • Embedding canvases
  • History and Versions
    • Version control
    • Duplicating and merging
    • Data snapshots
  • Settings and administration
    • Workspace settings
      • Workspace members
      • Groups
      • Tags
      • Billing
      • Single sign-on (SSO)
        • Okta
        • Entra ID
        • JumpCloud
        • Google
        • Generic OIDC
      • Brand
    • Connection settings
    • Project settings
    • User settings
    • Roles and permissions
  • Quick guides
    • Interactive control guides
      • Date ranges
      • Date groupings
      • Search
      • Select All
  • Resources
    • Join the Slack community
  • Blog
  • Security overview
  • Terms of use
  • Pricing FAQ
Powered by GitBook
On this page
  • Connect
  • Introduction
  • Create and configure a Looker integration
  • Querying through Looker
  1. Connect your data

Looker integration

Import and query your Looker models within Count

Last updated 7 months ago

Connect

Count's Looker integration is an enterprise feature. Please consult our page for more information.

Introduction

is a BI application that uses its modelling layer (LookML) to provide a single place to curate and govern business metrics.

Count's Looker integration allows you to import and leverage your LookML logic in Count.

Create and configure a Looker integration

In an existing database connection, select Manage connection, then select the Looker tab.

To connect you will need

Selecting models to import

Once your credentials have been verified you will need to select one or more models to import.

After you select a model and click Update, Count's servers will contact Looker and retrieve information on those models. This step can take several minutes.

Compiled query caching

Access current development branch

Enabling development mode may break existing Looker cell queries and visuals in your canvases.

By default, models are loaded using your Looker production directory and production branch. To load models and compile queries using your current development branch, turn on Enable development mode in the Looker settings tab and click Update.

If development mode is enabled, changing your current branch within Looker may break existing Looker cells and queries in your canvases.

To use Looker integrations in both production and development mode within the same canvas, create two database connections to the same database (each sensibly named), creating one Looker integration in each; one with Enable development mode turned off, and one with it turned on.

Querying through Looker

Data bar

Using the dropdown or search bar you can navigate your Looker Explores, Views and Fields, and create cells from individual Fields by pressing the + icon.

Creating Looker cells

Referencing Looker cells

Within a canvas, your Looker cell behave like any other cell, which means you can reference them and use them to start building your analysis.

Looker API URL: This is the unique URL that identifies the API access route for your Looker instance. Your Looker Admin should know how to find it. Read more about Looker API URLs .

Client ID and secret: You will first need to create API credentials for Count to connect to your Looker instance with. Count will authenticate as this user, so configure permissions for that user in Looker appropriately. Read more about API authentication .

Count uses Looker to generate SQL queries for your models. Each compilation step can take several seconds (depending on the number and complexity of compilations requested). Additionally, the Looker API has to protect its own servers. To reduce compilation latency and the number of requests to the Looker API, you can optionally choose to save compiled SQL queries for 24 hours securely within Count's servers. Click Update to save any changes.

Your current development branch can be set within Looker, using the instructions found .

Once your models have been successfully imported from Count, you will be able to start querying them within a .

In a canvas, you will be able to see information on your Looker Explores, as well as when this information was last imported, in the left side .

Looker models can be queried from . To query your Looker models in these cells, select the Explore tab in the cell data source list.

Then you can select (click or drag) the Looker fields from which you wish to create a query, as well as defining filters as well as other visual parameters, just as you would in a normal or cell.

here
here
enforced rate limits
here
canvas
data bar
visual or low-code cells
Low code
Visual
Pricing
Looker