All posts

The Simplest Way to Make Looker Sublime Text Work Like It Should

You open Sublime Text, tweak a LookML file, and hit save. Nothing happens. Then you remember your Looker model syncs through Git, which lives on a VPN, behind SSO, managed by whoever just went on vacation. You could spend an hour sorting it out—or five minutes making Looker and Sublime Text act like proper teammates. Looker turns business data into insights through models defined in LookML. Sublime Text is the editor you wish every web tool borrowed syntax highlighting from. When you pair them,

Free White Paper

End-to-End Encryption + Sarbanes-Oxley (SOX) IT Controls: The Complete Guide

Architecture patterns, implementation strategies, and security best practices. Delivered to your inbox.

Free. No spam. Unsubscribe anytime.

You open Sublime Text, tweak a LookML file, and hit save. Nothing happens. Then you remember your Looker model syncs through Git, which lives on a VPN, behind SSO, managed by whoever just went on vacation. You could spend an hour sorting it out—or five minutes making Looker and Sublime Text act like proper teammates.

Looker turns business data into insights through models defined in LookML. Sublime Text is the editor you wish every web tool borrowed syntax highlighting from. When you pair them, you turn data modeling into real engineering: fast, local, and version-controlled. The trick is connecting them so that identity, commits, and deployment flow smoothly and securely.

How to connect Looker and Sublime Text effectively

Start local. Clone your LookML project from Looker’s Git integration using a personal access token or an identity provider with OIDC. Open that repo in Sublime Text. Enable autosave if you’re confident, or manual commits if your rollout process is strict. Push changes right back to the Looker-hosted repo. Each commit triggers Looker’s internal validator, which checks syntax and dependency graphs. The model updates only after validation passes, keeping prod safe while letting you edit quickly.

The core logic is simple: keep Git as the truth, let Looker read from it, and use Sublime Text as a high-speed editing layer. Your brain stays in code, not browser tabs.

A quick troubleshooting guide

If pushes fail, check that your Git remote uses HTTPS rather than SSH unless your org allows key forwarding. Looker’s validation logs will name any missing views or explores. Fix them locally, commit again, watch the validator go green. Set branch protection rules through GitHub or GitLab to enforce review before deploy.

Continue reading? Get the full guide.

End-to-End Encryption + Sarbanes-Oxley (SOX) IT Controls: Architecture Patterns & Best Practices

Free. No spam. Unsubscribe anytime.

Benefits

  • Faster iteration on LookML and dashboards
  • Local autosave and syntax magic from Sublime Text
  • Centralized Git-based review and rollback
  • Full use of corporate SSO with minimum context switching
  • Predictable deployment and audit-ready diffs

Why this workflow actually feels better

Once you edit LookML locally, latency disappears. The feedback loop shrinks from minutes to seconds, and the keyboard never leaves home row. Developer velocity improves because there’s no waiting for browser editors or ephemeral sessions to load. Every change is versioned like real software, which means onboarding new analysts feels like adding engineers, not spectators.

Platforms like hoop.dev turn those access rules into guardrails that enforce policy automatically. You wire your identity provider, map users to data models, and hoop.dev ensures each push or deploy occurs under verified context. It keeps compliance boxes checked without nagging your editor.

How do I add security to a Looker Sublime Text workflow?

Use your existing IdP such as Okta or AWS IAM to issue scoped tokens. Ensure Looker projects require OAuth or SAML authentication. Limit permissions by branch ownership instead of per-user toggles. This keeps credentials short-lived and traceable across every commit.

The simplest way to sum it up: treat your Looker models like software, and your Sublime Text like the IDE it is. That mindset turns data modeling from a slow approval chain into a fast, auditable workflow built for real developers.

See an Environment Agnostic Identity-Aware Proxy in action with hoop.dev. Deploy it, connect your identity provider, and watch it protect your endpoints everywhere—live in minutes.

Get started

See hoop.dev in action

One gateway for every database, container, and AI agent. Deploy in minutes.

Get a demoMore posts