ClickHouse
ClickHouse is an open-source, columnar, OLAP(Online Analytical Processing) database designed for extremely fast analytical queries on large data volumes.
Popular fields deployed in: ad-tech, IoT, BI and more.
ClickHouse is fast because:
- Columnar Storage.
- Vectorized Execution.
- Data Compression.
- Skip Indexes.
- Multi-threaded by default.
- Merge Tree Engine.
Key architectural concepts:
a) MergeTree Tables.
b) Distributed Tables.
c) Materialized Views.
d) Time To Live(TTL).
Managed V/S Unmanaged Tables in Databricks
Basic Bash Scripts
Basic Bash Commands
Set VS Multiset Tables in Teradata
Column Family Databases
Column family databases are used to store unstructured, tabular data made up of rows and columns.
Keys in Relational Database
Primary Key: Primary key must be unique in a table.
Foreign Key: Foreign key is used to provide linkages between tables.
Index Key: Index key used for searches.
Snowflake SnowPro Core
Snowflake SnowPro Core is one of the certification exams offered by Snowflake as part of the SnowPro certification program. It is designed for individuals who have experience working with Snowflake and focuses on core concepts and functionality of the Snowflake platform. The exam covers topics such as data loading, querying, data modeling, security, performance, and resource management. To earn the Snowflake SnowPro Core certification, individuals must pass the SnowPro Core exam.
PySparkShell application UI
