Schema Variant Column
Recognize values moved into a variant column after a type conflict, reconcile split values, and separate successful loading from correct meaning.
-
-
Nested Data Normalization
Flatten nested objects and arrays into tables with explicit parent links and child grain, and handle empty lists without leaving stale rows.
-
Data Connector
Evaluate a data connector by extraction coverage, state, schema handling, load behavior, and recovery rather than by a catalog entry alone.
-
Managed Ingestion: Fivetran, Airbyte, and dlt
Decide when to buy, operate, or write a connector, and verify its cursor, nested tables, schema changes, failure handling, and total cost.