What are the specific requirements for data structure/database/data format to fetch historical data in Tulip using SQL or CSV?
Tulip’s SQL connector functionality is very robust as you can basically write any SQL query and pull data into your applications. There is a good introductory article here and they support most SQL db drivers in my experience. You can use the exact same concept for writing insert and update functions as well. However, I generally recommend avoiding direct SQL connections whenever possible and instead prefer to integrate via a REST API layer.
Regarding CSV data, you are not currently able to integrate with CSVs directly. CSVs must be uploaded to Tulip Tables manually or you can utilize Tulip API scripting to upload CSV data from a local or cloud hosted script.
1 Like