---
title: "Discussion on \"Migrating Teradata Column Alias References to BigQuery: The UNNEST Pattern Explained\" | Hashnode"
description: "Discussion on \"Migrating Teradata Column Alias References to BigQuery: The UNNEST Pattern Explained\". How Teradata's column alias chaining translates to BigQuery's CROSS JOIN UNNEST pattern — and why migration tools use it"
url: "https://hashnode.com/posts/migrating-teradata-column-alias-references-to-bigquery/69be885081717c29713a06cf"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Migrating Teradata Column Alias References to BigQuery: The UNNEST Pattern Explained](https://datatrail.hashnode.dev/migrating-teradata-column-alias-references-to-bigquery?utm_source=hashnode&utm_medium=feed)

How Teradata's column alias chaining translates to BigQuery's CROSS JOIN UNNEST pattern — and why migration tools use it

Mar 21 · 8 min read · datatrail.hashnode.dev  
Read the article

-   [#bigquery](https://hashnode.com/tag/bigquery)
-   [#teradata](https://hashnode.com/tag/teradata)
-   [#gcp](https://hashnode.com/tag/gcp)
-   [#sql](https://hashnode.com/tag/sql)
-   [#dataengineering](https://hashnode.com/tag/dataengineering)
-   [#cloud-migration](https://hashnode.com/tag/cloud-migration)
-   [#data-science](https://hashnode.com/tag/data-science)
-   [#databases](https://hashnode.com/tag/databases)

## Written by

[SANDEEP KUMAR RAJU SANGARAJU](https://hashnode.com/@sangarajus)

@sangarajus · San Francisco, USA

  
[View profile](https://hashnode.com/@sangarajus)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.