Skip to content

featherTotable

Load data from a Feather file and return the table name.

featherToTable(
    path,
    query="",
    dataTypes=dict()
)

Duplicate column names

If there are multiple columns with the same name, only the left-most column is kept. Column names are case-insensitive. For more info, see the page about column names.

Arguments

path

A string representation of the path to the Feather file.

Both absolute and relative paths are supported. If the path is relative, it's considered relative to the model file (e.g. the model workbook). Environment variables (e.g. %temp% or %homepath%) are also supported.

query

An optional query to be applied to the table. See SQL queries for details.

An empty argument or empty string here means that no query will be performed, i.e. all data from the Feather file will be used.

dataTypes

A mapping of column names to data type specifiers. See data types for details.

When not using a SQL query:

  • For columns not given in dataTypes: The data types from the Feather file will be preserved. A default number format is chosen for each data type.
  • For columns given in dataTypes: The data in that column will be coerced to the specified type.

When using a SQL query:

  • For columns not given in dataTypes: The data types returned by the SQL query will be used. A default number format is chosen for each data type.
  • For columns given in dataTypes: The data in that column will be coerced to the specified type before AND after the SQL query is applied.