--- title: "List Data Sources" method: GET path: "/gdc/dataload/dataSources" tags: ["cloudresource"] --- # List Data Sources `GET /gdc/dataload/dataSources` ## Request - Base URL: `https://secure.gooddata.com` - URL: `https://secure.gooddata.com/gdc/dataload/dataSources` - Auth: none declared List all Data Sources that are created by the currently authenticated user or shared with them.
**Response body parameters**
* `id` (string) specifies the unique identifier of the Data Source. * `owner` (string) specifies the identifier of the currently authenticated user. * `name` (string) specifies the name of the Data Source. * `prefix` (Snowflake, Redshift, BigQuery, PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics; string) specifies the prefix that defines what tables and views will be populated to the GoodData platform. **Example:** `pre_` * `domain` (string) specifies the domain that the Data Source belongs to. * `alias` (string) specifies the alias of the Data Source; can be considered a secondary identifier. * `lastModified` (date) specifies when the Data Source was modified the last time. * `connectionInfo` (string) specifies the type of the data warehouse or object storage service. Can be `redshift`, `snowflake`, `bigQuery`, `postgres`, `mssql`, `mysql`, `s3`, `blobStorage`, or `generic`. * `url` (Snowflake, Redshift, PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics; string) specifies the JDBC connection string that is used to connect to the data warehouse. * `authentication` specifies authentication information that is used to connect to the data warehouse. * (Snowflake, Redshift, PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics) Basic user-password authentication * `userName` (string) specifies the user who is used for the connection. * `password` (string) is an empty string that serves as a placeholder for the user password. The password itself is never visible. * (Redshift only) IAM key-based access control authentication * `dbUser` (string) specifies the Redshift database user. * `accessKeyId` (string) specifies the access key ID for the IAM user who is authorized to access the Redshift data warehouse. * `secretAccessKey` (string) is an empty string that serves as a placeholder for the secret access key for the IAM user. The secret access key itself is never visible. * (BigQuery only) Service account authentication * `clientEmail` (string) specifies the BigQuery user email. * `privateKey` (string) is an empty string that serves as a placeholder for the private key for the BigQuery user. The private key itself is never visible. * (Azure SQL Database or Azure Synapse Analytics) Azure Active Directory user-password authentication * `userName` (string) specifies the user who is used for the connection. * `password` (string) is an empty string that serves as a placeholder for the user password. The password itself is never visible. * `database` (Snowflake, Redshift, PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics; string) specifies the name of the database where the schema you want to use is located. * `schema` (Snowflake, Redshift, PostgreSQL, BigQuery, Microsoft SQL Server, Azure SQL Database, or Azure Synapse Analytics; string) specifies the name of the schema where data marts are located. * `warehouse` (string; Snowflake only) specifies the name of the Snowflake data warehouse (computing unit) for integrating queries. * `project` (string; BigQuery only) specifies the name of the BigQuery project. * `params` (generic only) specifies parameters as a key/value pair. * `secureParams` (generic only) specifies secure parameters as a key/value pair. The values of the secure parameters are replaced with empty strings. The values themselves are never visible. * `s3` (S3 only) specifies the S3 location where your configuration file is stored (you may or may not also use this S3 location to store the source data). * `bucket` (string) specifies the name of the S3 bucket. * `accessKey` (string) specifies the access key to the S3 bucket. * `secretKey` (string) is an empty string that serves as a placeholder for the secret key to the S3 bucket. The secret key itself is never visible. * `region` (string) specifies the code of the region of the S3 bucket. For the list of the region codes, see [AWS service endpoints](https://docs.aws.amazon.com/general/latest/gr/rande.html#regional-endpoints). * `serverSideEncryption` (boolean) specifies whether server-side encryption is enabled. * `blobStorage` (Azure Blob Storage only) specifies the Azure Blob Storage location and authentication information that is used to connect to the object storage service. * `container` (string) specifies the name of the container. * `rootPath` (string) specifies the path to the source data. * `connectionString` (string) is an empty string that serves as a placeholder for the connection string to the Azure Blob Storage location. The connection string itself is never visible. * `sslMode` (PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics) specifies the SSL mode to use when connecting to the database. Can be `prefer`, `require`, or `verify-full`. * `prefer` enables encryption if the server supports encryption. * `require` connects only if the server supports encryption. * `verify-full` connects to a server you specify only if it supports encryption and is trusted. * `databaseType` Specifies which SQL product to use depending on what value is used for `connectionInfo`. (string) * To use Microsoft SQL Server, Azure SQL Database, or Azure Synapse Analytics Data Sources, `connectionInfo` must be to `mssql`. The value of databaseType can be one of either `SQLServer`, `AzureSQL`, or `SynapseSQL`. * To use a MongoDB BI Connector data source, `connectionInfo` must be set to `mysql` and the value of `databaseType` must be set to `MongoDBConnector`. ## Response `200` OK - list data sources - DataSources - `dataSources` object, required - `items` DataSource[], required - `dataSource` DataSourceResponse, required - `name` string, required - `prefix` string - `alias` string - `connectionInfo` union, required - Snowflake - `snowflake` object, required - … - Redshift - `redshift` object, required - … - BigQuery - `bigQuery` object, required - … - Postgres - `postgres` object, required - … - MSSQL - `mssql` object, required - … - MySQL - `mysql` object, required - … - Generic - `generic` object, required - … - S3 - `s3` object, required - … - BlobStorage - `blobStorage` object, required - … - ADS - `ads` object, required - … - `id` string, required - `owner` string, required - `domain` string - `lastModified` string, required - `links` object, required - `self` string, uri, required - `parent` string, uri, required - `dataMapping` string, uri - `buildModelMapping` string, uri - `generateModel` string, uri - `generateOutputStage` string, uri - `validateConnection` string, uri - `paging` Paging, required: Paging structure containing link to the next page. - `next` string, uri, nullable: Uri to next page, when such page exists. - `links` object, required - `self` string, uri, required --- [API](https://skmtc.dev/gooddata/apis/gooddata-api-documentation.md) - [All operations](https://skmtc.dev/gooddata/apis/gooddata-api-documentation/llms.txt) - [OpenAPI document](https://skmtc.dev/gooddata/apis/gooddata-api-documentation/revisions/e5dc0ee6ab00?raw)