Skip to content

Database: Support 3-component table names (catalog.schema.table aka. project.dataset.table) #224

Description

@amotl

Status quo

Currently, table names must be in the format <schema>.<table>. This means dlt_run_params will assign those values to dataset_name, table_name.

Pitch

For generalization purposes, let's start addressing database resources by catalog.schema.table going forward.

Details

Assign those component values to dlt_run_params' project_name, dataset_name, table_name. For some databases like DuckDB, "catalog = attached database". For a full mapping of triples across different database dialects, see ingestr's new capabilities.go. The alternative project.dataset.table jargon is apparently used by BigQuery. While being at it, bundle the triple into a dataclass object and add corresponding parsing and validation methods instead of spreading them across the codebase.

References

Metadata

Metadata

Assignees

No one assigned

    Labels

    help wantedExtra attention is neededrefinementSmall steps for enhanced robustness and details done right.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions