Endpoint

Get List of Databases

Name

get_databases

Gets a list of the databases in the current database account. [API reference]

Parameter	Label	Required	Options	Description
MaxItemCount	Max Rows Per Page (Adjust for Speed)	NO		An integer indicating the maximum number of items to be returned per page.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(255)`	255	`False`	The unique name that identifies the collection.
ResourceId	`DT_WSTR`	`nvarchar(2000)`	2000	`False`	System generated property. The resource ID is a unique identifier that is also hierarchical per the resource stack on the resource model. It is used internally for placement and navigation of the permission resource.
LastUpdated	`DT_I4`	`int`		`False`	System generated property. Specifies the last updated timestamp of the resource.
ETag	`DT_WSTR`	`nvarchar(4000)`	4000	`False`	System generated property representing the resource etag required for optimistic concurrency control.
Collections	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Users	`DT_WSTR`	`nvarchar(4000)`	4000	`False`

If the column you are looking for is missing, consider customizing Cosmos DB Connector.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Use Cosmos DB Connector in API Source component to read data or in API Destination component to read/write data:

This Endpoint belongs to SysDatabases table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Cosmos DB

SysDatabases

Select

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_databases

Lists all databases for specified Cosmos DB Account

SELECT * FROM SysDatabases

get_databases endpoint belongs to SysDatabases table(s), and can therefore be used via those table(s).

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_databases';

EXEC (@MyQuery) AT [LS_TO_COSMOS_DB_IN_GATEWAY];

Lists all databases for specified Cosmos DB Account

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM SysDatabases';

EXEC (@MyQuery) AT [LS_TO_COSMOS_DB_IN_GATEWAY];

get_databases endpoint belongs to SysDatabases table(s), and can therefore be used via those table(s).