Surrogate Keys

Surrogate Keys – overview

Allgemeiner Text zu Surrogate Keys und Natural Keys in ETL-Prozessen.

Surrogate Keys in Snowflake

Platzhalter-Intro-Text für Snowflake zum Thema Surrogate Keys.

SNOWFLAKE – code

-- snippets/surrogate-keys/code-snowflake.sql
-- Platzhalter-Code für Joins in Snowflake
SELECT
    c.customer_id,
    c.customer_name,
    o.order_id,
    o.order_date
FROM customers c
JOIN orders o
  ON o.customer_id = c.customer_id;

Kurzfazit zu Surrogate Keys in Snowflake. Platzhalter-Text.

Surrogate Keys in BigQuery

Platzhalter-Intro-Text für BigQuery zum Thema Surrogate Keys.

BIGQUERY – code

-- snippets/surrogate-keys/code-bigquery.sql
-- Platzhalter-Code für Joins in BigQuery
SELECT
    c.customer_id,
    c.customer_name,
    o.order_id,
    o.order_date
FROM customers c
JOIN orders o
  ON o.customer_id = c.customer_id;

Kurzfazit zu Surrogate Keys in Big Query. Platzhalter-Text.

Surrogate Keys in Synapse

Platzhalter-Intro-Text für Synapse zum Thema Surrogate Keys.

SYNAPSE – code

-- snippets/surrogate-keys/code-synapse.sql
-- Platzhalter-Code für Joins in Synapse
SELECT
    c.customer_id,
    c.customer_name,
    o.order_id,
    o.order_date
FROM customers c
JOIN orders o
  ON o.customer_id = c.customer_id;

Kurzfazit zu Surrogate Keys in Synapse. Platzhalter-Text.