Create a Mosaic Model Using Mosaic Studio and Import Data

You can create Mosaic Studio and import data from a database by selecting tables to retrieve data from the source. An intuitive visual interface makes it easy to import your data by dragging and dropping tables.

Importing data from a database requires a connection to a data source. You can Create Data Sources before you begin importing or during the import process.

Prerequisites

To create and edit Mosaic model, using Mosaic Studio, you need the following privileges:

• Use Mosaic Studio

• At least one of the following:

  • Access data (files) from Local, URL, DropBox, Google Drive, Sample Files, Clipboard, Push API

  • Access data from Databases, Google BigQuery, Big Data, OLAP, BI tools

  • Access data from Cloud Apps (Google Analytics, Salesforce Reports, Facebook, Twitter)

Create a Mosaic Model Using Mosaic Studio

1. Open Strategy Library.

2. Choose Create New > Mosaic Model.

3. Choose a Project.

   

4. Click OK.

Import Data and Add a Database

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

2. If needed, click Sources and Add Tables.

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. Depending on your selections, type a Username, Password, or choose an Authentication Service.

   11. Optionally define Advanced Options.

   12. 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.

   • 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.