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

...

Following are the type of parameters you can apply for relational sources:

  • Timestamps: Inserts a formatted timestamp when creating a custom SQL query.
  • Variables: Inserts a value for the variable. This variable has a default value that you assign.

    Info

    NOTE: Pattern-based parameters are not supported for relational imports.


For more information, see Overview of Parameterization.

Import Parameterized Tables

...

  1. In the
    D s webapp
    , click Library in the left nav bar.

  2. In the Library page, click Import Data.
  3. From the left side of the Import Data page, select the relational connection from which to import.
  4. Depending on the type of relational connection, you may need to select the database or schema to browse. 
  5. Locate the tables to import. Take note of the table name or names.
  6. Click  Create Dataset with SQL. The Create Dataset with SQL window is displayed.

In this window, you specify the SELECT statement to retrieve the data from a table or tables that you specify. 

...

  1. Create a custom dataset using SQL. For more information, see Create a Custom SQL Dataset above.
  2. In the Create Dataset with SQL window, enter a SELECT* statement to retrieve data from the specified table. Click Validate SQL to verify that the query is properly specified. 
  3. Now, highlight the part of the query that you wish to parameterize. Click the Variable icon. 

    D caption
    Define Variable Parameter
  4. In the Variable dialog, enter the following details:

    Tip

    Tip: Type env. to see the environment parameters that can be applied. These parameters are available for use by each user in the environment. For more information, see Overview of Parameterization.

    1. Name: Enter a display name for the variable.

    2. Default value : Enter a default value for the parameter.
  5. Click Save  to save the parameter.

  6. To verify that your SQL is still valid, click  Validate SQL .

  7. If the SQL is valid, click Create Dataset.

...