Skip to main content

vw_database_migrations_mongo_to_cosmos_db_ru_mongo

Creates, updates, deletes, gets or lists a vw_database_migrations_mongo_to_cosmos_db_ru_mongo resource.

Overview​

Namevw_database_migrations_mongo_to_cosmos_db_ru_mongo
TypeView
Idazure.data_migration.vw_database_migrations_mongo_to_cosmos_db_ru_mongo

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.kind') as "kind",
JSON_EXTRACT(properties, '$.scope') as "scope",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.migrationStatus') as "migration_status",
JSON_EXTRACT(properties, '$.startedOn') as "started_on",
JSON_EXTRACT(properties, '$.endedOn') as "ended_on",
JSON_EXTRACT(properties, '$.migrationService') as "migration_service",
JSON_EXTRACT(properties, '$.migrationOperationId') as "migration_operation_id",
JSON_EXTRACT(properties, '$.migrationFailureError') as "migration_failure_error",
JSON_EXTRACT(properties, '$.provisioningError') as "provisioning_error",
JSON_EXTRACT(properties, '$.sourceMongoConnection') as "source_mongo_connection",
JSON_EXTRACT(properties, '$.targetMongoConnection') as "target_mongo_connection",
JSON_EXTRACT(properties, '$.collectionList') as "collection_list",
subscriptionId,
resourceGroupName,
targetResourceName,
migrationName
FROM azure.data_migration.database_migrations_mongo_to_cosmos_db_ru_mongo
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND targetResourceName = 'replace-me' AND migrationName = 'replace-me';