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

Hi all, I'm excited to share the new project I've been working on called AI2sql. Check it out here: http://ai2sql.softr.app If you're writing SQL queries, you should try AI2sql. Let's you ask questions in plain English and then AI2sql translates it into SQL, so you can focus on the data and not the syntax. Thanks for taking the time to have a look at this project, I'd appreciate any feedback you might have on... Source: over 2 years ago

I’ve upgraded AI2sql (generate SQL in seconds) ai2sql.softr.app to use the InstructGPT and its results are better than ever. Source: over 2 years ago

Offering a simple interface, the tool aims to create SQL queries for non-engineering users. You can try it here: http://ai2sql.softr.app. Source: over 2 years ago

Thought you might be interested in the AI2sql tool. It allows you to simply and easily build SQL queries, so you don’t have to learn any coding. It’s great for beginners or advanced users who find coding a hassle. Source: over 2 years ago

AI2sql is an easy-to find tool which will take your SQL coding to the next level. It will help you easily write highly complex and powerful queries within seconds powered by AI. http://ai2sql.softr.app. Source: over 2 years ago