dub icon indicating copy to clipboard operation
dub copied to clipboard

tb push error while setting up tinybird database

Open alex-guoba opened this issue 1 year ago • 1 comments

error message while execute tb push.

** 'dub_click_events' created
** Running 'dub_links_metadata'
** 'dub_links_metadata' created
** Running 'dub_click_events_pipe'
Error:
** Failed running ./pipes/dub_click_events_pipe.pipe:
** Invalid results, read description below to fix the error:
** Failed pushing pipe dub_click_events_pipe__checker: [Error] Missing columns: 'ip' 'qr' while processing query: 'SELECT timestamp, click_id, link_id, url, country, city, device, browser, os, referer, qr, ip FROM utopian.dub_click_events AS dub_click_events', required columns: 'click_id' 'link_id' 'timestamp' 'os' 'country' 'url' 'browser' 'city' 'qr' 'ip' 'referer' 'device', maybe you meant: 'click_id', 'link_id', 'timestamp', 'os', 'country', 'url', 'browser', 'city', 'referer' or 'device'. (UNKNOWN_IDENTIFIER)

it seems 'ip' 'qr' field not decleared in datasource dub_click_events.datasource.

alex-guoba avatar May 14 '24 09:05 alex-guoba

Should be fixed now! sorry for the issue

steven-tey avatar May 21 '24 16:05 steven-tey