Operations the current user is able to perform on this object
id
lock
string
Unique Id
first_name
lock
string
First Name
last_name
lock
string
Last Name
display_name
lock
string
Full name for display (available only if both first_name and last_name are set)
avatar_url
lock
string
URL for the avatar image (may be generic)
url
lock
string
Link to get this item
explore_url
lock
string
Explore page URL for this SQL query
plaintext
lock
boolean
Should this query be rendered as plain text
vis_config
object
Visualization configuration properties. These properties are typically opaque and differ based on the type of visualization used. There is no specified set of allowed keys. The values can be any type supported by JSON. A "type" key with a string value is often present, and is used by Looker to determine which visualization to present. Visualizations ignore unknown vis_config properties.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-20 UTC."],[],[],null,["# SqlQuery\n\nVersion 4.0.25.14 (latest) \nDatatype \nDescription \n(object) \nobject \ncan \n*lock* \nobject \nOperations the current user is able to perform on this object \nslug \n*lock* \nstring \nThe identifier of the SQL query \nlast_runtime \n*lock* \nnumber \nNumber of seconds this query took to run the most recent time it was run \nrun_count \n*lock* \ninteger \nNumber of times this query has been run \nbrowser_limit \n*lock* \ninteger \nMaximum number of rows this query will display on the SQL Runner page \nsql \n*lock* \nstring \nSQL query text \nlast_run_at \n*lock* \nstring \nThe most recent time this query was run \nconnection \n*lock* \n[DBConnectionBase](/looker/docs/reference/looker-api/latest/types/DBConnectionBase) \nConnection this query uses\nExpand DBConnectionBase definition... \ncan \n*lock* \nobject \nOperations the current user is able to perform on this object \nname \n*lock* \nstring \nName of the connection. Also used as the unique identifier \ndialect \n*lock* \n[Dialect](/looker/docs/reference/looker-api/latest/types/Dialect) \n(Read-only) SQL Dialect details\nExpand Dialect definition... \nname \n*lock* \nstring \nThe name of the dialect \nlabel \n*lock* \nstring \nThe human-readable label of the connection \nsupports_cost_estimate \n*lock* \nboolean \nWhether the dialect supports query cost estimates \ncost_estimate_style \n*lock* \nstring \nHow the dialect handles cost estimation \npersistent_table_indexes \n*lock* \nstring \nPDT index columns \npersistent_table_sortkeys \n*lock* \nstring \nPDT sortkey columns \npersistent_table_distkey \n*lock* \nstring \nPDT distkey column \nsupports_streaming \n*lock* \nboolean \nSupports streaming results \nautomatically_run_sql_runner_snippets \n*lock* \nboolean \nShould SQL Runner snippets automatically be run \nconnection_tests \nstring\\[\\] \nsupports_inducer \n*lock* \nboolean \nIs supported with the inducer (i.e. generate from sql) \nsupports_multiple_databases \n*lock* \nboolean \nCan multiple databases be accessed from a connection using this dialect \nsupports_persistent_derived_tables \n*lock* \nboolean \nWhether the dialect supports allowing Looker to build persistent derived tables \nhas_ssl_support \n*lock* \nboolean \nDoes the database have client SSL support settable through the JDBC string explicitly? \nsnippets \n[Snippet](/looker/docs/reference/looker-api/latest/types/Snippet)\\[\\] \nExpand Snippet definition... \nname \n*lock* \nstring \nName of the snippet \nlabel \n*lock* \nstring \nLabel of the snippet \nsql \n*lock* \nstring \nSQL text of the snippet \npdts_enabled \n*lock* \nboolean \nTrue if PDTs are enabled on this connection \nmodel_name \n*lock* \nstring \nModel name this query uses \ncreator \n*lock* \n[UserPublic](/looker/docs/reference/looker-api/latest/types/UserPublic) \nUser who created this SQL query\nExpand UserPublic definition... \ncan \n*lock* \nobject \nOperations the current user is able to perform on this object \nid \n*lock* \nstring \nUnique Id \nfirst_name \n*lock* \nstring \nFirst Name \nlast_name \n*lock* \nstring \nLast Name \ndisplay_name \n*lock* \nstring \nFull name for display (available only if both first_name and last_name are set) \navatar_url \n*lock* \nstring \nURL for the avatar image (may be generic) \nurl \n*lock* \nstring \nLink to get this item \nexplore_url \n*lock* \nstring \nExplore page URL for this SQL query \nplaintext \n*lock* \nboolean \nShould this query be rendered as plain text \nvis_config \nobject \nVisualization configuration properties. These properties are typically opaque and differ based on the type of visualization used. There is no specified set of allowed keys. The values can be any type supported by JSON. A \"type\" key with a string value is often present, and is used by Looker to determine which visualization to present. Visualizations ignore unknown vis_config properties. \nresult_maker_id \nstring \nID of the ResultMakerLookup entry.\n\nRelated Methods\n---------------\n\n- [Query/create_sql_query](../methods/Query/create_sql_query \"Query/create_sql_query\")\n- [Query/sql_query](../methods/Query/sql_query \"Query/sql_query\")\n\nRelated Types\n-------------\n\n- [RunningQueries](./RunningQueries \"RunningQueries\")"]]
