Mirrored database definition

This article provides a breakdown of the structure for mirrored database definition items.

Supported formats

Mirrored database items support the JSON format.

Definition parts

The definition of a mirrored database item is constructed as follows:

• Path: The path to the file that contains the JSON definition, for example mirroring.json.
• Payload: See Example of payload content decoded from Base64
• PayloadType: InlineBase64

Example of payload content decoded from Base64

To see how to create a JSON definition file describing a mirrored database for different types of sources, see mirrored database definitions for various sources.

{
    "properties": {
        "source": {
            "type": "Snowflake",
            "typeProperties": {
                "connection": "a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1",
                "database": "TESTDB"
            }
        },
        "target": {
            "type": "MountedRelationalDatabase",
            "typeProperties": {
                "defaultSchema": "dbo",
                "format": "Delta"
            }
        },
        "mountedTables": [
            {
                "source": {
                    "typeProperties": {
                        "schemaName": "dbo",
                        "tableName": "testtable"
                    }
                }
            }
        ]
    }
}

Definition example

{
    "parts": [
      {
        "path": "mirroring.json",
        "payload": "eyJwcm9wZXJ0aWVzIjp7InNvdXJjZSI6eyJ0eXBlIjoiU25vd2ZsYWtlIiwidHlwZVByb3BlcnRpZXMiOnsiY29ubmVjdGlvbiI6IjAxYTBhNThjLTcxOGItNGE2MC05NjY3LTU4Yjg5NGRlY2UzNCIsImRhdGFiYXNlIjoiVEVTVERCIn19LCJ0YXJnZXQiOnsidHlwZSI6Ik1vdW50ZWRSZWxhdGlvbmFsRGF0YWJhc2UiLCJ0eXBlUHJvcGVydGllcyI6eyJkZWZhdWx0U2NoZW1hIjoiZGJvIiwiZm9ybWF0IjoiRGVsdGEifX0sIm1vdW50ZWRUYWJsZXMiOlt7InNvdXJjZSI6eyJ0eXBlUHJvcGVydGllcyI6eyJzY2hlbWFOYW1lIjoiZGJvIiwidGFibGVOYW1lIjoidGVzdHRhYmxlIn19fV19fQ==",
        "payloadType": "InlineBase64"
      }
    ]
  }