Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

  • From the menubar, click Library.
  • In the Library page, click Import Data.
  • From the left sidebar in the Import Data page, select the connection to the relational datastore where your data is located.
  • Browse the relational datastore to locate the table that you wish to import.

  • You must have read permissions on any database and table that you wish to import. For more information, see Using Databases.

...

  • Create Dataset with SQL: You can apply a custom SQL statement to import from a database. For more information, see Create Dataset with SQL.

  • Some aspects of the import process can be modified. In the right panel, click Edit Settings for a table that you have imported.
    • The application's data types are applied to the table's columns during the import process. If needed, you can disable type inference, so that the data types of the original source are preserved, if possible, during import. For more information, see Disable Type Inference.
  • When you are ready to complete the import process:

    Tip

    Tip: If present, you can click the Add to new flow checkbox, which adds the imported datasets to an Untitled flow. For more information, see Flow View Page.

    • If you are importing a single table: click Continue to load to add it to a new flow, create a recipe for the imported dataset, and begin editing that recipe. See Transformer Page.
    • If you are importing multiple tables: click Continue to load them into a new flow. See Flow View Page.
  • Your tables are available as imported datasets.

...