Get schemas for a connection
Stay organized with collections
Save and categorize content based on your preferences.
Version 4.0.25.14 (latest)
Get the list of schemas and tables for a connection
Request
GET
/connections/{connection_name}/schemas
Expand HTTP Path definition...
connection_name
string
Name of connection
Expand HTTP Query definition...
database
string
For dialects that support multiple databases, optionally identify which to use
cache
boolean
True to use fetch from cache, false to load fresh
fields
string
Requested fields.
Response
200: Schemas for connection
name
lock
string
Schema name
is_default
lock
boolean
True if this is the default schema
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,["# Get schemas for a connection\n\nVersion 4.0.25.14 (latest)\n\n### Get the list of schemas and tables for a connection\n\nRequest\n-------\n\nGET /connections/{connection_name}/schemas \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 \ncache \nboolean \nTrue to use fetch from cache, false to load fresh \nfields \nstring \nRequested fields.\n\nResponse\n--------\n\n### 200: Schemas for connection\n\nDatatype \nDescription \n(array) \n[Schema](/looker/docs/reference/looker-api/latest/types/Schema)\\[\\] \nname \n*lock* \nstring \nSchema name \nis_default \n*lock* \nboolean \nTrue if this is the default 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"]]
