[[["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,["# Get columns for a connection\n\nVersion 4.0.25.14 (latest)\n\n### Get the columns (and therefore also the tables) in a specific schema\n\nRequest\n-------\n\nGET /connections/{connection_name}/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... \ndatabase \nstring \nFor dialects that support multiple databases, optionally identify which to use \nschema_name \nstring \nName of schema to use. \ncache \nboolean \nTrue to fetch from cache, false to load fresh \ntable_limit \ninteger \nlimits the tables per schema returned \ntable_names \nstring \nonly fetch columns for a given (comma-separated) list of tables \nfields \nstring \nRequested fields.\n\nResponse\n--------\n\n### 200: Columns schema for connection\n\nDatatype \nDescription \n(array) \n[SchemaColumns](/looker/docs/reference/looker-api/latest/types/SchemaColumns)\\[\\] \nname \n*lock* \nstring \nSchema item name \nsql_escaped_name \n*lock* \nstring \nFull name of item \nschema_name \n*lock* \nstring \nName of schema \ncolumns \n[SchemaColumn](/looker/docs/reference/looker-api/latest/types/SchemaColumn)\\[\\] \nExpand SchemaColumn definition... \nname \n*lock* \nstring \nSchema item name \nsql_escaped_name \n*lock* \nstring \nFull name of item \nschema_name \n*lock* \nstring \nName of schema \ndata_type_database \n*lock* \nstring \nSQL dialect data type \ndata_type \n*lock* \nstring \nData type \ndata_type_looker \n*lock* \nstring \nLooker data type \ndescription \n*lock* \nstring \nSQL data type \ncolumn_size \n*lock* \ninteger \nColumn data size \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\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"]]
