TobikoData / sqlmesh

Efficient data transformation and modeling framework that is backwards compatible with dbt.
https://sqlmesh.com
Apache License 2.0
1.52k stars 129 forks source link

Snowflake crashes with validation error for sushi_dbt #353

Closed georgesittas closed 1 year ago

georgesittas commented 1 year ago

Steps to reproduce:

  1. cd examples/sushi_dbt
  2. Set target: snowflake in profiles.yml
  3. Set snowflake credentials as environment variables
  4. Run sqlmesh plan dev

Output:

➜  sushi_dbt git:(main) ✗ sqlmesh plan dev
Error: 1 validation error for Snapshot
__root__
  Invalid control character at: line 1 column 509 (char 508) (type=value_error.jsondecode; msg=Invalid control character at; doc={"name": "sushi.waiter_names", "fingerprint": {"data_hash": "3408768770", "metadata_hash": "2750000337", "parent_data_hash": "0", "parent_metadata_hash": "0"}, "physical_schema": "sqlmesh", "model": {"name": "sushi.waiter_names", "kind": {"name": "SEED", "path": "/Users/georgesittas/Code/tobiko/sqlmesh/examples/sushi_dbt/seeds/waiter_names.csv", "batch_size": 1000}, "dialect": "", "cron": "@daily", "partitioned_by": [], "pre": [], "post": [], "audits": [], "expressions": [], "seed": {"content": "id,name
0,Toby
1,Tyson
2,Ryan
3,George
4,Chris
5,Max
6,Vincent
7,Iaroslav
8,Emma
9,Maia
"}, "source_type": "seed"}, "parents": [], "audits": [], "intervals": [], "dev_intervals": [], "created_ts": 1676064043623, "updated_ts": 1676064043623, "ttl": "in 1 week", "previous_versions": [], "indirect_versions": {}, "version": "2443455409"}; pos=508; lineno=1; colno=509)
tobymao commented 1 year ago

@eakmanrq is this fixed?

georgesittas commented 1 year ago

is this fixed?

I can still repro this issue locally.

georgesittas commented 1 year ago

I can no longer reproduce this issue, so I'm closing it.