> ## Documentation Index > Fetch the complete documentation index at: https://confidence.spotify.com/llms.txt > Use this file to discover all available pages before exploring further. # List DataWarehouse > List data warehouses. The data warehouses are returned in no particular order. ## OpenAPI ````yaml /api/metrics/api/data-warehouse.openapi.json get /v1/dataWarehouses openapi: 3.1.0 info: title: Confidence Data-warehouse API version: 1.0.0 description: API documentation for data-warehouse servers: [] security: [] paths: /v1/dataWarehouses: get: summary: List DataWarehouse description: |- List data warehouses. The data warehouses are returned in no particular order. operationId: DataWarehouse.list parameters: - name: pageSize in: query required: false description: The maximum number of data warehouses to fetch. schema: type: object - name: pageToken in: query required: false description: Token used for pagination. schema: type: string responses: '200': description: OK content: application/json: schema: type: object properties: dataWarehouses: type: array items: $ref: '#/components/schemas/confidence.metrics.v1.DataWarehouse' description: List of data warehouses. nextPageToken: type: string description: Token to fetch the next page, empty if no more pages. required: - dataWarehouses security: - admin: [] servers: - url: https://metrics.eu.confidence.dev - url: https://metrics.us.confidence.dev - url: https://metrics.confidence.dev components: schemas: confidence.metrics.v1.DataWarehouse: title: DataWarehouse type: object description: |- Named configuration for a data warehouse. Sets up how to query and write data to the data warehouse. properties: name: type: string description: The name of the data warehouse. config: type: object properties: bigQueryConfig: type: object properties: gcpProjectId: type: string description: Project id. bigQueryLocation: type: string description: >- Location where the data will be stored, for example, 'EU' or 'US'. dataset: type: string description: Dataset where tables will be created. serviceAccount: type: string description: Service account that will be used. processingProjectId: type: string description: >- The project where the jobs will be calculated. Defaults to gcp_project_id if not set interactiveProjectId: type: string description: >- The project where the interactive (non-scheduled) jobs will be calculated. Defaults to processing_project_id if not set exportJobsServiceAccount: type: string description: >- The service account used to export to Cloud Storage. Defaults to service_account if not set description: Configuration for BigQuery. dataBricksConfig: type: object properties: host: type: string description: Host for the databricks instance. warehouseId: type: string description: Id of the warehouse used for running queries. clientId: type: string description: Client ID clientSecret: type: string description: Client secret access token. exposureSchema: type: string description: Name of the Confidence exposure schema. resultsSchema: type: string description: Name of the Confidence results schema. description: Configuration for Databricks. redshiftConfig: type: object properties: exposureSchema: type: string description: The dataset/schema where data will be written. region: type: string enum: - AWS_REGION_UNSPECIFIED - AP_SOUTH_2 - AP_SOUTH_1 - EU_SOUTH_1 - EU_SOUTH_2 - US_GOV_EAST_1 - ME_CENTRAL_1 - IL_CENTRAL_1 - CA_CENTRAL_1 - EU_CENTRAL_1 - US_ISO_WEST_1 - EU_CENTRAL_2 - US_WEST_1 - US_WEST_2 - AF_SOUTH_1 - EU_NORTH_1 - EU_WEST_3 - EU_WEST_2 - EU_WEST_1 - AP_NORTHEAST_3 - AP_NORTHEAST_2 - AP_NORTHEAST_1 - ME_SOUTH_1 - SA_EAST_1 - AP_EAST_1 - CN_NORTH_1 - US_GOV_WEST_1 - AP_SOUTHEAST_1 - AP_SOUTHEAST_2 - US_ISO_EAST_1 - AP_SOUTHEAST_3 - AP_SOUTHEAST_4 - US_EAST_1 - US_EAST_2 - CN_NORTHWEST_1 description: AWS region. roleArn: type: string description: The role Confidence assumes on the AWS side. cluster: type: string description: The redshift cluster. database: type: string description: The redshift database. dataApiEndpoint: type: string description: >- Override the Data Api endpoint. If not set, the default endpoint will be used. credentialsSettings: type: object properties: accessKeyId: type: string description: The access key id for the IAM user. secretAccessKey: type: string description: The secret access key for the IAM user. required: - accessKeyId webIdentitySettings: type: object required: - region - roleArn - cluster - database description: Configuration for Redshift. snowflakeConfig: type: object properties: account: type: string description: The snowflake account name. user: type: string description: The snowflake user. authenticationKey: type: string description: The crypto key used to sign the JWT token role: type: string description: The snowflake role. warehouse: type: string description: The warehouse used to execute the queries. exposureDatabase: type: string description: The database that contains the exposure schema. exposureSchema: type: string description: The schema that will contain the exposure tables. required: - account - user - authenticationKey - role - warehouse - exposureDatabase - exposureSchema description: Configuration for Snowflake. description: The configuration for the data warehouse. limits: type: object properties: maxConcurrentQueries: type: integer description: >- Maximum number of concurrent queries that can be submitted towards the data warehouse. If set to 0 there is no limit. maxConcurrentInteractiveQueries: type: integer description: >- Maximum number of concurrent interactive (non-scheduled) queries that can be submitted towards the data warehouse. If set to 0 throttling is done using max_concurrent_queries and ignoring the type of query. description: User-defined restrictions for how to access the data warehouse. createTime: type: object description: Time when the data warehouse was first created. updateTime: type: object description: Time when the data warehouse was last updated. labels: type: array items: type: object additionalProperties: type: string description: General labels for this resource. creator: type: string description: Reference to the identity that created this entity. updater: type: string description: Reference to the identity that last updated this entity. owner: type: string description: The owner of the resource. If not set will default to the creator. required: - config - createTime - updateTime - creator - updater securitySchemes: admin: type: http scheme: bearer ````