Search a connection for columns
Stay organized with collections
Save and categorize content based on your preferences.
Version 4.0.25.14 (latest)
Search a connection for columns matching the specified name
Note: column_name must be a valid column name. It is not a search pattern.
Request
GET
/connections/{connection_name}/search_columns
Expand HTTP Path definition...
connection_name
string
Name of connection
Expand HTTP Query definition...
column_name
string
Column name to find
fields
string
Requested fields.
Response
200: Column names matching search pattern
schema_name
lock
string
Name of schema containing the table
table_name
lock
string
Name of table containing the column
column_name
lock
string
Name of column
data_type
lock
string
Column data type
400: Bad Request
message
lock
string
Error details
documentation_url
lock
string
Documentation link
404: Not Found
message
lock
string
Error details
documentation_url
lock
string
Documentation link
422: Validation Error
message
lock
string
Error details
Expand ValidationErrorDetail definition...
field
lock
string
Field with error
code
lock
string
Error code
message
lock
string
Error info message
documentation_url
lock
string
Documentation link
documentation_url
lock
string
Documentation link
429: Too Many Requests
message
lock
string
Error details
documentation_url
lock
string
Documentation link
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-20 UTC.
[[["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,["# Search a connection for columns\n\nVersion 4.0.25.14 (latest)\n\n### Search a connection for columns matching the specified name\n\n**Note** : `column_name` must be a valid column name. It is not a search pattern.\n\nRequest\n-------\n\nGET /connections/{connection_name}/search_columns \nDatatype \nDescription \nRequest \nHTTP Request \npath \nHTTP Path \nExpand HTTP Path definition... \nconnection_name \nstring \nName of connection \nquery \nHTTP Query \nExpand HTTP Query definition... \ncolumn_name \nstring \nColumn name to find \nfields \nstring \nRequested fields.\n\nResponse\n--------\n\n### 200: Column names matching search pattern\n\nDatatype \nDescription \n(array) \n[ColumnSearch](/looker/docs/reference/looker-api/latest/types/ColumnSearch)\\[\\] \nschema_name \n*lock* \nstring \nName of schema containing the table \ntable_name \n*lock* \nstring \nName of table containing the column \ncolumn_name \n*lock* \nstring \nName of column \ndata_type \n*lock* \nstring \nColumn data type\n\n### 400: Bad Request\n\nDatatype \nDescription \n(object) \n[Error](/looker/docs/reference/looker-api/latest/types/Error) \nmessage \n*lock* \nstring \nError details \ndocumentation_url \n*lock* \nstring \nDocumentation link\n\n### 404: Not Found\n\nDatatype \nDescription \n(object) \n[Error](/looker/docs/reference/looker-api/latest/types/Error) \nmessage \n*lock* \nstring \nError details \ndocumentation_url \n*lock* \nstring \nDocumentation link\n\n### 422: Validation Error\n\nDatatype \nDescription \n(object) \n[ValidationError](/looker/docs/reference/looker-api/latest/types/ValidationError) \nmessage \n*lock* \nstring \nError details \nerrors \n[ValidationErrorDetail](/looker/docs/reference/looker-api/latest/types/ValidationErrorDetail)\\[\\] \nExpand ValidationErrorDetail definition... \nfield \n*lock* \nstring \nField with error \ncode \n*lock* \nstring \nError code \nmessage \n*lock* \nstring \nError info message \ndocumentation_url \n*lock* \nstring \nDocumentation link \ndocumentation_url \n*lock* \nstring \nDocumentation link\n\n### 429: Too Many Requests\n\nDatatype \nDescription \n(object) \n[Error](/looker/docs/reference/looker-api/latest/types/Error) \nmessage \n*lock* \nstring \nError details \ndocumentation_url \n*lock* \nstring \nDocumentation link"]]
