dlt.destinations.dataset.dataset
ReadableDBAPIDataset Objects
class ReadableDBAPIDataset(SupportsReadableDataset[ReadableIbisRelation])
Access to dataframes and arrow tables in the destination dataset via dbapi
ibis
def ibis() -> IbisBackend
return a connected ibis backend
is_same_physical_destination
def is_same_physical_destination(other: "ReadableDBAPIDataset") -> bool
Returns true if the other dataset is on the same physical destination helpful if we want to run sql queries without extracting the data
row_counts
def row_counts(*,
data_tables: bool = True,
dlt_tables: bool = False,
table_names: List[str] = None,
load_id: str = None) -> SupportsReadableRelation
Returns a dictionary of table names and their row counts, returns counts of all data tables by default
__getitem__
def __getitem__(table_name: str) -> ReadableIbisRelation
access of table via dict notation
__getattr__
def __getattr__(table_name: str) -> ReadableIbisRelation
access of table via property notation
__enter__
def __enter__() -> Self
Context manager used to open and close sql client and internal connection