Import Data from a Database

You can import a variety of data sources. See the following example to import data from a database:

1. Create a Mosaic model or right-click an existing Mosaic model and choose Edit.

2. In the Sources tab, click Add Database.

3. All available data source connections are listed in the Sources view.

   For more information on data sources including creating your own data source, see Create Data Sources.

   Click here to see an example data source connection with Snowflake.

   1. Click Add Database.

   2. Find and choose Snowflake.

   3. Type a Name and optionally type a Description.

      

   4. Expand the Driver drop-down list and choose a driver.

      If you choose Other, enter a Connection String and proceed to step i.

   5. Expand the Connection Method list and choose Standard or Key Pair.

   6. Type your Server name.

   7. If you choose the Key Pair connection method, click Select a File in Private Key File, find your file, and click Open.

   8. Optionally enter your Private Key File Password, Warehouse, Database, Schema, and Role.

   9. Expand the Authentication Mode drop-down list and choose a mode.

      If you choose the Key Pair connection method, only Standard authentication is supported.

   10. To use a vault connection for your database:

       1. Toggle on Use Vault.

       2. Expand the Type drop-down list and choose an option.

       3. Expand the Vault Connection drop-down list and choose an option.

          To create a vault connection, see Create, Edit, and Delete Vault Connections.

       4. Expand the Secret Name drop-down list and choose an option.

   11. Depending on your selections, type a Username, Password, or choose an Authentication Service.

   12. Optionally define Advanced Options.

   13. Click Test and Save.

4. Click a data source connection to connect. The available namespaces display in the Preview page.

   

5. Expand a namespace to view available tables. To search for a table, type its name in the Search.

6. To edit the columns to include or exclude in your Mosaic model, click the View toggle next to a column header or click Pick Columns and select the check box next to the columns you want to display.

7. Add tables to your Mosaic model using one of the following methods:

   • To add a single table to your Mosaic model, hover over a table in the left pane and click Add.

     

   • To add mutliple tables, hold Shift or Ctrl, right click a table, and click Add [X] tables.

     Starting in Strategy One (September 2025), hover over a table, select the check box next to the table, and click Add.

   • Use Auto SQL in Mosaic Studio.

8. To import tables from another database, click All Sources and repeat steps 2 to 8.

9. After you choose your tables, click Proceed.

10. A build progress dialog displays in the bottom left corner. If the model build time is estimated to be more than 10 minutes, your model is saved automatically.

    If you are creating a new model and auto save is triggered, click Edit to manually change the save folder, name, description, and certify status.

11. View and choose suggestions, view object logical relationships, or automatically create attributes and metrics.

12. Click Save or Publish.

13. If you Save your Mosaic model:

    1. Type a Name and Description.

    2. Choose a Save in folder location.

    3. Optionally, select the check box next to Certify Mosaic Model.