bigquery-emulator icon indicating copy to clipboard operation
bigquery-emulator copied to clipboard

Add support for `DEFAULT`

Open criccomini opened this issue 2 years ago • 2 comments

I'd like to be able to create tables like this:

CREATE TABLE `test_dataset.test_table_default` (
    test_string STRING DEFAULT "default_value"
)

When I do this right now, it executes, but the table doesn't seem to exist after.

See here for syntax:

https://cloud.google.com/bigquery/docs/default-values#set_default_values

criccomini avatar Jul 19 '23 19:07 criccomini

I've put up a first-pass of this functionality here https://github.com/goccy/go-zetasqlite/pull/211

ohaibbq avatar Apr 14 '24 20:04 ohaibbq