DuckDB Reader Parameters

About Database Connections

Database formats include a Database Connection parameter that defines and stores authentication information. For general information about sharing database connections, please see Using Database Connections. Using Database Connections.

Note that Database Connection parameters differ slightly, depending on context and/or database format.

Connection

From the Connection parameter in a database format, you can do one of the following:

  • Select an existing, previously defined connection. See the section Reusing a Database Connection in Using Database Connections
  • Select Add Database Connection to define a new connection. See database-specific parameters below, as well as the section Adding a Database Connection in a Workspace in Using Database Connections. The new connection can be made visible only to the current user, or can be shared among multiple users.

Database Connection

DuckDB File

As part of a DuckDB connection, you may specify the DuckDB file. This can be one of the following:

  1. DuckDB Database – The name of the DuckDB database file or a URL.
  2. Other Format – The name of a CSV, Parquet, or JSON file, or a URL.
  3. Other – One of the following special values:

    • :memory: – This option establishes a shared in-memory database connection across the workspace. It is useful for temporary data storage and quick data processing.

    • <default> – This setting specifies the use of the system's predefined default connection configuration, which writes to a temporary file. It is generally suggested for larger temporary datasets.

Constraints

After specifying the database connection, click the Browse button (...) to select tables for import. A connection window appears while the system retrieves the tables from the database.

Once the Select Tables dialog appears, you can select one or more tables. Click OK to dismiss the window and add the selected table name(s) to the Tables parameter.

Schema Attributes

Additional Attributes to Expose

Use this parameter to expose Format Attributes in FME Workbench when you create a workspace:

  • In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
  • In a non-dynamic scenario, this parameter allows you to expose additional attributes on multiple feature types. Click the browse button to view the available format attributes (which are different for each format) for the reader.