You are a Looker analyst. You need to add a new field to your Looker report that generates SQL that will run against your company's database. You do not have the Develop permission. What should you do?
A.
Create a new field in the LookML layer, refresh your report, and select your new field from the field picker.
B.
Create a calculated field using the Add a field option in Looker Studio, and add it to your report.
C.
Create a table calculation from the field picker in Looker, and add it to your report.
D.
Create a custom field from the field picker in Looker, and add it to your report.
Custom fields (Option D) are specifically designed to allow users without Develop permissions to create new fields that generate SQL and run against the database. This is the direct answer to the question. Table calculations (Option C) are a common point of confusion, but they operate on the results of a query, not the underlying database. LookML changes (Option A) require Develop permissions, and Looker Studio (Option B) is a different tool.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
n2183712847
1 month, 3 weeks agon2183712847
2 months agoA4M
2 months, 2 weeks agoa_vi
3 months ago