Learn how Artie’s internal typing library ensures data integrity and schema evolution across your data sources.
💡 Pro Tip: For non-relational sources, insert a row with actual values to trigger schema propagation downstream — Artie will inspect the data type and infer the correct type in the destination.
What happens if type conversion fails?
5
→ Integer"5"
→ String5.0
→ Float
💡 Pro Tip: If you prefer to store JSON as a string, you can explicitly specify the column type as STRING
in your schema.
time.Time
object.
💡 Pro Tip: Like JSON objects, you can override time type inference by specifying your preferred data type in the schema.
Postgres variable numeric
Why do we treat a variable numeric column differently?We treat this column type differently because Postgres will allow you to store arbitrary amount of digits in each cell up to the . This exceeds most destination’s numeric data type limits, as such we will create a string equivalent column to preserve data precision.