Composable DataOps Blog
Composable DataOps Blog
Composable DataOps Platform can be effectively used with Snowflake, a cloud-based data warehousing platform, to optimize and reduce the cost of Snowflake by leveraging Composable’s unique features and capabilities. Here are some ways in which Composable can help in cost…
In this post, we’ll be going over how to configure an ODBC connection to DataBricks within Composable so you can run spark queries from Composable resources (i.e. QueryViews and DataFlows). The first thing you’ll need to do is install the…
Business use cases sometimes demand the orchestration or migration of data from one Relational Database Management System (RDBMS) to another. For example, moving data from MySQL to Oracle, or from Oracle to DB2. In this tutorial, we will work through…
Software engineers have always been told to parameterize their SQL queries. Why? It avoids any possibilities of SQL injection. Rather than an arbitrary value being formatted into the SQL query, the value is sent as a separate named-value pair, and…
We recently had a client who needed to query data from a legacy system built on FoxPro. What is FoxPro you ask? Fox Software was a company Microsoft purchased back in the early 90s, and they developed a system that…
Modern web applications are excellent tools for managing, viewing, and collecting complex data models. With a sleek interface backed by a well-crafted schema, it’s easy to take total control over the data you need to acquire, process, and analyze. But most…
SQL is one of the most powerful tools in a developer’s toolkit — but there are plenty of clients, managers, and even some more technically-inclined engineers who have little to no idea how to write a SQL query that will…