Fuzible integrates a data analyzer which is used in many cases :
- When a Target SQL table has to be created
- When the “Allow Schema Alteration in Target” option is checked
- In Synchronization Mode
- When performing some filtering on a non-SQL Source Data
The goal is to determinate the best datatype for any field. It’s an extremely fast algorythm but depending of the computer you’ve installed Fuzible on, it can be quite stressful, that’s why you can select a scanning level in the Source menu.
The less you analyze rows, the less you’ll get an accurate data schema.
Exemple of a MySQL table created from a CSV file (which has, by definition, no data schema) :