[[["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 tables for a connection\n\nVersion 4.0.25.14 (latest)\n\n### Get the list of tables for a schema\n\nFor dialects that support multiple databases, optionally identify which to use. If not provided, the default\ndatabase for the connection will be used.\n\nFor dialects that do **not** support multiple databases, **do not use** the database parameter\n\nRequest\n-------\n\nGET /connections/{connection_name}/tables \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 \nOptional. Name of database to use for the query, only if applicable \nschema_name \nstring \nOptional. Return only tables for this schema \ncache \nboolean \nTrue to fetch from cache, false to load fresh \nfields \nstring \nRequested fields. \ntable_filter \nstring \nOptional. Return tables with names that contain this value \ntable_limit \ninteger \nOptional. Return tables up to the table_limit\n\nResponse\n--------\n\n### 200: Schemas and tables for connection\n\nDatatype \nDescription \n(array) \n[SchemaTables](/looker/docs/reference/looker-api/latest/types/SchemaTables)\\[\\] \nname \n*lock* \nstring \nSchema name \nis_default \n*lock* \nboolean \nTrue if this is the default schema \ntables \n[SchemaTable](/looker/docs/reference/looker-api/latest/types/SchemaTable)\\[\\] \nExpand SchemaTable 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 \nrows \n*lock* \ninteger \nNumber of data rows \nexternal \n*lock* \nstring \nExternal reference??? \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 \ntable_limit_hit \n*lock* \nboolean \nTrue if the table limit was hit while retrieving tables in this schema\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"]]
