Search Results for "snowflake"

PeerDB is an open-source platform for real-time replication and transformation of data from PostgreSQL to analytical warehouses like BigQuery and Snowflake. It supports Change Data Capture (CDC) and provides seamless syncing and transformation logic with low latency. PeerDB is ideal for teams building real-time data pipelines without relying on expensive proprietary solutions.

A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, SAP HANA, Cassandra, Snowflake, Google BigQuery, SQLite, TiDB, and many more via ODBC. The docker image runs on port 3000 and uses /var/lib/sqlpad for the embedded database directory. latest tag is continuously built from latest commit in repo. Only use that if you want to live on the edge, otherwise use specific version tags to ensure stability. See docker-examples directory for example docker-compose setup with SQL Server.

...Liquibase Core works with the following databases: Apache Derby, CockroachDB, Firebird, H2, HSQL, Informix, InterBase, MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, SQLite, Sybase Anywhere, Sybase Enterprise. The databases that require extensions are: Azure Cosmos DB, Cassandra, Cache, DB2i, Hibernate, Impala/Hive, MaxDB, MongoDB, Redshift, SAP HANA, SQLFire, Snowflake, Teradata, Vertica, VoltDB. See Liquibase Database Tutorials. Liquibase can be integrated with Maven, Ant, Gradle, Spring Boot, and other CI/CD tools.

...Processing any updates or deletes once data arrives has not been possible- until now. StarRocks solves these challenges and makes real-time analytics easy. Get amazing query performance on Star or Snowflake Schemas directly. From canceled orders to updated items, your analytics applications can easily handle them with StarRocks. From streaming data to change data capture, StarRocks meets the data ingestion demands of real-time analytics. Scale storage and computing power horizontally and support tens of thousands of concurrent users. ...

...Over 20 supported databases out of the box including: PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, ClickHouse, Influx 1 (InfluxQL), Influx 2 (Flux), Prometheus, Elasticsearch, AWS Athena, Google BigQuery, Snowflake, Cassandra, Scylla, TimescaleDB, YugabyteDB, CockroachDB, CrateDB, QuestDB, and Airtable.

...Unlike older database plugins which required many commands or separate UI components, dadbod uses a simple model: you connect using a single connection URL and issue queries with a unified :DB command. It supports a wide array of backends — from PostgreSQL, MySQL, SQLite, Redis, MongoDB, BigQuery, Snowflake and more — via adapters. Results of queries are displayed in preview windows or splits inside Vim, allowing you to stay in your editing context rather than switching to a separate tool. You can also run ranges or whole buffers as SQL queries or pass files to the database CLI. The plugin is designed to be project-aware: connection URLs can be defined per project rather than globally.

A tool that parses SQL Select statements and generates a diagram. The diagram shows parts of the underlying SQL directly in the diagram. For example x=30 , GROUP BY (year), HAVING MIN(age) > 18. It is easy to see cartesian joins and/or loops.

Snowflake is a CASE Tool directed towards data warehousing projects. Through an easy to use graphical interface, it allows the construction of a conceptual design of the data warehouse or data mart, using a simple multidimensional notation.

Decima is a database that was designed to support time-series data mining. It consists of PostgreSQL custom type definition, implementation of GiST index for that type and snowflake database schema.