String

GENERATE_UUID

BigQuery

Menghasilkan UUID (Universally Unique Identifier) versi 4 secara random.

Tipe hasil: STRING

Syntax

SQL

GENERATE_UUID()

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT GENERATE_UUID() AS new_id;

Generate UUID baru.

Hasil

new_id: 7f1d5c3e-8a2b-4f9c-b1d2-3e4f5a6b7c8d

SQL

1 INSERT INTO events (id, event_type, created_at)
2 VALUES (GENERATE_UUID(), 'page_view', CURRENT_TIMESTAMP());

Insert record dengan UUID sebagai primary key.

Hasil

(inserted with UUID)

UUID

MySQL

1	INSERT INTO events (id, event_type, created_at)
2	VALUES (GENERATE_UUID(), 'page_view', CURRENT_TIMESTAMP());