Add column in table/dataset

1

How to add a column in a table? Or if possible with default value.

2

46 PM
Screen Shot 2017-08-14 at 11.39.46 PM.png2790×502 42.1 KB

See if above serves your needs

1 Like
3

how can i column with string values?

As i’ve tried to add a column, it needs to add/input in calculated field.

4

Try something like this:

SELECT A, ‘abc’ AS new_field, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W
FROM somesource.data.“somedata”

I highlighted your new field expression in bold
So your new_field will be string ‘abc’