Martin Burch

Creating compatible js files for choropleth mapping

2

Is there some documentation available for the structure used by countryData.js and stateData.js? I would like to use other GeoJSON files, such as U.S. counties or legislative districts, but I'm...

Inconsistent handling of nicknames

8

Compare ``` first: Buddy last: Carter official_full: Earl L. "Buddy" Carter ``` to: ``` first: Garland last: Barr nickname: Andy official_full: Andy Barr ``` I like the style of having...

Zero percent margins of error not in agreement

6

This reports +/- 0% for Women 20-24 years old who gave birth in the last year: http://censusreporter.org/profiles/16000US3570500-santa-fe-nm/#fertility  This view reports +/- 1.3% for the same geography and figure. The...

Accept strings instead of just files

1

I'm pulling my CSV files from a web service, so the entire CSV has been loaded as a string into memory already. There is no reason to write it to...

**Describe the bug** Stitcher has shut down their podcasting app. As such, we need to remove the Stitcher share link from the player. When I unchecked Stitcher in "Distribution options",...

Nesting objects by prepending .

4

I'd like to write something like this, but it doesn't seem to be supported. ``` {colors} {.reds} crimson: #dc143c darkred: #8b0000 {.blues} cornflowerblue: #6495ed darkblue: #00008b ``` The `reds` and...

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

3

It is redundant to specify ``` streams: schemaName.tableName: primary_key: Id target_options: table_keys: primary: [Id] ``` However, it seems without the table key being specified, the table is created as a...

MSSQL "The ORDER BY clause is invalid"

1

## Issue Description - Description of the issue: Sling creates a subquery when removing columns, which causes an error in Microsoft SQL Server. As a workaround, https://stackoverflow.com/a/60232533 or remove the...

default_connection type not propagated to gateways connections

3

I have several gateways defined in `config.yaml` which are all using the same connection type. ``` gateways: local: connection: type: mssql host: localhost user: placeholder database: local staging: connection: type:...

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

2

Given a `config.py` like... ``` from sqlmesh.core.config import ( Config, GatewayConfig, MSSQLConnectionConfig ) config = Config( gateways={ "local": GatewayConfig( connection=MSSQLConnectionConfig( host='localhost', user='sa', password='placeholder', database='db', ), ), }, ) ``` Attempting...