Contents:
Basic Import Process
There are multiple ways to import data into #UNKNOWN_PRODUCT_EDITION#, but the most direct way is to import through the Library, where all imported datasets are stored. In the Designer Cloud application, click the Library icon in the left nav bar.
Figure: Library Page
Import Data
The Library displays all of the datasets to which you have access. To begin, click Import Data.
Figure: Import Data Page
When you import data, you are selecting a connection to use, which allows you to begin navigating the connected datastore. When you locate the file or table assets, you select it for import.
NOTE: When you import a dataset, you are creating a reference to that source dataset. Data is not actually imported until #UNKNOWN_PRODUCT_EDITION# needs to use the data for job execution. Source data is never modified.
Need data? You may have example flows available in your workspace. Also, check out the available example datasets. See Example Datasets.
Default Connections
#UNKNOWN_PRODUCT_EDITION# provides pre-configured connections to storage. Depending on your environment, you may be able to immediately access data through the following datastores, which are represented by icons in the Import Data page:
| icon | Connection | Description |
|---|---|---|
| Upload | Upload a file from your local desktop. Tip: You can always upload a file from your local desktop for immediate use in the application. Details are below. |
| File-based storage | #UNKNOWN_PRODUCT_EDITION# provides a connection to a primary file-based storage system. Also known as the base storage layer, this storage can be used for hosting datasets for import. Uploaded files are stored on the base storage layer, as well as dataset samples. For more information, see Import a File from Storage. |
| Table-based storage | Your environment may be provided access to a table-based datastore, such as BigQuery or Redshift. From these datastores, you can select the tables or views to which you have access for import as datasets in #UNKNOWN_PRODUCT_EDITION#. For more information, see Import a Table from Storage. |
| Other storage | You can create connections to other file- or table-based storage systems. See below for details. |
Create Connections
You can create a connection to a wide variety of file-based and table-based datastores.
NOTE: Before you create the connection, you must acquire access credentials to the datastore.
In the Import Data page, click the New icon at the bottom of the page. For more information, see Create a Connection.
This page has no comments.