I have a source table like below,
| ID | Column | value |
|---|---|---|
| 1 | apple | 10 |
| 1 | apple | 8 |
| 1 | banana | 9 |
| 1 | banana | 12 |
I have a target table like below,
| ID | apple | banana |
|---|---|---|
| 1 | 10 | 9 |
| 1 | 8 | 12 |
How do I test/verify this using snowflake
I have a source table like below,
| ID | Column | value |
|---|---|---|
| 1 | apple | 10 |
| 1 | apple | 8 |
| 1 | banana | 9 |
| 1 | banana | 12 |
I have a target table like below,
| ID | apple | banana |
|---|---|---|
| 1 | 10 | 9 |
| 1 | 8 | 12 |
How do I test/verify this using snowflake