Use SQL to load from any data source

Knarr now allows you to load from any of your data sources using SQL directly, which means you can use transformation logic to alias fields, create if/then CASE statements, use string functions, and much more. Knarr supports  most  SQL and MySQL functions, including joins and unions, to give you the ETL power you need when you need it.

If you don’t know SQL, no problem! Knarr will insert SQL code for you that will work to extract your data exactly as it is in your source system, no coding needed.

To learn more, check out this post in our support portal: https://support.knarr.io/hc/en-us/articles/360042877813-Building-a-Data-Model

Keep in mind, you can still only load one table at a time, but you can join multiple tables together from the same source.