dlt.extract.resource
with_table_name
def with_table_name(item: TDataItems, table_name: str) -> DataItemWithMeta
Marks item to be dispatched to table table_name when yielded from resource function.
with_hints
def with_hints(item: TDataItems,
hints: TResourceHints = None,
create_table_variant: bool = False) -> DataItemWithMeta
Marks item to update the resource with specified hints.
Will create a separate variant of hints for a table if name is provided in hints and create_table_variant is set.
Create TResourceHints with make_hints.
Setting table_name will dispatch the item to a specified table, like with_table_name
DltResource Objects
class DltResource(Iterable[TDataItem], DltResourceHints)
Implements dlt resource. Contains a data pipe that wraps a generating item and table schema that can be adjusted
source_name
Name of the source that contains this instance of the source, set when added to DltResourcesDict
section
A config section name
SPEC
A SPEC that defines signature of callable(parametrized) resource/transformer
from_data
@classmethod
def from_data(cls,
data: Any,
name: str = None,
section: str = None,
hints: TResourceHints = None,
selected: bool = True,
data_from: "DltResource" = None,
inject_config: bool = False) -> Self
Creates an instance of DltResource from compatible data with a given name and section.
Internally (in the most common case) a new instance of Pipe with name is created from data and
optionally connected to an existing pipe from_data to form a transformer (dependent resource).
If inject_config is set to True and data is a callable, the callable is wrapped in incremental and config
injection wrappers.
custom_metrics
@property
def custom_metrics() -> Dict[str, Any]
Customizable resource metrics
name
@property
def name() -> str
Resource name inherited from the pipe
with_name
def with_name(new_name: str, new_section: str = None) -> Self
Clones the resource with a new name. Such resource keeps separate state and loads data to new_name table by default.
is_transformer
@property
def is_transformer() -> bool
Checks if the resource is a transformer that takes data from another resource
requires_args
@property
def requires_args() -> bool
Checks if resource has unbound arguments
incremental
@property
def incremental() -> Optional[IncrementalResourceWrapper]
Gets incremental transform if it is in the pipe
limit
@property
def limit() -> Optional[LimitItem]
Gets limit of pages/items on the resource
validator
@property
def validator() -> Optional[ValidateItem]
Gets validator transform if it is in the pipe
validator
@validator.setter
def validator(validator: Optional[ValidateItem]) -> None
Add/remove or replace the validator in pipe
max_table_nesting
@property
def max_table_nesting() -> Optional[int]
A schema hint for resource that sets the maximum depth of nested table above which the remaining nodes are loaded as structs or JSON.
pipe_data_from
def pipe_data_from(data_from: TDltResourceImpl) -> Self
Replaces the parent execution pipe in the transformer by pipe in data_from which typically a resource.
If resource was passed explicitly by the user, it will be stored as explicit parent
add_pipe
def add_pipe(data: Any) -> None
Creates additional pipe for the resource from the specified data
select_tables
def select_tables(*table_names: Iterable[str]) -> Self
For resources that dynamically dispatch data to several tables allows to select tables that will receive data, effectively filtering out other data items.
Both with_table_name marker and data-based (function) table name hints are supported.
add_map
def add_map(item_map: ItemTransformFunc[TDataItem],
insert_at: int = None) -> Self
Adds mapping function defined in item_map to the resource pipe at position inserted_at
item_map receives single data items, dlt will enumerate any lists of data items automatically
Arguments:
item_mapItemTransformFunc[TDataItem] - A function taking a single data item and optional meta argument. Returns transformed data item.insert_atint, optional - At which step in pipe to insert the mapping. Defaults to None which inserts after last step
Returns:
"DltResource"- returns self
add_metrics
def add_metrics(metrics_f: MetricsFunctionWithMeta,
insert_at: int = None) -> Self
Adds metrics collection function defined in metrics_f to the resource pipe at position inserted_at
metrics_f receives data items, meta, and metrics dictionary to update in-place.
Items are passed through unchanged.
Arguments:
metrics_fMetricsFunctionWithMeta - A function taking items, meta argument, and metrics dict. Returns None.insert_atint, optional - At which step in pipe to insert the metrics collector. Defaults to None which inserts after last step
Returns:
"DltResource"- returns self
add_yield_map
def add_yield_map(item_map: ItemTransformFunc[Iterator[TDataItem]],
insert_at: int = None) -> Self
Adds generating function defined in item_map to the resource pipe at position inserted_at
item_map receives single data items, dlt will enumerate any lists of data items automatically. It may yield 0 or more data items and be used to
ie. pivot an item into sequence of rows.
Arguments:
item_mapItemTransformFunc[Iterator[TDataItem]] - A function taking a single data item and optional meta argument. Yields 0 or more data items.insert_atint, optional - At which step in pipe to insert the generator. Defaults to None which inserts after last step
Returns:
"DltResource"- returns self
add_filter
def add_filter(item_filter: ItemTransformFunc[bool],
insert_at: int = None) -> Self
Adds filter defined in item_filter to the resource pipe at position inserted_at
item_filter receives single data items, dlt will enumerate any lists of data items automatically
Arguments:
item_filterItemTransformFunc[bool] - A function taking a single data item and optional meta argument. Returns bool. If True, item is keptinsert_atint, optional - At which step in pipe to insert the filter. Defaults to None which inserts after last step
Returns:
"DltResource"- returns self
add_limit
def add_limit(max_items: Optional[int] = None,
max_time: Optional[float] = None,
count_rows: Optional[bool] = False) -> Self
Limit the number of items that will be processed by the resource: by count and by time. By default, dlt counts number of "yields/batches/pages" not the number of rows inside.
For incremental resources that return rows in deterministic order, you can use this function to process large load in batches.
Notes:
- Transformers won't be limited. They should process all the data they receive fully to avoid inconsistencies in generated datasets.
- Each yielded item may contain several rows. By default
add_limitonly limits the "number of yields", not the total number of rows. - Empty pages/yields are also counted. Use
count_rowsto skip empty pages.
Arguments:
max_itemsint - The maximum number of items (not rows!) to yield, set to None for no limitmax_timefloat - The maximum number of seconds for this generator to run after it was opened, set to None for no limitcount_rowsbool - Default: false. Count rows instead of pages. Note that if resource yields pages of rows, last page will not be trimmed and more rows that expected will be received.
Returns:
"DltResource"- returns self
parallelize
def parallelize() -> Self
Wraps the resource to execute each item in a threadpool to allow multiple resources to extract in parallel.
The resource must be a generator or generator function or a transformer function.
set_incremental
def set_incremental(
new_incremental: Union[Incremental[Any], IncrementalResourceWrapper]
) -> Optional[Union[Incremental[Any], IncrementalResourceWrapper]]
Set/replace the incremental transform for the resource.
Arguments:
new_incremental- The Incremental instance/hint to set or replacefrom_hints- If the incremental is set from hints. Defaults to False.
bind
def bind(*args: Any, **kwargs: Any) -> Self
Binds the parametrized resource to passed arguments. Modifies resource pipe in place. Does not evaluate generators or iterators.
args_bound
@property
def args_bound() -> bool
Returns true if resource the parameters are bound to values. Such resource cannot be further called. Note that resources are lazily evaluated and arguments are only formally checked. Configuration was not yet injected as well.
explicit_args
@property
def explicit_args() -> StrAny
Returns a dictionary of arguments used to parametrize the resource. Does not include defaults and injected args.
state
@property
def state() -> StrAny
Gets resource-scoped state from the active pipeline. PipelineStateNotAvailable is raised if pipeline context is not available
__call__
def __call__(*args: Any, **kwargs: Any) -> TDltResourceImpl
Binds the parametrized resources to passed arguments. Creates and returns a bound resource. Generators and iterators are not evaluated.
__or__
def __or__(transform: Union["DltResource", AnyFun]) -> "DltResource"
Allows to pipe data from across resources and transform functions with | operator This is the LEFT side OR so the self may be resource or transformer
__ror__
def __ror__(data: Union[Iterable[Any], Iterator[Any]]) -> Self
Allows to pipe data from across resources and transform functions with | operator This is the RIGHT side OR so the self may not be a resource and the LEFT must be an object that does not implement | ie. a list
__iter__
def __iter__() -> Generator[TDataItem, None, None]
Opens iterator that yields the data items from the resources in the same order as in Pipeline class.
A read-only state is provided, initialized from active pipeline state. The state is discarded after the iterator is closed.