From DB
From DB - Overview
The From DB process in Syntasa is a powerful in-built process that allows users to extract data directly from external databases into the Syntasa environment. This enables seamless data ingestion from sources like PostgreSQL, SQL Server, Amazon Athena, and other supported databases.
Extracting Data From Database Using From DB Process (Non Partitioned Output Data)
One of the most fundamental tasks in any data workflow is extracting data from a source database. The Syntasa From DB process provides a streamlined and powerful way to accomplish this. This guide will focus on the simplest extraction method: creating a non-partitioned output.
Extracting Data From Database Using 'From DB' Process and Storing it in Daily Partitioned Format
One of the key capabilities in Syntasa’s data platform is extracting and organizing data efficiently from external databases. The From DB process allows you to not only fetch data but also store it in a partitioned format—ideal for performance, scalability, and incremental processing.
Extracting Data From Database Using 'From DB' Process and Storing it in Hourly Partitioned Format
One of the powerful capabilities of the From DB process in Syntasa is the ability to partition extracted data based on hourly granularity. This is especially useful for high-frequency datasets where data is continuously ingested throughout the day and needs to be organized hour-wise for optimized…