Import table
Overview
Import table is a table type that stores data imported from an external source.
Function
Use this type when external source data needs a landing or staging table in the warehouse. Selecting it is populated by an import definition or import package.
When to use
Choose Import table when external source data needs a landing or staging table in the warehouse.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Configure the schema, columns, import relationship, and package settings. |
| Processing | An import process loads source rows into the table. |
| Output | The table provides staged data for transformations, historization, or downstream processing. |
Type-specific properties
| Property | Description |
|---|---|
| Source relationship | Import definition that supplies the table. |
| Columns | Physical columns populated by the import. |
| Package | Import package that executes the load. |
| Load options | Import behavior such as filters, scripts, and buffer settings. |
Compatibility and limitations
The source-to-target mapping and connector determine available data and conversion behavior.
Relationships
| Related entity | Relationship |
|---|---|
| Table | The table type defines the purpose and behavior of the table entity. |
| Schema | The schema type and warehouse architecture influence which table types are normally used. |
| Package | Import, historization, and persisting packages can populate specific table types. |
