Error: DEFAULT value is not allowed when jsonpath is set when running Dub.co's pipe

[unrenamed]

Issue Summary

While following the guide to run Dub.co’s codebase locally, I encountered an error when executing tb push. The error message indicates that when you specify a column with a jsonpath attribute, you cannot also provide a DEFAULT value for that column.

The error is caused by 4 files:

1. dub_lead_events.datasource
2. dub_links_metadata.datasource
3. dub_sale_events.datasource
4. dub_webhook_events.datasource

Steps to Reproduce

1. Follow the setup instructions provided in the guide up to Step 2: Set up the Tinybird Clickhouse database.
2. After you run tb push, wait for the command to fail and observe the error message like on the screenshot below.

Expected behavior

The command should execute successfully, creating the essential data sources without errors.

Screenshots

Version info

• Tinybird CLI Version 2.0.0 (rev 40c7bee)
• macOS Version 13.5.2 (22G91)

[linear]

ENG-870 Error: `DEFAULT value is not allowed when jsonpath is set` when running Dub.co's pipe

[steven-tey]

/award 150

[oss-gg]

Awarding unrenamed: 150 points 🕹️ Well done! Check out your new contribution on oss.gg/unrenamed