About fabio1

fabio1 · 08-15-2023

Look At Me Sideways (LAMS) is an open-source LookML style guide and linter. LAMS v3.1 has just been released. This update introduces, as beta features, centrally managed exemptions, and an add-exemptions output mode. Together, these features serve to...

fabio1 · 07-13-2023

The BigQuery Information Schema block has, broadly, two main uses: monitoring and optimization. This article will focus on the optimization uses of the block, including how to locate problems and resolve common issues. Ways to locate issues Sometimes...

fabio1 · 07-13-2023

This article will guide users who are new to Looker to accelerate their first LookML project by building from concepts that are available in our sample LookML projects. Most new Looker instances come with built-in sample content, including sample dat...

fabio1 · 05-12-2022

Looker will not be updating this content, nor guarantees that everything is up-to-date. Suppose you want to build an Explore that lets users start from a "one" table and then fan out into more detailed "many" records from multiple tables. In this sit...

fabio1 · 05-10-2022

TutorialLooker will not be updating this content, nor guarantees that everything is up-to-date. Organizations often want to grant users access to run their own ad-hoc queries with Looker's SQL Runner tool, but sometimes with more limited access. Perh...

fabio1

In case you have sparse inventory/snapshot tables (that is, rows are only present for a given inventory/account on days when the value changed, rather than on every day), you can also incorporate a window function to pull through the latest value int...

fabio1 · 01-22-2024

Hi @priyanath In general, customers can reach the right support team starting from https://help.looker.com/ If you have a process that is specifically failing in incognito mode, it may be due to cookie settings. In addition to the troubleshooting pag...

fabio1 · 10-17-2023

Hey @mtajmouati I think some additional clarification of the question would really help.You can set constants in the manifest file and then use those constants in places where liquid evaluation is accepted (such as a sql parameter), but I'm not sure ...

fabio1 · 09-15-2023

Hi Anique! The idea behind this feature is that if at any point (for example, once manually, or upon merging a set of changes), you wish to exempt all current errors in future runs, you can run LAMS with --output=add-exemptions and check in the resul...

fabio1 · 08-28-2023

How can we access Service account JSON file uploaded in Authentication section of Database Connnections in Looker?Although there is an API to get the connection details, sensitive fields like the service account JSON are write-only. It is not possibl...

My Stats

fabio1's Bio

Badges fabio1 Earned

Recent Activity

New incremental linting option in LAMS LookML Linter (v3.1)

Using the BQ Info Schema Block

From Sample to Real - 5 Steps for Your First LookML Project

A Cure For the one_to_many Blues

Limiting SQL Runner Permissions

Re: Only measuring the "latest" values

Re: SSO Gives 401 in Chrome Incognito Window

Re: How to get explore name in the manifest file

Re: Introducing LAMS, a LookML style guide and linter

Re: Inquiry about Making API Calls and Passing Credentials in Looker Platform and Custom Visualizati