Skip to main content

Update authentication settings

LiveData Migrator for Azure lets you update the authentication settings for your migration and metadata targets.

note

LiveData Migrator for Azure doesn’t currently support switching from access key to service principal.

Update authentication settings with the UI​

Update authentication settings for your migration target​

  1. In the Azure Portal, navigate to the LiveData Migrator resource page.
  2. Access the Overview page.
  3. Select the target you want to update.
  4. Select the Authentication Settings tab.
    note

    Options for your target type appear here.

    • Service principal ID and secret
      1. Select a Service principal type:
        • Select existing
        • Create new
      2. Select a Service principal:
        • Create new
        • Make selection
          1. Select your service principal from the Select an application panel that appears, then select Submit.
          2. Enter your service principal client secret in the Client Secret field.
      3. Select Submit.
    • Storage access key
      In the Authentication Settings panel that appears, select Submit to update with the Primary Access Token from your storage account.
  5. After receiving a successful update notification, restart the LiveData Migrator service.
    info

    After restarting the LiveData Migrator service, check your data migrations and manually start any in a Paused state.

Update authentication settings for your metadata target​

note

Before updating authentication settings, stop any migrations to the metadata target. After you've updated your credentials, restart the migrations.

  1. In the Azure Portal, navigate to the LiveData Migrator resource page.
  2. Access the Overview page.
  3. Select the metadata target you want to update.
  4. Select the Authentication Settings tab.
    note

    Options for your metadata target type appear here.

    • Databricks
      Enter your Access Token.
    • Snowflake
      • Username and password
        1. Enter your Username and Password.
        2. Reenter your password in the Confirm password field.
      • Private key file
        1. Enter a path to the location of your Private Key File (in PEM format) to use for key pair authentication.
        2. Enter your Private Key File Passphrase (if applicable) used with the private key for Snowflake.
        3. Reenter your Private Key File Passphrase in the Confirm password field.
    • Azure SQL
      Enter your SQL Username and SQL Password.
  5. Select Submit.
  6. If you're unable to restart your metadata migrations after receiving a successful update notification, restart the LiveData Migrator and Hive Migrator services.

Update authentication settings with the CLI​

Update authentication settings for your Azure Data Lake Storage (ADLS) Gen2 migration target with the CLI​

You can update authentication settings for ADLS targets using the target update authentication command.

Update authentication settings for your Azure SQL metadata target with the CLI​

You can update authentication settings for Azure SQL metadata targets using the metadata-target azure-sql update-authentication command.