For the data loaded from the raw and unstructured data sources (RESTful APIs, files, feeds) I'd recommend checking tablum.io. The data first gets into the staging SQL DB where you can apply transformations in SQL (ClickHouse dialect with hundreds of ready-to-use functions for aggregations, transformations, string and array processing, etc). After that, you can set up a pipeline to external DWH or DB. Or just... Source: about 1 year ago
Fairly easy to parse it with Python (or any other scripting languages that support regular expressions). Besides, there're no-code parsers that can do that. E.g. tablum.io, it has a regexp parser that turns poorly formatted text into an SQL table. All you need it is to provide the regular expression (regexp) to split the text (per-line basis or the entire text) into chunks that become SQL rows and columns, after... Source: about 1 year ago
You're right. There should be some way to safely pass the authentication token without storing it in the query. BTW, to keep all data within the company network perimeter and no share any keys with the cloud service, one can install tablum.io as a self-hosted version on a Linux server (it runs in Docker). Source: about 1 year ago
Do you know an article comparing TABLUM.IO to other products?
Suggest a link to a post with product alternatives.
This is an informative page about TABLUM.IO. You can review and discuss the product here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.