Import from Azure Synapse

If you have data stored online in Microsoft Azure Synapse, you can import this data easily to the Peltarion Platform and start training models on it.

In the Datasets view, click on the Azure Synapse button. A small dialog will open to let you authenticate inside your warehouse, and select the table you want to use as a dataset.

  • We only use your authentication credentials to read the table you want to import, and we don’t store them after the import has finished.

Azure Synapse import

Azure Synapse import lets you retrieve data stored in an Azure Synapse table, and turns it into a dataset inside your Peltarion Platform project.
This allows you to easily train models on large datasets available to you or your company.

Before you can use the Azure Synapse import, you will need to add the following IP addresses to the Azure Synapse firewall:

35.187.12.247
35.233.88.47
20.50.18.88
52.143.2.9

This will allow the Peltarion Platform to connect to your Azure Synapse instance.

To import data, click on the Azure Synapse Import button and follow these 3 steps:

  1. Authentication
    Type in the Server name and Database name that you want to connect to. The server name should be the full address followed by a port number, e.g.,
    my-synapse-server.database.windows.net:1433
    You will also need to enter your personal Username and Password.

  2. Source
    Select the Table that you want to import from the list of tables available to your account.
    The platform creates one dataset from a single, entire table. You might need to create a new table in your Azure Synapse environment before importing it on the platform, especially:

    • If you need data spread across several tables

    • If an existing table has more data (columns or rows) than you need

  3. Preview
    The preview lets you check that the table contains the data you expect before importing it.

When everything looks good click the Create button, and a new dataset will be created from the Azure Synapse table, ready to be used in your project’s experiments!

Was this page helpful?
YesNo