> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DESCRIBE DATA SOURCE

<a id="sql-desc-data-source" />

Outputs the configuration of an existing
[data source](/content/sql/ddl/create-data-source#sql-create-data-source).

```sql title="SHOW DATA SOURCE Syntax" theme={null}
DESC[RIBE] [EXTERNAL] DATA SOURCE < [<schema name>.]<data source name> | * >
```

## Parameters

<AccordionGroup>
  <Accordion title="EXTERNAL" id="external" defaultOpen>
    Optional keyword for clarity
  </Accordion>

  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* containing the *data source* to describe
  </Accordion>

  <Accordion title="<data source name>" id="<data-source-name>" defaultOpen>
    Name of the *data source* whose configuration will be output; use `*` instead of
    *schema*/*data source* name to output the configuration of all *data sources*
  </Accordion>
</AccordionGroup>

## Response

The response to `DESCRIBE DATA SOURCE` is a three-column result set:

| Output Column           | Description                                             |
| ----------------------- | ------------------------------------------------------- |
| `DATA_SOURCE`           | Name of the data source                                 |
| `STORAGE_PROVIDER_TYPE` | Keyword associated with storage provider                |
| `ADDITIONAL_INFO`       | *Data source* configuration; passwords will be redacted |

## Examples

To show the configuration for a *data source*, `kin_ds`:

```sql DESCRIBE DATA SOURCE Example theme={null}
DESCRIBE DATA SOURCE kin_ds
```

To show the configuration for all *data sources*:

```sql DESCRIBE DATA SOURCE (All Data Sources) Example theme={null}
DESCRIBE DATA SOURCE *
```