Martin Burch comments

Results 14 comments of


                                            Martin Burch

By default, a stream's `primary_key` should be used for target_options table_keys primary

If implemented, would be good to have two additional configuration patterns ## Explicitly specify no primary key in target table For example, the target may not support primary keys or...

Environment variable overrides only work with YAML config and not Python config.py

I tried using something like `password=os.environ['SQLMESH_LOCAL_PASSWORD']` however the Python file then fails to parse unless _all_ the passwords are defined (with something like `KeyError: 'SQLMESH_LOCAL_PASSWORD'`) This error could be handled...

default_connection type not propagated to gateways connections

Not the same connection _host_, but the same connection _type_. In my example, all my connections are to Microsoft SQL Server databases. What is the point of default_connection if not...

default_test_connection doesn't accept config shown in docs

I would like to add the individual gateway test overrides work fine, e.g. ``` gateways: my_gateway: connection: type: azuresql host: database.windows.net test_connection: type: azuresql host: database.windows.net ``` etc.